Teradata BTEQ Script Sources > Before you begin > Create a connection
  

Create a connection

Before you configure the Teradata BTEQ Script catalog source, create a connection object in Administrator.
Ensure that you have database source information to connect to the Teradata database.
    1In Administrator, select Connections.
    2Click Add Connection.
    3Search for and select Teradata and then click Next.
    4Enter the connection details.
    The following table describes the Teradata 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.
    Type
    Teradata
    Runtime Environment
    A runtime environment is either Informatica Cloud Secure Agent or a serverless runtime environment.
    TDPID
    Teradata Director Program Identifier (TDPID) specifies the host name or IP address of the Teradata database to which you connect.
    Database Name
    The Teradata database name.
    If you do not enter a database name, Teradata PT API uses the default login database name.
    Authentication Type
    Select on of the following methods of authentication that verify the identity of a user connecting to Teradata database:
    • - Native. Default authentication type.
    • - LDAP authentication.
    • - KRB5. Kerberos authentication.
    Metadata Advanced Connection Properties
    Optional. Use to configure advanced behavior and performance of the Teradata Metadata Services (MDS) component of the Teradata database. Default is tmode=ANSI. Separate multiple options with an ampersand as in the following example: key1=value1&key2=value2
    User Name
    Name of the user account that connects to the Teradata database.
    Password
    Password for the user account that connects to the Teradata database.
    5Click Test to test your connection to the source system.
    6Click Save.