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;