Data Connection Properties - trillium_discovery - 17.1

Click the following links to learn more about the data connection types available and the properties to configure when you add or edit a data connection.

COBOL

This data connection allows you to connect to flat, fixed-length files described by COBOL Copybooks. The data must match copybook layout.

Default Filter. Use this filter to limit the list of data files visible to Discovery Center users. For example, to list only those files/tables that contain cust in the name, enter cust in the Default Filter field. The default filter value (*) returns a list of all available files.

Data Directory. The directory path to your data files.

Data Extensions. Specify the file extensions for the data files to which you will be connecting. Only the files with the specified extensions will be visible to Discovery Center users for this connection. If none are specified, dat will be used as the default. Separate each extension with a space and omit the leading period. To display files that have no extension, add {} to the list. For example, if you only want to display data files with the extensions dat, txt, and files without extensions, specify the following: dat txt {}

Schema Directory. The directory path to the copybook files.

Schema Extensions. Specify expected schema file extensions. Only files with these extensions will be visible to Discovery Center users for this connection. If none are specified, cpy is the default. Separate each extension with a space and omit the leading period. To display files that have no extension, add {} to the list. For example, if you only want to display schemas with the extensions cpy and cbl, and schemas without extensions, specify the following: cpy cbl {}

DB2

This data connection allows you to connect to DB2 databases.

Default Filter. Use this filter to limit the list of data files visible to Discovery Center users. For example, to list only those files/tables that contain cust in the name, enter cust in the Default Filter field. The default filter value (*) returns a list of all available files.

Alias. The DB2 alias (alternative) name.

Delimited

This data connection allows you to connect to ASCII, extended ASCII, or hexadecimal delimiter files.

Default Filter. Use this filter to limit the list of data files visible to Discovery Center users. For example, to list only those files/tables that contain cust in the name, enter cust in the Default Filter field. The default filter value (*) returns a list of all available files.

Data Directory. The directory path to your data files.

Data Extensions. Specify the file extensions for the data files to which you will be connecting. Only the files with the specified extensions will be visible to Discovery Center users for this connection. If none are specified, csv and txt will be used as the default. Separate each extension with a space and omit the leading period. To display files that have no extension, add {} to the list. For example, if you only want to display data files with the extensions dat, txt, and files without extensions, specify the following: dat txt {}

Schema Directory. The directory path to your schema files, such as DDLs,

Schema Extensions. Specify expected schema file extensions. Only files with these extensions will be visible to Discovery Center users for this connection. If none are specified, ddl is the default. Separate each extension with a space and omit the leading period. If you want to display files that have no extension, add {} to the list. For example, if you only want to display schemas with the extensions ddl, ddt, and schemas without extensions, specify the following: ddl ddt {}

Fixed-Length

This data connection allows you to connect to flat files described by a schema, including those created by TS Quality processes in the Control Center.

Default Filter. Use this filter to limit the list of data files visible to Discovery Center users. For example, to list only those files/tables that contain cust in the name, enter cust in the Default Filter field. The default filter value (*) returns a list of all available files.

Data Directory. The directory path to your data files.

Data Extensions. Specify the file extensions for the data files to which you will be connecting. Only the files with the specified extensions will be visible to Discovery Center users for this connection. If none are specified, dat will be used as the default. Separate each extension with a space and omit the leading period. To display files that have no extension, add {} to the list. For example, if you only want to display data files with the extensions dat, txt, and files without extensions, specify the following: dat txt {}

Schema Directory. The directory path to your schema files such as DDLs,

Schema Extensions. Specify expected schema file extensions. Only files with these extensions will be visible to Discovery Center users for this connection. If none are specified, ddl and ddx will be used as the default. Separate each extension with a space and omit the leading period. If you want to display files that have no extension, add {} to the list. For example, if you only want to display schemas with the extensions ddl, ddt, and schemas without extensions, specify the following: ddl ddt {}

HDFS Delimited

This data connection allows you to connect to delimited files in HDFS (Hadoop Distributed File System).

Default Filter. Use this filter to limit the list of data files visible to Discovery Center users. For example, to list only those files/tables that contain cust in the name, enter cust in the Default Filter field. The default filter value (*) returns a list of all available files.

NameNode Address. The access point of the HDFS. This can be a hostname and port number, IP address and port number, or DNS address.

Data Directory. The path to the directory where the data files are located in the HDFS.

Data Extensions. Specify the file extensions for the data files to which you will be connecting. Only the files with the specified extensions will be visible to Discovery Center users for this connection. If none are specified, dat will be used as the default. Separate each extension with a space and omit the leading period. To display files that have no extension, add {} to the list. For example, if you only want to display data files with the extensions dat, txt, and files without extensions, specify the following: dat txt {}

Schema Directory. The path to the directory where the schema files for the data files are located in the HDFS.

Schema Extensions. Specify expected schema file extensions. Only files with these extensions will be visible to Discovery Center users for this connection. If none are specified, ddl and ddx will be used as the default. Separate each extension with a space and omit the leading period. If you want to display files that have no extension, add {} to the list. For example, if you only want to display schemas with the extensions ddl, ddt, and schemas without extensions, specify the following: ddl ddt {}

ODBC

This data connection allows you to connect to a selection of databases, including Oracle, DB2, SQL Server, Informix, Teradata, Sybase, and many others without installing any external component. For example, you can read from and write to an Oracle database without the Oracle client.

Note: The ODBC drivers are installed with the TSS server software.

Default Filter. Use this filter to limit the list of data files visible to Discovery Center users. For example, to list only those files/tables that contain cust in the name, enter cust in the Default Filter field. The default filter value (*) returns a list of all available files.

Data Source Name (DSN). Specify the DSN as defined on the server for the TSS ODBC (Trillium-Supplied) driver.

Use Single Sign-On. Select if you want to apply Windows authentication to authorize Discovery Center users to access ODBC files without having to enter their user ID and password. (When selecting this option, ensure the TSS repository server was installed using the Windows authentication security parameter.)

ODBC (Vendor)

This data connection allows you to connect to a selection of databases using ODBC drivers supplied by database vendors. Choose this option to connect to an ODBC database that is not available for the ODBC connection.

Default Filter. Use this filter to limit the list of data files visible to Discovery Center users. For example, to list only those files/tables that contain cust in the name, enter cust in the Default Filter field. The default filter value (*) returns a list of all available files.

Machine Name. The name or IP address of the system where the ODBC vendor-supplied adapter is installed.

Port Number. The port number of the ODBC vendor-supplied service, specified when the adapter was installed.

Data Source Name (DSN). Specify the DSN as defined on the server for the ODBC vendor-supplied driver.

Use Single Sign-On. Select if you want to apply Windows authentication to authorize Discovery Center users to access ODBC files without having to enter their user ID and password. (When selecting this option, ensure the TSS repository server was installed using the Windows authentication security parameter.)

Oracle

This data connection allows you to connect to an Oracle database.

Note: This connection requires an Oracle client to be installed.

Default Filter. Use this filter to limit the list of data files visible to Discovery Center users. For example, to list only those files/tables that contain cust in the name, enter cust in the Default Filter field. The default filter value (*) returns a list of all available files.

TSN Name. Specify the name of the entry in the tnsnames.ora file, which resides in $ORACLE_HOME/network/admin