In this tutorial, let’s see how you can connect to your On-premises Teradata using Hybrid Data Pipeline’s new third party JDBC feature. If you are new to Progress, Hybrid Data Pipeline (HDP) is our self-hostable hybrid connectivity solution that you can run in the cloud or on-premises. With HDP, you can access data in the cloud or on-premises behind a firewall. Connect through a standard interface—SQL (ODBC, JDBC) or REST (OData 2, OData 4).
This tutorial will require you to set up two components of Hybrid Data Pipeline for you to be able to access your On-premises Teradata. The first one is the Hybrid Data Pipeline Server, which you can host in any cloud service you want and the next one is Progress On-Premises connector, which you must install on one of the On-Premises machine, which is in the same network as of the Teradata server. This On-premises connector helps the Hybrid Data Pipeline server to connect to Teradata database and provides you with ODBC, JDBC or REST (OData 2, OData 4). Let’ see how you can do this.
/path/to/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Server/redist/
Important: Before you begin installing the On-premises connector on your On-premise machine, you would have to configure firewall for Hybrid Data Pipeline running in the cloud to allow traffic on 11235,11280,40501.
C:\Program Files\Progress\DataDirect\Hybrid_Data_Pipeline_OnPremise_Connector\OPDAS\server\drivers
DataSource Name
Any name you want
Driver Class
com.teradata.jdbc.TeraDriver
UserName
<username>
Password
<password>
Connector ID
Your connector label from on-premises connector
Connection URL
jdbc:teradata://<Server>/DATABASE=<db name>,DBS_PORT=1025
Now you can access your On-premises Teradata database using ODBC and JDBC drivers from your cloud applications.
It is so easy to connect to Teradata database on-premise with Hybrid Data pipeline and connect to it using standards-based connectivity such as ODBC, JDBC and OData (REST) without you having to write a single line of code or having to deal with any network/firewall issues. Similarly, you can connect to any database on-premise and if you don’t see the data source, that you want to connect to, you can bring in your own JDBC driver and Progress Hybrid Data Pipeline will take care of everything.