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

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
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
Icon for OneStream Employee rankOneStream Employee
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.