HCI DS - DataFlow trigger on an event

[Former Member]

Hi,

Is there any way to trigger scheduled DF in HCI based on some event or some flag?

E.G. Data is extracted from BI, but we want schedules to run only when BI process chain is completed.

BI team can generate any type of file or some status message based on our requirement, but I still couldnt figure out how can I use that to make sure job has runonly after BI PC is over.

I limitation of HCI is that I cant have multiple DF which are dependent on different DS. E.G. 1 DF to extract from FF and other from SAP system. If this was possible, then I do have the solution.

Thanks,

Purav

[Alecsandra · Accepted solution]

Hi Purav,

You could achieve this using an external schedular.

HCI doesn`t have explicit support for external schedulars, but with webservices API to start and monitor HCI tasks - you can use any scheduler that can call web services.

Also check 1.0.8 release - process feature. You can group data flows with different sources and specify the execution order.

http://help.sap.com/businessobject/product_guides/hci1/en/hci10_whats_new_en.pdf

Regards,

Alecsandra

[Former Member · Accepted solution]

Hi,

Yes I did read about Process Feature. As the servers are now UP will test on how to work with Process.

Could you please elaborate more on W/S part which you have mentioned?

Thanks,

Purav

[Alecsandra · Accepted solution]

Best would be to check with someone knowledgeable about external schedulers.

HCI available documentation is here:

http://help.sap.com/businessobject/product_guides/hci1/en/hci10_web_services_en.pdf

http://hcids.hana.ondemand.com/DSoD/webservices?wsdl

[Former Member · Accepted solution]

Thanks for help.

[Former Member · Accepted solution]

Hi,

I found out about wait_for_file parameter / script. But when I write this code in preload script area, HCI says this function is not allowed.

But still I tried and mentioned the path of file with ref of local drive, and it works, but if I mention network path then i get (-2) as a return when I print the info.

Network Path specified as :

\\<servername>\<dirname>\<filename.ext>

Thanks,

Purav

[Former Member · Accepted solution]

Hi Purav,

Any updates on wait_for_file parameter /Script since May 5?

The way I understand from your last comment is that wait _for_file works for local file, but, not for network file. Has anything changed since then? 

We have similar needs, and your research will help us.

Thanks,

Kesava.

[Former Member · Accepted solution]

Hi,

No. Nothing is changed.

Thanks,

Purav