The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Direct Load Automation
Hello Everyone,
We have been using ExecuteFileHarvestBatch to automate our Data Loads. However I could not make it work for Direct Load profiles.
Is anyone aware if we have api support to automate Direct Loads?
Apologies.
BRApi.Utilities.ExecuteFileHarvestBatch works for Direct Load as well. The issue was due to a different piece of code that tried to clear stage data for Direct Load Workflow Profile.
Thanks!
9 Replies
I always try not to use the batch harvester. I've always used the import process API calls to do it. Look at https://community.onestreamsoftware.com/t5/Workflow-and-Data-Integration/Automating-WF-Execution/m-p/10247?search-action-id=7866072495&search-result-uid=10247
Any specific reason to stay away from the batch harvester?
Earlier, the files and folders created by the batch harvester cannot be deleted. I guess there is some utility I saw during Wave that can do it. Then there is an issue with file locks and it will not work when there are file locks.
Thanks for taking the time to respond.
I am indeed searching for Direct Load process API but could not see anything around Direct Load WFP within api viewer,Do let me know if I am missing something.
Thanks,
HirenIf you look in the link to the other post, this call:
Dim ImportInfo As LoadTransformProcessInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, wFClusterPk, "", Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False)
references to use the ".FromDirectConnection" which I believe is the one you're looking forThanks Frank, let me try that one!
Apologies.
BRApi.Utilities.ExecuteFileHarvestBatch works for Direct Load as well. The issue was due to a different piece of code that tried to clear stage data for Direct Load Workflow Profile.
Thanks!
