Importing an Existing Table from an ODBC-compliant Data Source Object Using the CONNX Adapter - Desktop Module
To import a table with the desktop adapter:
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select Desktop OLE DB/ODBC Adapter from the Import Type list box.
3. Select ODBC Provider under Select Provider Type.
4. Click the Select DSN button in the Logon Information pane.
5. Select one of the following in the Select ODBC DSN dialog box and click the OK button:
File DSN (Recommended) - Click the
Browse for File DSN button browse to a file DSN from lists of available .dsn files. We recommend this because a file DSN can be used through a network by multiple users.
System DSN or User DSN - Select 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. Note that 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.
6. Some ODBC databases support catalogs. To specify a catalog, enter a name and password for the database and then click the Select Catalog button to log into the database and view a list of available catalogs.
Your ODBC data source may require additional information. Review the documentation provided by your driver vendor for additional configuration options.
7. Select a catalog, and then click the OK button to return to the Import CDD dialog box. Normally, only user-defined tables can be selected for import.
8. Select the Include System Tables check box to access system tables.
9. Select the Get Statistics check box to identify table sizes. This is used by CONNX query optimization.
10. Click the OK button. The CONNX Import Table Selection dialog box appears with a list of available table names.
11. Click the Add or Add All button to move the tables to the Select Tables for Import pane.
12. 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.