Introduction
In this tutorial we will walk you through how you can RESTify your Vertica database in 10 minutes using Progress Hybrid Data Pipeline. Our hybrid connectivity services—Hybrid Data Pipeline—can help you RESTify your database via OData. We support a wide range of data sources including EMR Hive, Cloudera, IBM DB2, SQL Server, Oracle, Postgres, Hubspot and Marketo. Recently, we have introduced a new feature where you can bring in your own JDBC driver, plug it in to Hybrid Data Pipeline to RESTify your database and/or to access to your data source behind firewall. We will be using this feature to RESTify Vertica database and below is the tutorial on how you can do that.
Introduction
In this tutorial we will walk you through how you can RESTify your Vertica database in 10 minutes using Progress Hybrid Data Pipeline. Our hybrid connectivity services—Hybrid Data Pipeline—can help you RESTify your database via OData. We support a wide range of data sources including EMR Hive, Cloudera, IBM DB2, SQL Server, Oracle, Postgres, Hubspot and Marketo. Recently, we have introduced a new feature where you can bring in your own JDBC driver, plug it in to Hybrid Data Pipeline to RESTify your database and/or to access to your data source behind firewall. We will be using this feature to RESTify Vertica database and below is the tutorial on how you can do that.
Download and Install Hybrid Data Pipeline
- Download Progress Hybrid Data Pipeline by visiting this page.
- Install Progress Hybrid Data Pipeline by following the below tutorials. Note that these are in generally applicable to any CentOS/RHEL machine, each of them varies a bit on specific cloud service settings.
- If your Vertica database is behind a firewall and you would have to install our On-Premises Connector, which lets you access data behind any firewall without complex network configurations such as SSH tunnels, reverse proxies or VPNs. Progress On-Premises connector, as the name suggests must be installed on a server behind your firewall. Below are the tutorials for installing Hybrid Data Pipeline’s On-Premise Connector, if your Hybrid Data Pipeline Server is installed on
Download and Install Hybrid Data Pipeline
- Download Progress Hybrid Data Pipeline by visiting this page.
- Install Progress Hybrid Data Pipeline by following the below tutorials. Note that these are in generally applicable to any CentOS/RHEL machine, each of them varies a bit on specific cloud service settings.
- If your Vertica database is behind a firewall and you would have to install our On-Premises Connector, which lets you access data behind any firewall without complex network configurations such as SSH tunnels, reverse proxies or VPNs. Progress On-Premises connector, as the name suggests must be installed on a server behind your firewall. Below are the tutorials for installing Hybrid Data Pipeline’s On-Premise Connector, if your Hybrid Data Pipeline Server is installed on
Enable JDBC feature
The first thing you need to do is open Postman and send a PUT request, to enable JDBC driver feature in Hybrid Data Pipeline. You need to authenticate using basic auth using the “d2cadmin” user you have configured while installing Hybrid Data Pipeline.
PUT https:
/
/
<server>
/
api
/
admin
/
configurations
/
5
Body
{
"id"
:
5
,
"description"
:
"Enable JDBC DataStore, when value is set to true, JDBC DataStore will be enabled."
,
"value"
:
"true"
}
This will enable third party JDBC feature in Hybrid Data Pipeline.
Enable JDBC feature
The first thing you need to do is open Postman and send a PUT request, to enable JDBC driver feature in Hybrid Data Pipeline. You need to authenticate using basic auth using the “d2cadmin” user you have configured while installing Hybrid Data Pipeline.
PUT https:
/
/
<server>
/
api
/
admin
/
configurations
/
5
Body
{
"id"
:
5
,
"description"
:
"Enable JDBC DataStore, when value is set to true, JDBC DataStore will be enabled."
,
"value"
:
"true"
}
This will enable third party JDBC feature in Hybrid Data Pipeline.
Add Vertica JDBC driver to classpath
- Copy the Vertica JDBC driver to the following location in Hybrid Data Pipeline Server’s install location
/install-path/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Server/ddcloud/keystore/drivers
- Navigate to the below path in your Hybrid Data Pipeline Server and restart the server, by running the following commands.
$pwd
/install-path/Progress/DataDirect/Hybrid_data_Pipeline/Hybrid_Server/ddcloud
$ ./stop
.
sh
$ ./start
.
sh
Add Vertica JDBC driver to classpath
- Copy the Vertica JDBC driver to the following location in Hybrid Data Pipeline Server’s install location
/install-path/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Server/ddcloud/keystore/drivers
- Navigate to the below path in your Hybrid Data Pipeline Server and restart the server, by running the following commands.
$pwd
/install-path/Progress/DataDirect/Hybrid_data_Pipeline/Hybrid_Server/ddcloud
$ ./stop
.
sh
$ ./start
.
sh