About Loader Connections and Data Sources - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

For Trillium to connect to your data, the repository administrator must set up at least one loader connection for each type of data source that you intend to work with. In addition to defining the type of data source, the loader connection defines the directories in which the source data files and schema files are located.

If you have data files on your client system, you can load and work with these files directly in the Control Center without needing a loader connection. See Creating an Entity from the Client.

Trillium can import or link to the following data source types:

Data Source Type Description
Delimited files Delimited text files and comma-separated value (CSV) files
  • With ASCII, extended ASCII, or hexadecimal delimiters
  • With or without ANSI DDL
COBOL copybook

Flat, fixed-length files described by COBOL copybooks

  • Character encoding including, but not limited to ASCII, EBCDIC, and Unicode
  • Big or Little Endian byte orders
  • One- or two-byte data alignment
Relational data

Relational data stored in a relational database management system (RDBMS) application. Trillium can import or link using:

  • Direct connection to Oracle and IBM DB2 databases
  • ODBC-compliant RDBMS connection
  • RDBMS extraction into a delimited file with a corresponding ANSI DDL
TSQ files File generated by the Trillium application

The procedures for setting up loader connections are documented in the Repository Administrator's Guide. Check with your repository administrator to verify that the appropriate connections exist for the data you want to use.