Discovery Center can import or link to data from the following fixed-length, flat file data sources:
- Flat files: Fixed-length files described by a schema. Includes those files created by Trillium Quality processes in the Control Center.
Note: Duplicate row ID (formerly checksum) calculation, sparse row counting, and row length
statistics are not supported for data connections.
- Delimited files:
- With ASCII, extended ASCII, or hexadecimal delimiters
- With or without ANSI SQL DDL
- COBOL flat fixed length files:
- Data must match copybook layout
- Supports various character encoding including ASCII, EBCDIC, and Unicode
- Big or little Endian byte orders
- One- or two-byte data alignment
- Common COBOL copybook features such as:
- REDEFINES clause
- OCCURS clause
- FILLER clause
- COBOL data types: 9, X, A, B
- Numeric storage formats: COMP-3, Packed-DECIMAL, COMP, COMPUTATIONAL, or BINARY
- Comments beginning with *
- Descriptors such as USAGE IS, DISPLAY, SEPARATE, LEADING, and TRAILING
- Unnamed fields
- Unsigned COMP-3 fields
Note: Copybook features such as Multiple Record Types and OCCURS DEPENDING must be manually
removed from the Copybook and the data file prior to loading into the Discovery
Center.