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

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

  • 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?