Many organizations can achieve cloud to on-premises data access using a server-only deployment of Hybrid Data Pipeline. This deployment pattern relies on a security gateway appliance to broker a pass-through communication channel between the cloud application and on-premises database. Figure 2 contains an example use case to highlight this deployment. In this example, Salesforce is accessing External Data Objects using a secure HTTPS OData connection. The organization’s security gateway appliance is configured to accept this connection from Salesforce only and redirect it to Hybrid Data Pipeline. The security gateway and Hybrid Data Pipeline would be configured using mutual authenticated HTTP(S).

The Hybrid Data Pipeline server itself would access a local, LAN-accessible database (in this case, SQL Server) using an SSL-enabled or non-SSL connection, communicating using the database wire protocol.

Figure 1. Server-only Deployment