07-17-2023 11:51 PM
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 the Smart Integration Connector. - Completed.
2. I am thinking that If I can Invoke the connector rule in the extender rule then I can schedule using the DM. Does that work ? Can I call the Connector rule ? if not any other approach available ?
Please Suggest.
Thanks.
07-18-2023 05:11 AM
Hi Kris, the typical way to do this is not via an extensibility rule, but by using Task Scheduler (see screenshot). This allows you to pick a DM Sequence and execute it as per your requirements.
Please note that when you copy the app, this will also copy the tasks scheduled. Typically one deactivates the tasks in the duplicated app in order to avoid running the tasks unnecessarily multiple times.
07-18-2023 08:06 AM
Thanks Henning for your quick response. Yes I am aware of the Task Scheduler. Can I schedule the connector rule in Task Scheduler ?
07-18-2023 08:55 AM - edited 07-19-2023 02:48 AM
Hi Kris, sorry, I misread your question. There are a few posts covering this topic,. such as:
and
You will find everything you need explained in those two posts.
Basically, you need an Import Workflow step to load the data where the connector rule is assigned to and then execute the WF step via your Extender BR, which in turn you execute from a Data Management Sequence which is then assigned to a task in Task Scheduler.
07-18-2023 09:11 AM
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
07-18-2023 11:39 AM
Thanks Omkareshwar. What API calls I require ? to call the connector rule ? Could you please explain more on this topic?
07-18-2023 04:11 PM
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...
07-18-2023 09:36 PM
Thanks this was Helpful.
02-21-2024 07:48 AM
Hi kris,
Hope you're well.
If this automation is working at your end, could you please post the complete script snippet here, if that's possible. we do have a similat requirement to automate the data loads. Thanks in advance.