Cloud and Hybrid TUTORIAL

Access an Oracle database securely from Salesforce using OData

Updated: 22 Nov 2021

Introduction

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. 

Download and Install Hybrid Data Pipeline Server

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

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: 

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. 

Connecting to your Oracle database

  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. 

 

Graphical user interface, application Description automatically generated 

  1. 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.” 

 

Graphical user interface, text, application, email, website Description automatically generated 

 

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

 

Graphical user interface, application Description automatically generated  

  1. 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: 

Graphical user interface, application, Teams Description automatically generated 

 

  1. 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.