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.
- On SAP Business Objects Cloud dashboard, from Side menu, go to Connection view.
- Add a New Connection -> Import Data Connection -> OData Services as shown below
- Now, you should see a New OData Services Connection configuration forum, fill it up as shown below
- Click on Create, and you should have a new connection for Salesforce via OData.
- Go to Create -> Story -> Access & Explore Data and choose Data acquired from Data Source
- You should see a Data Source selection pop up as shown below, Choose OData Services as your data source.
- 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.
- 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.
- 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.
- You should now have all your Salesforce data imported into SAP Business Objects cloud as shown below.
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.