Exposing on-premises data sources to cloud-based applications
In this scenario, your data sources are on-premises and you want to expose them for easy but secure access by a cloud-based business analysis tool. Here, Progress DataDirect Hybrid Data Pipeline Server is installed in the cloud, and you use the On-Premises Connector to perform secure connections through the firewall to the Microsoft SQL Server database that contains your sales data. The business application tool is in a different cloud.
This configuration would also be suitable for an independent software vendor. You can embed Hybrid Data Pipeline services in your own cloud, allowing your customers to access their data sources.
To keep this scenario simple, we are installing Hybrid Data Pipeline to use the internal database to store the configuration information.
You can temporarily use the self-signed certificate that's automatically generated during installation, but you should plan to get your own SSL certificate from a Certificate Authority.
4. 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.
5. 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.
6. If you are using an ODBC or JDBC application, install the Hybrid Data PipelineODBC or JDBC driver on a machine outside the firewall.
7. Configure your business application to use ODBC, JDBC, or OData.
For a more detailed discussion of this scenario, watch a video.
