The CONNX Data Dictionary (CDD)

The CONNX Data Dictionary (CDD) is a repository of information describing the data tables and fields in the accessed databases, including security. The CDD contains the metadata about the source information and provides easy maintenance of the metadata, views, and integrated security. The CDD:

  • Can reside on the client computer, a shared server disk, or in a Pathworks area on an OpenVMS system.

  • Describes the structures of the tables or files being accessed.

  • Enables multiple views of the same data.

The types of CDD objects that can be accessed include the following:

  • Adabas data sources (z/OS, VSE, Windows, Unix [AIX, Linux, HP-UX, Solaris]platforms)

  • Disparate data sources, including databases, flat files, and other types, including both Unix and Windows

  • Tables that reside within each data source

  • System tables for relational data sources

  • Native Rdb, Oracle, DB2, or OLE DB views (A view is an SQL statement that defines the relationships between one or more tables or that specifies the criteria for the returned resultset.)

  • CONNX views that combine tables from one or more data sources and which are created in the CDD

  • Native Oracle or DB2 stored procedures

  • DB2 packages

  • DB2 static SQL statements

  • VSAM data sources (both Unix and Windows platforms)

  • C-ISAM data sources (both Unix and Windows platforms)

  • DISAM data sources (both Unix and Windows platforms)

  • Micro Focus data sources (both Unix and Windows platforms)

  • IMS data sources

  • Redshift database (Windows, Solaris, Linux (Unix) platforms)

The CDD contains the metadata information about each data source and provides a graphical user interface for easy maintenance of the metadata, integrated security, and views. The CDD is required in order to use the CONNX ODBC driver.

Once a CDD is created, it should be used for all additional table definitions, if these additional tables are to be joined with existing tables.