Integrate Teradata Vantage with KNIME Analytics Platform
Author: Jeremy Yu
Last updated: May 18th, 2022
Access to a Teradata Vantage instance, version 17.10 or higher.
If you need a new instance of Vantage, you can install a free version called Vantage Express in the cloud on Google Cloud, Azure, and AWS. You can also run Vantage Express on your local machine using VMware, VirtualBox, or UTM.
KNIME installed locally. See KNIME installation instructions for details.
Go to https://downloads.teradata.com/download/connectivity/jdbc-driver (first time users will need to register) and download the latest version of the JDBC driver.
Unzip the downloaded file. You will find
In KNIME, click on
File → Preference. Under
Register a new database driver. Provide values for
Descriptionlike below. Click on
Add fileand point to the .jar file you downloaded earlier. Click on the
Find driver classesand the
Driver class:should populate with the
Apply and Close:
To test the connection, create a new KNIME workflow and add a
Database Reader (legacy)node by dragging it to the workspace to the right:
Right-click on the
Database Reader (legacy)to configure settings. Select
com.teradata.jdbc.Teradriverfrom the drop-down:
Enter the name of the Vantage server and login mechanism, e.g.:
To test connection, enter SQL statement in box in lower right. For example, enter
SELECT * FROM DBC.DBCInfoVand click
Applyto close the dialog:
Execute the node to test the connection:
The node will show a green light when run successfully. Right-click and select
Data from Databaseto view the results: