SAP OpenConnectors - Parameterize Request from SAP Datasphere

[d_schubert]

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)

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!

[vishalakshmi]

Hello Daniel,

Can you refer to the document?

https://help.sap.com/doc/aa5cd4412124489490cb864a6139526c/cloud/en-US/DWC_Acquiring_Preparing_Modeli...

Thanks,

Lakshmi.

[d_schubert]

Hi Lakshmi,

thanks for your answer and the link to the document!

But inside the document there is no specific chapter about how to handle API connections and their parameters.

What it tells about is "How to create a Dataflow" and filter inside of such a flow.

The thing with OpenConnectors seems to be that the initial call from the source (lets call it TableA in source system SF) is always done without any filters.

So you get the full dataset into the DataFlow, then filter and store the data.

We need to have some kind of setting for the source element to use a filter string (Where-Clause).

Using the API in a tool like Postman we can for example use the POST-method to post a Query-Job with certain restrictions. Then use the GET-method to fetch the result.

[albertosimeoni]

Hello @d_schubert, How can we know in advance if a connector will work for Datasphere?