skip to main content
Getting started with Hybrid Data Pipeline : Sample configuration scenarios : Connecting an application in the cloud to on-premises data sources
  

Try Now

Connecting an application in the cloud to on-premises data sources

In this scenario, you want to connect an application in the cloud to your on-premises data sources. You prefer to have Progress DataDirect Hybrid Data Pipeline behind your own firewall so you don't have to maintain a cloud-based platform. You will use an SSL connection to ensure the security of your data.
This deployment scenario is especially suitable when you use OData with your cloud-based applications, for example, creating a real-time connectivity between Salesforce and an on-premises database.
On-premises data sources and Hybrid Data Pipeline server, with applications in the cloud
1. Install the Hybrid Data Pipeline Server on a UNIX/Linux machine behind your firewall.
2. Create a data source definition for the data source.
3. If you want to use OData, define the OData parameters in the Data Source definition, and if necessary, include the port number in the OData URL.
4. For this test scenario, you can use the self-signed certificate that was created during installation. In production, you use your own SSL certificate that you obtained from a Certificate Authority.
5. If you are using an ODBC or JDBC application, install the Hybrid Data Pipeline Hybrid Data Pipeline ODBC or JDBC driver on a machine outside the firewall.
6. Configure your business application to use ODBC, JDBC, or OData.
For a more detailed discussion of this scenario, watch a video.