Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
6 years ago

has anyone done data import/validate/load automation using the connector business rule?

Originally posted by Ashok Amresh We are loading data using SQL connector business rule and it works fine manually. looking for a way to load it automatically using a extender business rule and the...
Dashboards
OSAdmin's avatar
OSAdmin
Valued Contributor II
6 years ago
Originally posted by Frank Dossing

hi Ashok,

 

you can trigger a workflow load by using the BRApi method as below:

If BRApi.Import.Process.ExecuteParseAndTransform(si, wfUnitClusterPk,Nothing,Nothing,TransformLoadMethodTypes.Replace,sourceDataOriginTypes.FromDirectConnection,False).Status = WorkflowStatusTypes.Completed Then

There are methods for import, validate and load.

 

So setup a function that triggers a specific workflow, then you can call that function from a DM.