cancel
Showing results for 
Search instead for 
Did you mean: 

SAP SAC trigger to upload file??

vitran23
Active Participant

Is there any plans to add a trigger system to trigger uploads of flat files into SAC? Example of needing to see a file has been updated before the scheduled upload occurs? Could be similar to events in BO?

Accepted Solutions (1)

Accepted Solutions (1)

DebjitSingha
Active Contributor

Hello vitran23,

Current road map explorer do not show any mentioning of event based trigger setup or API's to support similar function.

Influence portal have couple of similar enhancement request and some of them are already under acknowledged status. Here is the parent enhancement request with most votes. However, flat file upload would be supported via file server and not from local desktops.

https://influence.sap.com/sap/ino/#/idea/235378

If you looking for triggering setup other way around, from SAC to other source systems then similar setup already exists-

How to use an S4/Hana OData service in Analytics Designer?

Quickly integrate SAP Analytics Cloud with other systems using custom widgets

Hope this helps. Let us know if you have any query around this topic.

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

- Debjit

vitran23
Active Participant

Thanks for the quick reply. We are currently using the file server method to update our data sources.

I was looking for a quick method with the file server upload process while we continue working on getting out BW live connection setup which would solve the need for events / trigger files.

DebjitSingha
Active Contributor

Hello Hello vitran23,

So basically if you are looking for external trigger option. It is an open request at this moment. In other words, it is not yet supported. Feel free to vote this enhancement on influence portal.
At present you can setup fixed schedule setup on file server.

As an alternative, you can try what we did with one of our setup. We have file server folder where vendor is suppose to save a file. Now date and time for the file is not fixed. Business users wants this file to be updated in SAC within an hour of upload by vendor team.

We setup two jobs running every 1 hour, with overlap. This lets us run refresh job every 30 mins. We instructed Vendor team to have a column in file as "Creation Date". Our query in SAC side use this field as incremental load. So when ever SAC query detects incremental entry in this column, file gets processed and loaded into SAC. Else, if it finds a date entry that is already processed it gets skipped. As SAC job is running every 30 mins, worst case scenario, file processing gets delayed by 30 mins (not more than that). If you want, you can setup more or less jobs as per requirement. SAC by default supports every hour frequency. Multiple jobs lets you get around this limitation.

Thanks,

Debjit

vitran23
Active Participant
0 Kudos

Thanks for that suggestion and yes that’s the correct scenario we are trying to achieve since we need BW data loads to be updated before our flat file gets produced and uploaded.

DebjitSingha
Active Contributor

Hello vitran23,

Incremental load is supported on flat files (via file servers) and you can schedule it as well. You can set dependencies between BW load jobs and Flat file load job in SAC. You can set behavior of the dependent jobs (flat file jobs) as well. Say you want flat file job to trigger only when BW job completes successfully. Only thing that you can not do at this moment is trigger BW extract in SAC from out side of SAC or trigger this job based on an event in SAC. BW extraction job need to be scheduled at predefined time interval.

Thanks,

Debjit

vitran23
Active Participant
0 Kudos

What do you mean by SAC query? I haven’t seen where you can create that?

DebjitSingha
Active Contributor
0 Kudos

SAC query ~ import Job

vitran23
Active Participant
0 Kudos

Ok I reread and you said your running a load every 30 minutes with 2 jobs. One set on the hour and the other set on the half hour. Are these schedules running all day long?

DebjitSingha
Active Contributor
0 Kudos

Yes, if you space two jobs 30 min apart with 1 hour frequencey each. You are basiclay refreshesing every 30 mins..

Answers (1)

Answers (1)

William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

Starting from last year, multi-action can trigger import job, if there is a file server setup, technically an business user can trigger that from story.