Skip to main content
H
hiren
February 21, 2023
Solved

Direct Load Automation

  • February 21, 2023
  • 3 replies
  • 3 views

Hello Everyone,

We have been using ExecuteFileHarvestBatch to automate our Data Loads. However I could not make it work for Direct Load profiles.

Is anyone aware if we have api support to automate Direct Loads?

    Best answer by hiren

    Apologies. 
    BRApi.Utilities.ExecuteFileHarvestBatch works for Direct Load as well. The issue was due to a different piece of code that tried to clear stage data for Direct Load Workflow Profile.

    Thanks!

    3 replies

    C
    ckattookaran
    February 21, 2023

    I always try not to use the batch harvester. I've always used the import process API calls to do it. Look at https://community.onestreamsoftware.com/t5/Workflow-and-Data-Integration/Automating-WF-Execution/m-p/10247?search-action-id=7866072495&search-result-uid=10247

     

    F
    FrankDK
    February 21, 2023

    Any specific reason to stay away from the batch harvester?

    C
    ckattookaran
    February 21, 2023

    Earlier, the files and folders created by the batch harvester cannot be deleted. I guess there is some utility I saw during Wave that can do it. Then there is an issue with file locks and it will not work when there are file locks.

    H
    hirenAuthor
    February 22, 2023

    Thanks for taking the time to respond.

    I am indeed searching for Direct Load process API but could not see anything around Direct Load WFP within api viewer,


    Screenshot 2023-02-22 at 10.33.04 AM.png


    Screenshot 2023-02-22 at 10.28.49 AM.png

     

     

     

     

     

     

     

    Do let me know if I am missing something. 

    Thanks,
    Hiren

    F
    FrankDK
    February 22, 2023

    If you look in the link to the other post, this call:
    Dim ImportInfo As LoadTransformProcessInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, wFClusterPk, "", Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False)

    references to use the ".FromDirectConnection" which I believe is the one you're looking for

    H
    hirenAuthor
    February 23, 2023

    Thanks Frank, let me try that one!

    H
    hirenAuthorAnswer
    February 22, 2023

    Apologies. 
    BRApi.Utilities.ExecuteFileHarvestBatch works for Direct Load as well. The issue was due to a different piece of code that tried to clear stage data for Direct Load Workflow Profile.

    Thanks!

    Terms & ConditionsAccessibility statement