How to connect to Teradata

This article explains the steps to be followed to connect to a Teradata DB from Zetaris

1. Login to Zetaris and on the left hand side pane, under Virtual Database Sources click '+' to create a new file source

2. Select Next and you will see the Create Data Source modal on the screen. Select 'TERADATA' from the dropdown and fill in the details and select Next

Data Source Name (mandatory): The name you want to give to this data source
Description (optional): A brief description of the data source

JDBC Driver Class: com.ncr.teradata.TeraDriver

JDBC URL: Enter your Teradata JDBC URL in the following format -jdbc:teradata://<hostname>:<port>/databaseinstance

Username (optional): Username required to connect to teradata

Password(optional): Username required to connect to teradata

Fetch Size (mandatory): leave it to default at 3000 or change as necessary

 

3. If your connection details are correct, you will now be able to see the list of tables. Select the required tables for this connection and select Next.

4. Review the tables and select Register to complete the Teradata connectivity from Zetaris.

Once registered, refresh the Virtual Database Sources and you will be able to see the teradata data source under the registered name. 

 

Data Source Registration via Command

CREATE DATASOURCE TERADATA_3 DESCRIBE BY "TERADATA_ADMIN" OPTIONS (

jdbcdriver "com.teradata.jdbc.TeraDriver",

jdbcurl "jdbc:teradata://teradata-zetaris.australiacentral.cloudapp.azure.com/DATABASE=TPCDS_DB,DBS_PORT=1025",

username "<user_name>" ,

password "XXX"

);

REGISTER DATASOURCE TABLES FROM TERADATA_3;