Forum Discussion

RamireddyPrem's avatar
RamireddyPrem
New Contributor
2 years ago

Business rule to upload the file and then Import using Workflow

Hi, We are trying to automate the File-based Import data, Validate data, and Load data to the cube process using the business rule. So, could you please let me know how I can procced as I am new to ...
Data Integration
Data Management
Import
Jarek_Sadowski's avatar
Jarek_Sadowski
New Contributor II
2 years ago
Dim wfClusterPkBig As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, "WorkflowName", "Actual", "2023M1") 

Dim wfClusterPk As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, "WorkflowName.Import", "Actual", "2023M1") 

BRApi.Import.Process.ExecuteParseAndTransform(si, wfClusterPk, "DataSourceNameYouCanFindInOneStreamApplication", Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False) 

BRApi.Import.Process.ExecuteRetransform(si, wfClusterPk) 

BRApi.Import.Process.ValidateTransformation(si, wfClusterPk, True) 

BRApi.Import.Process.ValidateIntersections(si, wfClusterPk, True) 

BRApi.Import.Process.LoadCube(si, wfClusterPk) 

BRApi.Workflow.Status.GetWorkflowStatus(si, wfClusterPk, True) 

BRApi.DataQuality.Process.StartProcessCube(si, wfClusterPkBig, stepClassificationTypes.ProcessCube, True)

My solution for a part of the problem (it works in case we defined Connector, not sure how to import files)

  • Jones's avatar
    Jones
    New Contributor III
    2 years ago

    Hey, did you manage to solve this? I have the same wonder. All seems to work unless the Path= for source file. 

    • Jones's avatar
      Jones
      New Contributor III
      2 years ago

      Manage to find my issue. sourcedataorigintypes syntax was wrong.