Relational Data Sources - trillium_discovery - trillium_quality - Latest

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:31:00.219841

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.

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

Table 1. Supported Relational Databases

Database

Version

Driver

Supported Database Clients for Direct Connections

DB2

11.5

IBM

Oracle1

21c R1* (21.1*)

19c R1* (19.1*)

Oracle

Tested ODBC Connections

DB2

11.5

IBM

Informix

10.0 using Informix Connect 3.5

IBM driver

Microsoft Access

Access 2019

Microsoft driver

Microsoft SQL Server

 

SQL Server 2019

Microsoft driver

Oracle

21c R1* (21.1*)

19c R1* (19.1*)

Oracle

Sybase

12.5.x

Sybase driver

Teradata

v13, v12

Teradata driver

Note: ODBC connections to any other database or database version require verification from Precisely Support.

1If you plan to use the Oracle Instant Client with the Oracle (Vendor-Supplied) loader connection, you must choose the Administrator or Runtime installation type when installing the Oracle Client. Other installation types are not supported.