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.
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. |