Access an Oracle database securely from Salesforce using OData

Integrating external data with Salesforce applications has never been easier thanks to Salesforce Connect that can help you consume data from any OData producer. External data objects can be configured in minutes. But the picture isn't complete without the real-time connectivity provided by our Hybrid Connectivity Service - DataDirect Hybrid Data Pipeline. 

In this tutorial we will walk you through on how you can an Oracle database securely using OData generated by Hybrid Data Pipeline. 

You can find complete documentation for installing Hybrid Data Pipeline here: 

https://docs.progress.com/bundle/datadirect-hybrid-data-pipeline-installation-46/page/Installing-the-Hybrid-Data-Pipeline-server.html 

Note that since Salesforce requires OData endpoints to have publicly trusted SSL certificates, be sure to perform a “Custom” installation and provide the PEM file which contains the full chain of your SSL cert. Documentation for this can be found here: 

https://docs.progress.com/bundle/datadirect-hybrid-data-pipeline-installation-46/page/The-PEM-file.html 

Once you have installed Progress Hybrid Data Pipeline and are able to access it over HTTPS, proceed to configuring the connection to Oracle below.  

Note that this HTTPS endpoint will need to be reachable from Salesforce, so this is a good time to make any required firewall changes. You may also want to configure a DNS entry to point to your HDP instance. 

1. Open your browser and go to go to https://<server_name> and you should see a login page as shown below. Depending on how you installed, you may need to add :8443 to your URL. 

2. Log in with the admin credentials you created during installation. This is usually the d2cadmin user account. Then click on the data sources icon and then click “New Data Source.” 

3. You should see a list of available data sources. Choose Oracle to begin configuring the connection to your database. 

4. Configure the data source to connect to your Oracle instance by providing a Data Source Name, Database User ID, Password, Server Name, Port, and SID. Click Test to validate. See the sample below: 

5. Once you are connected to your data source, choose the OData tab at the top of the screen. Here you will map the tables and columns to an OData schema, creating your REST endpoint. Choose OData v4 and click Configure.