Teradata Database Sources > Before you begin > Create a connection
  

Create a connection

Before you configure the Teradata Database catalog source, create a connection object in Administrator.
If you configure an external secrets manager to connect to the source system, you can use the following authentication tools:
    1In Administrator, select Connections.
    2Click Add Connection.
    3Search Teradata and then click Next.
    4Enter the connection properties.
    Property
    Description
    Connection Name
    Name of the connection.
    Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
    Maximum length is 255 characters.
    Description
    Description of the connection. Maximum length is 4000 characters.
    5 Enter properties specific to the Teradata connection:
    Property
    Description
    Use Secret Vault
    Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
    This property appears only if secrets manager is set up for your organization.
    When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
    Note:
    If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option.
    For information about how to configure and use a secrets manager, see Secrets manager configuration.
    Runtime Environment
    The name of the runtime environment where you want to run tasks.
    Specify a Secure Agent.
    TDPID
    The name or IP address of the Teradata database machine.
    If you configure KRB5 authentication to connect to the Teradata database, specify the fully qualified hostname of the Teradata database machine.
    Database Name
    The Teradata database name.
    If you do not enter a database name, Teradata PT API uses the default login database name.
    Code Page
    Code page associated with the Teradata database.
    Select one of the following code pages:
    • - MS Windows Latin 1. Select for ISO 8859-1 Western European data.
    • - UTF-8. Select for Unicode and non-Unicode data.
    When you run a task that extracts data from a Teradata source, the code page of the Teradata PT API connection must be the same as the code page of the Teradata source.
    6Select the authentication type to connect to the Teradata Database source system and enter the connection properties.
    You can select one of the following authentication types:
    7Click Test.
    8Click Save.

Native authentication

To configure native authentication, you need the user name and password from your Teradata account.
The following table describes the basic connection properties for Native authentication:
Property
Description
Username
User name with the appropriate read and write database permissions to access the Teradata database.
Password
Password for the database user name.

LDAP authentication

To configure LDAP authentication, you need to authenticate user credentials against the external LDAP directory service.
The following table describes the basic connection properties for LDAP authentication:
Property
Description
Username
User name with the appropriate read and write database permissions to access the LDAP database.
Password
Password for the LDAP database user name.

KRB5 authentication

To configure KRB5 authentication, you need the Kerberos service principal name that authenticates to the Teradata database. Additionally, you need the KRB5_CONFIG, KRB5CCNAME, and JAASCONFIG properties for Kerberos authentication.
The following table describes the basic connection properties for KRB5 authentication:
Property
Description
Username
The Kerberos service principal name that authenticates to the Teradata database.
Password
Set the password to PmKerberosPassword.
Note:
This password is not used for KRB5 authentication when you connect to the Teradata database.
The following table describes the advanced connection properties for KRB5 authentication:
Property
Description
Kerberos Artifacts Directory
The properties required to configure Kerberos authentication.
Separate each key-value pair with a comma.
You need to add the KRB5_CONFIG, KRB5CCNAME, and JAASCONFIG properties.