Teradata Resource Configuration

teradata.extractor.host

Name or IP address of the Teradata server

teradata.lan, 127.0.0.1

teradata.extractor.username

User name for connection to Teradata

manta_user

teradata.extractor.dbsInclude

The regular expression for database names which should be extracted; matching is case insensitive; leave it blank to extract each database from the defined connection

PROD.*
(STG|TGT).*

teradata.extractor.ddl.dbsExclude

The regular expression for database names from which DDL should NOT be extracted; this filter is used on the results of the filtering defined by the two previous regular expressions; matching is case insensitive

This filter is useful when some databases are used as APIs or you would like to see them as a blackbox

.*_BACKEND

teradata.bteq.encoding

BTEQ script encoding. See Encodings for applicable values.

UTF-8

teradata.tpt.encoding

TPT script encoding. See Encodings for applicable values.

UTF-8

teradata.ddl.dir

Directory of Teradata DDL scripts that work with the related database

${manta.dir.temp}/teradata/${teradata.dictionary.id}/ddl

teradata.bteq.replace

Path to the CSV file with the replacements to be applied to the provided BTEQ scripts; see Placeholder Replacement in Input Scripts for details about the replacement file format

${manta.dir.input}/teradata/
${teradata.dictionary.id}/bteqReplace.csv

teradata.tpt.replace

Path to the CSV file with the replacements to be applied to the provided TPT scripts; see Placeholder Replacement in Input Scripts for details about the replacement file format

${manta.dir.input}/teradata/
${teradata.dictionary.id}/tptReplace.csv

teradata.analyze.parallelCount

Number of parallel threads which will analyze DDL, BTEQ, and TPT scripts

4

teradata.maxTime

Timeout for parsing each Teradata script, in milliseconds

600000

teradata.extractor.tmode

Transaction mode of connection to the Teradata database

ANSI, TERA, DEFAULT

teradata.extractor.logmech

Logon mechanism of connection to the Teradata database

TD1, TD2, KRB5, LDAP

teradata.extractor.ssl.enable

Enables SSL for the JDBC connection; if true, requires SSL mode to be set

Requires TeraJDBC driver version 17.10.00.07 or higher

Due to limited support for custom truststore setup in TeraJDBC driver, a custom certificate / CA trusts and/or custom truststores need to be set at the level of the JVM initiating the JDBC connection (CLI/Agent).

Automatic Data Lineage automatically uses port 443 for SSL-enabled connections (no additional configuration needed). Continue using teradata.extractor.port for the non-encrypted port number and control the use of SSL by teradata.extractor.ssl.mode

true

false

teradata.extractor.encryptData

Encrypts traffic between the DBMS and client

Requires TeraJDBC driver version 15.00.00.15 or higher

true

false

teradata.dictionary.mappingManualFile

Path to mappings provided manually for Teradata databases

${manta.dir.scenario}/conf/teradataDictionaryMantaMappingManual.csv

teradata.expressionDescriptions.enabled.bteq

Enables or disables building of transformation logic descriptions from SQL code in BTEQ scripts

false
true

teradata.tpt.variables.location

Enter file containing manually provided values for TPT variables (see https://docs.teradata.com/r/Teradata-Parallel-Transporter-User-Guide/February-2022/Teradata-PT-Job-Components/Using-Job-Variables)

The file content is in the format placeholder=value: for example, DBName='WORKDB'
Do not include the @ sign for the placeholder value.

${manta.dir.input}/teradata/${dictionary.id}/variableValues.properties

teradata.tpt.includes.pathreplacements

File with key=value replacements applied to the INCLUDE directive to adjust the path to included TPT script fragments so that the paths are relative and the included files are searched under ${manta.dir.temp}/teradata/${teradata.dictionary.id}/tptincludes

${manta.dir.input}/teradata/${teradata.dictionary.id}/replacements.properties