On this page
AX2436
Import source: SQL Server
The Source tab of the Import Wizard uses the following settings when importing data from a SQL Server database.
| Item | Description |
|---|---|
| Source | Select SQL Server to read data directly from a SQL Server database. |
|
Remote Data Connection |
If your Axiom Software system is hosted on the Axiom Software cloud service, then you must specify a remote data connection so that the cloud service can connect to the database server located on your network. You can select any remote data connection defined in your system, or you can enter an import variable name. For example, you can enter the built-in system variable Remote data connections are defined in Scheduler. If no remote data connections have been defined in your system, then this setting does not apply and will not display. |
Connection
Complete the following connection information for the import source. Once you have completed the connection settings, click the Test connection button 
to test the connection. The Status updates to show either a success message or an error message.
NOTE: This information is only used to connect to the source and extract the data into the import temptable. Transformation steps are not performed using these credentials.
| Item | Description |
|---|---|
|
Server |
The name of the SQL Server. |
|
Database |
The name of the database. |
|
User |
The user name to use to connect to the specified server and database. The user credentials must be for a SQL Server account; network domain credentials cannot be used. |
|
Password |
The password to use to connect to the specified server and database. NOTE: The password must be re-entered whenever any of the other connection properties are changed. |
SQL Select Statement
The SQL SELECT statement defines the data query to the source database, resulting in the set of data to be imported to the temptable. You can then perform mapping and transformations on the data before importing into the destination table.
In the SQL Select Statement box, enter any valid SQL statement to define the data query. You can click the SQL editor button 
to open the Edit SQL dialog. This dialog provides a text editor for entering and reviewing large SQL statements, and several tools to check the statement. For more information, see Creating the SQL SELECT statement.
Variables can be used in the SELECT statement. See Using variables in imports.
|
Get more information and training resources: www.kaufmanhall.com |
Was this topic helpful? source_sql_server.htm |
