CONNX Data Integration Suite 14.8.0 | Operations Guide | Working with Database Objects in CONNX | CONNX Basics | Working with CDDs | When Importing Existing Table Definitions
 
When Importing Existing Table Definitions
The following table definitions can be imported into the CONNX Data Dictionary:
*COBOL FD (File Definition)
*Codasyl DBMS database
*DataFlex
*POWERFlex
*DIBOL
*Formatted DDL (Data Definition Language)
*Powerhouse PDL (Powerhouse Definition Language)
*Rdb database
*SCT COBOL FD
*Specification text file (RMS)
*VAX, ALPHA, or Itanium (RMS only) CDD
*OLE DB- and ODBC-compliant data sources
*DB2 data sources
*Oracle data sources
*VSAM data sources
*IMS data sources
*Sybase data sources
*Informix data sources
*Adabas data sources
Once you import the metadata and define the table properties, you must save the CDD and create an ODBC data source name. This enables access t9 and manipulation of the data in the imported tables. Depending on the front-end application and the types of databases that exist in your system, you can use the imported metadata to create new database objects, or to update or incorporate data quickly and efficiently.
Once table definitions are imported, column, field, and row names can be changed independently of their source data. Note that any changes made in the table metadata imported into the CDD do not affect the source data in any way.