Automatic Scheduling in Data Orchestrator

zaingaba
zaingaba
in Integrations and extensibility

Hi,

I hope this message finds you well. I am new to Anaplan Data Orchestrator (ADO) and would greatly appreciate your input.

I have successfully created data sources, transformation views, and links to the spoke model in ADO. However, since I am currently performing a manual upload of a CSV file, I would like to know if there is a way to automate or schedule the data push into the spoke models.

Specifically, I am looking for ADO to automatically pull data from BPC through the BigQuery connector and push it to the spoke models according to a defined schedule. At the moment, I do not see any options within ADO that offer this functionality.

I look forward to your suggestions.

Best regards,
Zain

Answers

  • alexpavel
    alexpavel
    edited April 17

    The automation with ADO it is done using the Workflow …

    The refresh data sources as CSV files cannot be automated.

    The refresh of a data-sources can be automated if the source of data is a Cloud system (like BigQuery).

    In Workflow you need to create a Template..and the workflow templates can be scheduled.

    In Workflow can be automated

    • Refresh data source (takes data from source to update the data source)
    • Launch a ADO Link to update the spoke models objects with latest information from data sources

    Here is the lesson about ADO scheduling: https://community.anaplan.com/kb/articles/153735-schedule-a-link-to-run

    I am not familiar with all the ADO connectors.. There are some SAP connectors capabilities, but I am not sure if you can connect to BPC. It is possible that you need to split your integration in 2 steps:

    • create a schedule to export data from BPC to BigQuery
    • create a ADO data source from BigQuery to ADO for Anaplan

    Hope it helps

    Alex

Categories