Create a Teradata Data Source

You can create a Data Source for Teradata that your Domino users can access. Only administrators can create this type of Data Source.

Prerequisites

  • Starburst needs to be enabled in the deployment. If not enabled, please follow the instructions to enable Starburst-powered Data Sources.

  • You must have network connectivity between Teradata and your Domino deployment.

  • Domino must enable this feature. If you do not see this Data Source type in your deployment, contact your Customer Success Manager.

Create a Teradata Data Source

  1. Go to Admin > Data > Data Sources.

  2. Click Create a Data Source.

  3. In the New Data Source window, select Teradata.

  4. Enter your Teradata hostname or IP address.

  5. Enter a name for this Data Source.

  6. Click Next.

  7. Select the credential type.

  8. Optionally, enter your Teradata credentials. You can choose to enter these later.

  9. Click Next.

  10. Select whether Everyone can access this Data Source or just Specific users or organizations.

  11. Click Finish Setup. Domino alerts you that a cluster restart is needed.

    Starburst cluster restart prompt

    Tip
    You must restart your Starburst cluster after any configuration changes. Perform the restart when no executions are running that interact with Starburst-powered Data Sources.
  12. Click Click here to trigger a restart. Domino prompts you to confirm that you want to restart the cluster.

  13. Click Restart Cluster. The restart takes approximately 5-10 minutes. When the restart is complete, Domino users can use the new Data Source.

Note

Users must specify the database name in their queries, as in this example where td_demo is the database name and yellow_cab is the table name:

example res = ds.query("select * from td_demo.yellow_cab")