Enterprise Data Catalog Scanner Configuration Guide > Configuring Database Management Resources > Teradata
  

Teradata

Teradata is one of the ETL resource types in Enterprise Data Catalog. Configure a Teradata resource type to extract metadata from Teradata databases.

Objects Extracted

Permissions to Configure the Resource

Configure the permissions for the Teradata database user account that you use to connect to the Teradata database.
The following table lists the schema objects and system tables on which you must configure SELECT permissions for the Teradata database user account:
Schema Objects
System Tables
  • - Tables
  • - Views
  • - Indexes
  • - Packages
  • - Procedures
  • - Functions
  • - Sequences
  • - Triggers
  • - Synonyms
  • - Database
  • - DBC.DBCINFO
  • - DBC.TABLETEXT
  • - DBC.HOSTSINFO
  • - DBC.DATABASES
  • - DBC.TABLES
  • - DBC.COLUMNS
  • - DBC.ALL_RI_CHILDREN
  • - DBC.INDICES
  • - DBC.TRIGGERS
  • - DBC.SHOWTBLCHECKS
  • - DBC.TVFIELDS
  • - DBC.TVM
  • - DBC.UDTINFO
  • - TDQCD.STATSRECS
  • - DBC.DBASE
  • - DBC.IDCOL
  • - DBC.UDFINFO
  • - DBC.DATABASESV
  • - DBC.TABLE_LEVELCONSTRAINTS
  • - DBC.TABLETEXTV
  • - DBC.TABLE_LEVELCONSTRAINTSV
  • - DBC.INDICESV
  • - DBC.ALL_RI_CHILDRENV
  • - DBC.TRIGGERSV

Prerequisites

To complete the prerequisites to create a Teradata resource, download the JDBC driver JAR file from the Internet and copy the files to the TeradataScanner directory in the <INFA_HOME>/services/CatalogService/ScannerJars/externalDependencies directory. You need not recycle the Catalog Service.
Alternatively, you can perform the following steps to complete the prerequisites:
  1. 1. Download the JDBC driver files and copy the file to the <INFA_HOME>/services/CatalogService/ScannerBinaries directory.
  2. 2. Open the <INFA_HOME>/services/CatalogService/ScannerBinaries/CustomDeployer/scannerDeployer.xml file and add the following lines in the file:
    3. <ExecutionContextProperty isLocationProperty="true" dependencyToUnpack="teradataJars.zip"> <PropertyName>TeradataScanner_DriverLocation</PropertyName> <PropertyValue>scanner_miti/teradata/Drivers</PropertyValue> </ExecutionContextProperty>
  3. 3. Save the scannerDeployer.xml file.
  4. 4. Recycle the Catalog Service.

Basic Information

The General tab includes the following basic information about the resource:
Information
Description
Name
The name of the resource.
Description
The description of the resource.
Resource type
The type of the resource.
Execute On
You can choose to execute on the default catalog server or offline.

Resource Connection Properties

The following table describes the properties for the Teradata resource type:
Property
Description
User
Name of the user account that connects to the Teradata database.
Password
Password for the user account that connects to the Teradata database.
Host
Fully qualified host name of the machine where the Teradata database is hosted.
Note: To connect to a Teradata resource through an LDAP server, you must specify /LOGMECH=LDAP to the host name.
The following table describes the Additional and Advanced properties for source metadata settings on the Metadata Load Settings tab:
Property
Description
Enable Source Metadata
Select to extract metadata from the data source.
Import system objects
Specifies the system objects to import.
The default value is True or False whatever the case might be.
Schema
Specifies a list of semicolon-separated database schema.
Source Metadata Filter
You can include or exclude tables and views from the resource run. Use semicolons (;) to separate the table names and view names.
For more information about the filter field, see Source Metadata and Data Profile Filter.
Import stored procedures
Specifies the stored procedures to import.
The default value is True or False whatever the case might be.
Case Sensitive
Specifies that the resource is configured for case insensitivity. Select one of the following values:
  • - True. Select this check box to specify that the resource is configured as case sensitive.
  • - False. Clear this check box to specify that the resource is configured as case insensitive.
The default value is False.
Agent Options
Specify the Enterprise Data Catalog Agent options to run the scanner job.
Fetch Views Data Types
Specifies to import the views data type.
Memory
Specify the memory value required to run a scanner job.
Specify one of the following memory values:
  • - Low
  • - Medium
  • - High
Note: For more information about the memory values, see the Tuning Enterprise Data Catalog Performance article on How To-Library Articles tab in the Informatica Doc Portal
Custom Options
JVM parameters that you can set to configure scanner container. Use the following arguments to configure the parameters:
  • - -Dscannerloglevel=<DEBUG/INFO/ERROR>. Changes the log level of scanner to values, such as DEBUG, ERROR, or INFO. Default value is INFO.
  • - -Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value should be a number.
  • - -Dscanner.yarn.app.environment=<key=value>. Key pair value that you need to set in the Yarn environment. Use a comma to separate the key pair value.
  • - -Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when pmem is enabled. Default value is 1.
  • - -DskipExternalDatabaseObjects=true. Excludes all external objects such as schema, table, database and view.
Track Data Source Changes
View metadata source change notifications in Enterprise Data Catalog.
You can enable data discovery for a Teradata resource. For more information about enabling data discovery, see the Enable Data Discovery topic.
You can enable composite data domain discovery for a Teradata resource. For more information about enabling composite data domain discovery, see the Composite Data Domain Discovery topic.