Question Re: External DataFlow Trigger on Event - Is this possible? in Technology Q&A

External DataFlow Trigger on Event - Is this possible?

cp11 — Tue, 02 May 2023 06:57:29 GMT

Hello SAP experts,

Is there a possibility to trigger a DataFlow of the SAP Datasphere, which is currently triggered by a scheduler, also by a specific event?

The idea would be to trigger the DataFlow in the SAP Analytics Cloud, e.g. via a button, whereby the most current data would be pulled.

Is there a possibility or workaround to implement such a project, and if so, how would I have to proceed?

Many thanks

Chris

Re: External DataFlow Trigger on Event - Is this possible?

amlan_dhow — Tue, 02 May 2023 07:31:53 GMT

Also it might be relevant to ask along with this question how "change data capture" can be implemented along with data flow when data will be loaded from any SAP or non-SAP source without loading the complete data from source during delta load.

Re: External DataFlow Trigger on Event - Is this possible?

Sven_Knpfler — Thu, 04 May 2023 07:42:25 GMT

The feature you ask for is on the roadmap for this quarter: https://roadmaps.sap.com/board?PRODUCT=73555000100800002141&range=CURRENT-LAST#;INNO=E78B0E4728D31EDDA3FE6C6644D2D4B4

Regarding change data capture:

in data flows you can only use generic delta via a dynamic where condition for the following connections at the time of writing: SAP SuccessFactors, OData, and Cloud Data Integration (CDI) sources
Remote Tables and Replication flows support delta loads for cdc enabled CDS views

Re: External DataFlow Trigger on Event - Is this possible?

cp11 — Fri, 05 May 2023 05:29:36 GMT

That's good news, then I look forward to this feature and am excited how the implementation will look.

Thanks Sven for the info

Re: External DataFlow Trigger on Event - Is this possible?

pavan_kumar_yanman — Wed, 29 Nov 2023 19:58:00 GMT

Hello Sven,

Is that External API delivered?
I can't find it in the link you've shared.

If it's released, can you refer me to the correct chapter in the Help documemtation?

Regards,

Pavan

Re: External DataFlow Trigger on Event - Is this possible?

Sven_Knpfler — Wed, 29 Nov 2023 20:19:02 GMT

Hello Pavan,

You can use the CLI for that task: https://help.sap.com/docs/SAP_DATASPHERE/d0ecd6f297ac40249072a44df0549c1a/2b26a31f197444dea314495bc0008eae.html?locale=en-US

Kind regards

Sven