Creating a Teradata Vantage connection - Amazon Glue
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Creating a Teradata Vantage connection

To connect to Teradata Vantage from Amazon Glue, you will need to create and store your Teradata credentials in an Amazon Secrets Manager secret, then associate that secret with a Amazon Glue Teradata connection.

Prerequisites:

  • If you are accessing your Teradata environment through Amazon VPC, configure Amazon VPC to allow your Amazon Glue job to communicate with the Teradata environment. We discourage accessing the Teradata environment over the public internet.

    In Amazon VPC, identify or create a VPC, Subnet and Security group that Amazon Glue will use while executing the job. Additionally, you need to ensure Amazon VPC is configured to permit network traffic between your Teradata instance and this location. Your job will need to establish a TCP connection with your Teradata client port. For more information about Teradata ports, see the Teradata documentation.

    Based on your network layout, secure VPC connectivity may require changes in Amazon VPC and other networking services. For more information about Amazon connectivity, consult Amazon Connectivity Options in the Teradata documentation.

To configure a Amazon Glue Teradata connection:

  1. In your Teradata configuration, identify or create a user and password Amazon Glue will connect with, teradataUser and teradataPassword. For more information, consult Vantage Security Overview in the Teradata documentation.

  2. In Amazon Secrets Manager, create a secret using your Teradata credentials. To create a secret in Secrets Manager, follow the tutorial available in Create an Amazon Secrets Manager secret in the Amazon Secrets Manager documentation. After creating the secret, keep the Secret name, secretName for the next step.

    • When selecting Key/value pairs, create a pair for the key user with the value teradataUsername.

    • When selecting Key/value pairs, create a pair for the key password with the value teradataPassword.

  3. In the Amazon Glue console, create a connection by following the steps in Adding an Amazon Glue connection. After creating the connection, keep the connection name, connectionName, for the next step.

    • When selecting a Connection type, select Teradata.

    • When providing JDBC URL, provide the URL for your instance. You can also hardcode certain comma separated connection parameters in your JDBC URL. The URL must conform to the following format: jdbc:teradata://teradataHostname/ParameterName=ParameterValue,ParameterName=ParameterValue

      Supported URL parameters include:

      • DATABASE– name of database on host to access by default.

      • DBS_PORT– the database port, used when running on a nonstandard port.

    • When selecting a Credential type, select Amazon Secrets Manager, then set Amazon Secret to secretName.

  4. In the following situations, you may require additional configuration:

    • For Teradata instances hosted on Amazon in an Amazon VPC

      • You will need to provide Amazon VPC connection information to the Amazon Glue connection that defines your Teradata security credentials. When creating or updating your connection, set VPC, Subnet and Security groups in Network options.