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 th...
Data Integration
Data Management
Omkareshwar's avatar
Omkareshwar
Contributor II

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

Krishna's avatar
Krishna
Valued Contributor
2 years ago

Thanks Omkareshwar. What API calls I require ? to call the connector rule ? Could you please explain more on this topic?

    • Krishna's avatar
      Krishna
      Valued Contributor
      2 years ago

      Thanks this was Helpful.

      • BSK's avatar
        BSK
        New Contributor III
        11 months ago

        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.