Invoking the connector rule in extender rule
Hi All - I have a requirement to automate the data load from ERP to OS every couple of hours and it is an On-Prem ERP. My below is my approach. 1. I was able to integrate the ERP to OS using th...
Forum Discussion
Hi Kris,
You can only call a connector business rule from an import workflow step.
Now what you can do is automate the import validate load step from an extensibility rule to call your connector rule using an extensibility rule and you can then schedule it using the task scheduler.
You'll need API calls to build your extensibility rule.
wfClusterPk = BRAPi.Workflow.General.GetWorkflowUnitClusterPk(si, wfProfileName, scenarioName, timeName)
BRApi.Import.Process.ExecuteParseAndTransform(si, wfClusterPk, String.Empty, Nothing, TransformLoadMethodTypes.ReplaceAllTime, SourceDataOriginTypes.FromDirectConnection, True)
BRApi.Import.Process.ValidateTransformation(si, wfClusterPk, True)
BRApi.Import.Process.ValidateIntersections(si, wfClusterPk, True)
BRApi.Import.Process.LoadCube(si, wfClusterPk)
Thanks, Omkareshwar
Archetype Consulting
Thanks Omkareshwar. What API calls I require ? to call the connector rule ? Could you please explain more on this topic?
The connector can only be executed from the Import step so you're not calling the connector rule you'll be executing the Import Validate Load step from the Extensibility rule using those API calls. You can read this post to get more idea about that https://community.onestreamsoftware.com/t5/Workflow-and-Data-Integration/Automating-WF-Execution/m-p/10247
Thanks this was Helpful.
