Connecting to Salesforce, Eloqua, Google Analytics etc., from SAP Business Objects Cloud

Introduction

SAP Business Objects Cloud is a cloud analytics tool that lets you Discover, analyze, plan, predict, and collaborate in one integrated experience designed expressly for the cloud. For any analytics or BI tool, data connectivity is essential. And SAP BO Cloud is no exception, it has in-built integrations for all your favorite SAP data sources, so that you can bring in data from them for analytics. Apart from these SAP Business Object Cloud supports OData Services, so you can bring data from any third-party data source.

Progress DataDirect Hybrid Data Pipeline will help you to generate OData Service for any data source. If you want to bring in data from other Cloud sources like Salesforce, Oracle Marketing Cloud (Eloqua), Google Analytics, MS Dynamics CRM, HubSpot, Sugar CRM etc., you can use our Hybrid Data Pipeline to generate an OData API for these data sources, so that you can use it SAP BO Cloud to import data for analytics on that data.

In this tutorial, let’s see how you can leverage Progress Hybrid Data Connectivity to bring in Salesforce data to SAP Business Objects Cloud as an example.

Install Progress Hybrid Data Pipeline

  1. Download Progress Hybrid Data Pipeline by visiting this page.
  2. Install Progress Hybrid Data Pipeline by following the below tutorials. Note that these are in generally applicable to any CentOS/RHEL machine, each of them varies a bit on specific cloud service settings.

Generate OData Service for Salesforce

  1. Open your browser and go to http://<Server-Address>:8080 and log in to Hybrid Data Pipeline. Go to DataSources tab and create a New Data Source. Choose Salesforce Data Store. If you are looking for creating a service for any other data store, feel free to choose it.data stores
  2. Configure the Salesforce Data Source as shown below to connect to your data.salesforce config
  3. Click on Test Connection and check if your configuration is correct.
  4. Now go to OData tab, change the OData Version to Version 2 and click on button “Configure Schema”. set odata version
  5. On the next screen you should see list of schemas in your Salesforce account. Choose SFORCE schema.choose schema
  6. You should now a see list of tables as shown below. Select the tables you want to expose through OData REST API. I chose ACCEPTEDEVENTRELATIONS, ACCOUNT and ACCOUNTCLEANINFO table in this case to expose through OData APIselect tables
  7. Click on Save and Close to save the settings.
  8. Back on OData tab, you should find OData Access URI. Copy the URI to another tab and open it. As you might not have proper SSL certificate, you might see unsafe exception. To overcome it, change the URL to http://<Server>:8080/api/odata4/<yourdatasourcename>
  9. You should now be prompted for your Hybrid Data Pipeline Credentials, after you enter it you should see the following response, which basically lists out all the tables that are exposed.odata response

Connect to Salesforce OData Service from SAP BO Cloud

  1. On SAP Business Objects Cloud dashboard, from Side menu, go to Connection view.
  2. Add a New Connection -> Import Data Connection -> OData Services as shown belowcreate odata service
  3. Now, you should see a New OData Services Connection configuration forum, fill it up as shown belowodata service config
  4. Click on Create, and you should have a new connection for Salesforce via OData.
  5. Go to Create -> Story -> Access & Explore Data and choose Data acquired from Data Source
  6. You should see a Data Source selection pop up as shown below, Choose OData Services as your data source.
    Choose Odata service
  7. You should now see a popup as shown below, Under Connection, choose Salesforce connection you just created in the previous steps. Click on OK to proceed.Select Salesforce Odata service
  8. You should now see list of tables available through the Salesforce OData connection, choose any table that you would want to import as shown below.select table
  9. On the next screen, you are asked to build a query. Choose the columns you want, filters you want to apply and click on Create to start importing the data.select columns, apply filters
  10. You should now have all your Salesforce data imported into SAP Business Objects cloud as shown below. results

It is so simple with Progress Hybrid Data Pipeline to import your data from any cloud data sources, Relational Databases – even if they are On-Premise in to SAP Business Objects Cloud. If you didn’t find the data store that you want to import, don’t worry we have got you covered too. You can bring your own JDBC driver and plug it into Hybrid Data Pipeline and it will generate OData service for you. Feel free to download and try Hybrid Data Pipeline and feel free to contact us if you have any questions or issues.

OData, Cloud and Hybrid TUTORIAL

Connecting to Salesforce, Eloqua, Google Analytics etc., from SAP Business Objects Cloud

DataDirect
connectors

Connect any data source to any application

DataDirect
Tutorials

Discussions, tips and tricks for
DataDirect Connect drivers