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.
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.
- Start the On-premises connector installer. Click next on the Introduction window.
- On the next screen you would be asked to choose installation directory. You can either keep it as a default or choose your own location.
- On the next screen, choose standard installation if you don’t need any customization.
- On the next screen, you would have to provide the credentials that you created while installing the Hybrid Data Pipeline and a unique connector label and click on Next. Remember this Connector Label, as you will be using it later.
- Your credentials will be verified at this point and if it’s success authenticated, you will be shown Pre-installation summary. Click on Install to start the installation.
- Click on Done, after the installation is complete to close the installer. You should now see a Configuration Tool as shown below
- Go to Status tab, click on Test to make sure everything is properly configured, and you should see green for every service.
- Close the configuration tool.
- Go to OData tab, click on button “Configure Schema”.
- On the next screen you should see list of schemas in your Teradata database. Choose your schema.
- You should now a see list of tables as shown below. Select the tables you want to expose through OData REST API. I chose Employee table in this case to expose through OData API. If your table doesn't have Primary key, please choose a column in the table as a primary key as shown below.
- Click on Save and Close to save the settings.
- Back on OData tab, you should find OData Access URI. Copy the URI to another tab and open it. As you might not have proper SSL certificate, you might see unsafe exception. To overcome it, change the URL to http://<Server>:8080/api/odata4/<yourdatasourcename>
- You should now be prompted for your Hybrid Data Pipeline Credentials, after you enter it you should see the following response, which basically lists out all the tables that are exposed.
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.