To import tables from an Informix ODBC provider data source

  1. Click the Import button in the CONNX Data Dictionary Manager window.

  2. The Import CDD dialog box appears. Select Informix from the Import Type list box.

    Inf_01.jpg

  3. Select ODBC Provider under Select Provider Type, and then click the Select DSN button in the Logon Information pane.

  4. The Select ODBC DSN dialog box appears. You can choose either a user-, system-, or file-based DSN, although it is recommended that a file DSN be used, since it can be accessed through a network by multiple users.

    image\60_07Infor_05.jpg

  5. Your ODBC data source may require additional information. Review the documentation provided by your driver vendor for additional configuration options.

  1. File DSN (Recommended)
    Select the Browse for File DSN check box to open the Open dialog box. Select a file DSN from lists of available .dsn files.

  2. System DSN or User DSN
    Select the Show Only System DSN check box to view a list of system DSNs only. 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. Click the OK button in the Select ODBC DSN dialog box to return to the Import CDD dialog box, which displays the selected DSN.

  1. The Import CDD dialog box appears.

    Inf_02.jpg

  2. Select the Include System Tables check box to access system tables.

  3. Select the Get Statistics check box to identify table sizes. This is used by the CONNX query optimization.

  4. Click the OK button. The CONNX Import Table Selection dialog box appears with a list of available table names. Click the Add or Add All button to move the tables to the Select Tables for Import pane.

    image\60_07Infor_07.jpg

  5. 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.

    image\60_07Infor_08.jpg

Related Topic

image\CHICLET.jpg CONNX Informix Data Module