Relational Data Sources - trillium_discovery - trillium_quality - 17.1

If you are adding loader connections to point to relational databases, make sure that your relational databases are properly configured before trying to create entities.

Trillium can import or link to data from Relational Database Management Systems (RDBMS) with:

• Direct connection to Oracle and DB2.

  Note: For Oracle connections, 64-bit Oracle libraries are required.

• ODBC-compliant RDBMS connection. Note the following:

  • Duplicate row ID (formerly checksum) calculation, sparse row counting, and row length statistics for ODBC connections are not supported.

  • If your Trillium Quality batch project includes a Database Read/Write process, uses an ODBC data source that uses an ODBC driver (database adapter) and the Vendor-Supplied ODBC Adapter, and you run the exported batch script in a Linux environment (Trillium server installed on a Linux system), the batch script will fail. Validating the project's database settings will return an error and will not complete. This scenario is supported only when the Trillium server is installed on a Windows system.

• RDBMS extraction into a delimited file with a corresponding ANSI DDL.

  Note: NATIONAL data type for RDBMS loads is not supported.

• Trillium-supplied 64-bit ODBC loader connection (for a list of supported databases and corresponding drivers, see TSS ODBC (Trillium-Supplied) Loader Connections).

The table given below lists supported relational database clients, their version, and driver information.