Home >

AX1397

Import source: ODBC

Use the ODBC option on the Import Wizard's Source tab to connect to any database that supports Open Database Connectivity. Generally speaking, this option should only be used if no other option is available to connect to your desired database. If you are connecting to a SQL Server or Oracle database, the database-specific options should be used instead.

The Source tab of the Import Wizard uses the following settings when importing data using an ODBC connection.

Item	Description
Import source	Select ODBC to read data directly from a database using an ODBC connection.
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 {DefaultRemoteDataConnection} to automatically use the default remote data connection for your system. For information on how the default remote data connection is determined, see System variables. Remote data connections are defined in Scheduler. For more information, see Managing remote data connections. If no remote data connections have been defined in your system, then this setting does not apply and will not display.

Connection

The connection string identifies the name and location of the database to connect to, including any necessary authentication credentials. The connection string requirements and syntax vary depending on the source database you are attempting to connect to. Consult the documentation from your database vendor to determine an appropriate ODBC connection string for this purpose.

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.

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: If the connection string contains a password, that 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.

NOTE: The syntax of the SQL statement cannot be validated when using ODBC as the source.

ODBC driver

Use of ODBC requires an ODBC driver to be installed on the following servers:

• For on-premise systemsAxiom Software systems that are installed on the customer's premises. All servers and technical requirements are managed by the customer., the driver must be installed on the Axiom Software Application Server.
• For cloud service systemsAxiom Software systems that are accessed using the Axiom Cloud Service. Technical requirements are managed by Axiom Support; no server software is installed on the customer's premises., the driver must be installed on the local server that is hosting the Axiom Software Cloud Integration Service.

The ODBC driver is specific to your source database. If you want to use ODBC with a particular database, that database vendor should provide or recommend an ODBC driver for use with that database.