Skip to main content

Teradata

Following are the options specific to Teradata:

  • Connection Name: Enter a unique Connection Name. This fields accepts letters, numbers, and symbols.

  • Hostname: Enter the Hostname of the Teradata server or select from the list of available IPs. You can also search for the hostnames and IP addresses of databases by Find DBMS.

  • IP Address: Enter the IP Address for the connection.

  • Authentication Method: The following authentication methods are available for Teradata Server.

    1. Teradata: Authenticates the connection using Teradata Server Username and Password.

    2. Kerberos: Authenticates the connection using the Kerberos Username and Key Path.

    3. Kerberos with Principal: Authenticates using Kerberos system’s Principal name and password.

  • Use Connection String: The Connection String specifies the information about the data source and the means of connecting to it. Check the Use Connection String checkbox and provide the connection string. Use this option if you want to secure the connection using connection string.

  • Connection Attribute: Select the attribute name from the Connection Attribute drop-down. This functionality allows you to add tags to the created connection.

  • Query Band Details: A Query Band is a set of name:value pairs that can be set on a session. Each name:value pair is separated by a semicolon and the expression ends with a semicolon.

    For example, Org=PK Protect; username=ABC; host=xxx; etc. The user can keep a track of the tasks executed against a Teradata connection. Once connection is created, the Query Band will be executed and the DDL details will be logged on Teradata database i.e., dbc.qrylogV for the current session.

    Type the Query Band in the Query Band textbox and click Add.


    The Query Band entered by the user will be displayed in the box just below the Query Band textbox. You can edit and delete the Query Band.

*Note: The maximum length of the entire query band string is limited to 2048 characters.

  • Databases/Schemas: Enter the name of the database in the Filter By Schema/DB Name text box. Check the Include System Schema/DB Name checkbox to include the required schemas and databases and click Fetch Metadata. It will list down the available databases/schemas for the connection.

    1. Check the databases/schemas name that you want to add as the target databases/schemas. The checked databases or schemas will be appeared in the Target Databases/Schemas panel.

To proceed further for remaining steps, refer Step 2 in RDBMS Detection Connection.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.