Relational Data Sources - trillium_discovery - 17.2

Trillium Administration Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
17.2
Language
English
Product name
Trillium Discovery
Title
Trillium Administration Center
Topic type
How Do I
Overview
Installation
Configuration
Reference
First publish date
2008
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T06:51:21.336195

If you are adding data connections to point to relational databases, ensure that your databases are properly configured before adding data sources.

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

The Discovery Center can import or link to data from Relational Database Management Systems (RDBMS) as follows:

  • Direct connection to Oracle and DB2.
Note: For Oracle connections, 32-bit Oracle libraries are required; 64-bit libraries are not supported.
  • ODBC connection - Drivers installed with TSS.
  • ODBC (vendor) connection - Drivers supplied by database vendors.
  • RDBMS extraction into a delimited file with a corresponding ANSI DDL.
Note: NATIONAL data type for RDBMS loads is not supported.

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