You can create a Data Source for Teradata that your Domino users can access. Only administrators can create this type of Data Source.
-
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.
-
Go to Manage Resources > Data Sources.
-
Click Connect to External Data.
-
In the New Data Source window, select Teradata.
-
Enter your Teradata hostname or IP address.
-
Enter a name for this Data Source.
-
Click Next.
-
Select the credential type.
-
Optionally, enter your Teradata credentials. You can choose to enter these later.
-
Click Next.
-
Select whether Everyone can access this Data Source or just Specific users or organizations.
-
Click Finish Setup. Domino alerts you that a cluster restart is needed.
TipYou must restart your Starburst cluster after any configuration changes. Perform the restart when no executions are running that interact with Starburst-powered Data Sources. -
Click Click here to trigger a restart. Domino prompts you to confirm that you want to restart the cluster.
-
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 example res = ds.query("select * from td_demo.yellow_cab") |