To import an existing table from an OLE DB-compliant data source using the CONNX Adapter

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

  2. The Import CDD dialog box appears. Select Enterprise OLE DB/ODBC Adapter from the Import Type list box in the Import CDD dialog box.

    OLE_01.jpg
     

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

    OLE_02.jpg
     

  4. Select an OLE DB Provider from the list shown in the Data Link Properties dialog box. Click the Next button or the Connection tab.

    image\60_04Enter_OLE_02.jpg
     

  5. Enter a data source name in Item 1 on the Connection tab in the Data Link Properties dialog box.

    image\60_04Enter_OLE_03.jpg
     

  6. Enter a user name and password in section 2.

  7. Select an object from the list box in Item 3. Click the Test Connection button to verify that it is available. Click the OK button.

  8. The Import CDD dialog box appears. Reenter the user name and password, if required.

  9. Normally, only user-defined tables can be selected for import. Select the Include System Tables check box to enable the import of non-user-defined tables.

  10. Select the Get Statistics check box to identify the table sizes. This is used by CONNX query optimization. Click the OK button.

  11. The CONNX Import Table Selection dialog box appears. Click the Add or Add All button to move the database objects to the Select Tables for Import pane.

    image\oledb_4.jpg

  12. Click the OK button to import the selected objects into CONNX. The imported catalogs appear in the list of accessible objects in the CONNX Data Dictionary Manager window.