Importing from an Informix ODBC Provider Data Source
The CONNX Informix module provides access to Informix data source objects through the Informix ODBC driver.
For multiple connections to Informix via ODBC through a single CONNX Data Dictionary, either the Informix data source name must be a file-based DSN and installed on a shared network server, or the same DSN must be configured on each client computer.
Important:
The selected data source driver must be installed on all client machines that have access to the data source tables since they will be using the same DSN (Data Source Name).
To import tables from an Informix ODBC data source:
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select Informix from the Import Type list box.
3. Select ODBC Provider under Select Provider Type, and then click the Select DSN button in the Logon Information pane.
4. Select a user, system, or file based DSN in the Select OBDC DSN dialog box and click the OK button.
We recommend you use a file DSN, because it can be accessed through a network by multiple users.
Your ODBC data source may require additional information. Review the documentation provided by your driver vendor for additional configuration options.
Click the
Browse for File DSN button to open a file browser in which you can browse to a .dsn file.
Alernatively, mark the
Show Only System DSN check box to view a list of system DSNs. Clear the check box to show a list of both user and system DSNs.
The ODBC Driver Information text box displays information about the selected ODBC DSN. The same information can be found in the ODBC Data Source Administrator dialog box.
5. If necessary, check the following boxes:
The
Include System Tables check box to access system tables.
The
Get Statistics check box to identify table sizes. This is used by the CONNX query optimization.
6. Click the OK button.
The CONNX Import Table Selection dialog box appears with a list of available table names.
7. Click the Add or Add All button to move the tables to the Select Tables for Import pane.
8. Click the OK button to import the selected tables into CONNX.
The imported tables are added to the list of accessible objects in the CONNX Data Dictionary Manager window.