Skip to Content
0
Aug 29, 2023 at 08:08 AM

SAP OpenConnectors - Parameterize Request from SAP Datasphere

195 Views Last edit Aug 29, 2023 at 08:08 AM 2 rev

We are currently exploring the implementation of SAP OpenConnectors to connect our 3rd Party Tools (like Salesforce or GoogleAnalytics) to SAP Datasphere.

We created an instance of Salesforce Service Cloud an have been able to fetch data for certain tables.

The big "BUT" is that we are not able to add filters to our extraction, so we always get the full table content per request.

Having a look into the API Docs inside of OpenConnectors we can see that there are APIs that can handle a where-condition (see screenshot)

image.png

Is there any possibility to fill this where-string inside of SAP Datasphere so we can trigger dataloads for specific data of our 3rd-Party-Tools?

Is Datasphere even using these APIs?

It would be much easier/faster/cost-efficient to only load data that we really want to have (like a specific region, only last x days etc.)

Help is very much appreciated!

Attachments

image.png (74.4 kB)