Integrate Teradata Vantage with KNIME Analytics Platform
Overview
This how-to describes how to connect to Terdata Vantage from KNIME Analytics Platform.
About KNIME Analytics Platform
KNIME Analytics Platform is a data science workbench. It supports analytics on various data sources, including Teradata Vantage.
Prerequisites
- Access to a Teradata Vantage instance, version 17.10 or higher.
노트
If you need a test instance of Vantage, you can provision one for free at https://clearscape.teradata.com
- KNIME installed locally. See KNIME installation instructions for details.
Integration Procedure
- 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
terajdbc4.jar
file. - In KNIME, click on
File → Preference
. UnderDatabases
, clickAdd
: - Register a new database driver. Provide values for
ID
,Name
andDescription
like below. Click onAdd file
and point to the .jar file you downloaded earlier. Click on theFind driver classes
and theDriver class:
should populate with thejdbc.TeraDriver
: - Click
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. Selectcom.teradata.jdbc.Teradriver
from 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.DBCInfoV
and clickApply
to 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 Database
to view the results:
Summary
This how-to demonstrats how to connect from KNIME Analytics Platform to Teradata Vantage.
Further reading
노트
If you have any questions or need further assistance, please visit our community forum where you can get support and interact with other community members.