Forum Discussion

royari's avatar
royari
Contributor
3 years ago
Solved

Automation of workflow using connector BR

  We are loading data using SQL connector business rule and it works fine manually. Now looking for a way to load it automatically using a extender business rule and then calling from DM step. All d...
Data Integration
Mustafa_A's avatar
Mustafa_A
Contributor II
3 years ago
Copy Link

After you define your Workflow and Current Period. Try using (BrAPI.Import.Process,.....) You should be able to define it to use your SQL data connector. 

brapi.Import.Process.ExecuteParseAndTransform(si, wfClusterpk, Nothing, Nothing, TransformLoadMethodTypes.Replace,sourcedataorigintypes.FromDirectConnection,False)

Repeat this syntax for each step (Process, Validate, Retransform, Load and Process, Certify etc. )  Depends on what you WF looks like. 

  • royari's avatar
    royari
    Contributor
    3 years ago
    Copy Link

    =we want light out automation. Having code on connector how will it help that. There is no way a connector BR runs from DM. ( unless i dont know of). The only way the connector runs , is when an user clicks on the import button.