Forum Discussion

Krishna's avatar
Krishna
Valued Contributor
2 years ago

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 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.

 

Data Integration
Data Management
  • Omkareshwar's avatar
    Omkareshwar
    Contributor II
    2 years ago

    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

  • Henning's avatar
    Henning
    Valued Contributor II
    2 years ago

    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.