Integrate Your SAP HANA Database with Salesforce Using Salesforce Connect
Do you have an SAP HANA database that you would you like to access from Salesforce via Salesforce Connect?
If so, you're at the right place. This tutorial will get you started with how you can begin integrating your SAP HANA database with Salesforce via Salesforce Connect by creating a standards-based OData endpoint. Download a free trial of Progress DataDirect Hybrid Data Pipeline
to follow along.
In this tutorial, we will show you the following 3 easy steps, with more detailed instructions below.
Install Progress DataDirect Hybrid Data Pipeline
, our self-hostable hybrid connectivity solution that you can run in the cloud or on-premises. Hybrid Data Pipeline can give you access to data in the cloud or on-premises behind a firewall. Connect through a standard interface—SQL (ODBC, JDBC) or REST (OData).
Download the SAP HANA JDBC driver
from SAP (ngdbc.jar) and drop it into Progress Hybrid Data Pipeline, using Hybrid Data Pipeline’s 3rd party JDBC support.
Use the OData v4.0 endpoint from Hybrid Data Pipeline with Salesforce Connect to access your SAP HANA data directly inside Salesforce.
Step 1: Install and Configure Hybrid Data Pipeline
You need to have a valid SSL certificate for the server address before you install Hybrid Data Pipeline. These are the requirements
for Hybrid Data Pipeline: PEM File Configuration.
Install Hybrid Data Pipeline using these instructions
. Although the instructions are for AWS, this should be applicable for any CentOS machine.
After you have installed Hybrid Data Pipeline, by default you should be able to access it at https://<server>:8443. We assume that this server is configured to be in your DMZ or behind a reverse proxy, so that Salesforce can connect to your server.
Step 2: Add the SAP HANA JDBC driver to Hybrid Data Pipeline and configure the data source
Step 3: Configure Salesforce Connect to access the OData endpoint