How to Enable End-Users to Upload Files in Anaplan UX and Process via ADO

Hi,

I’m looking for the best approach to allow end-users to upload a local CSV file from an Anaplan UX Page, but have the data first processed through Anaplan Data Orchestrator (ADO) before importing it into an Anaplan model.

Currently, I see that Anaplan UX allows file uploads through an Import Action, but this sends data directly into an Anaplan module. However, I need the file to first go through ADO for preprocessing and creating a transformational view (e.g., data cleansing, adding new columns, hashing unique IDs etc. ) before being loaded into Anaplan.

I’ve searched through the Anaplan documentation, but I haven’t found any clear guidance on how to achieve this.

Would appreciate any insights or best practices on how to best set this up within Anaplan!

Thanks!

Best Answer

  • SriNitya
    Answer ✓

    @ddamerji
    I’m looking for the best approach to allow end-users to upload a local CSV file from an Anaplan UX Page, but have the data first processed through Anaplan Data Orchestrator (ADO) before importing it into an Anaplan model. → As of now such option is not available.
    ADO flow

    For the existing action ADO process can be created.
    Revisit → ADO Migration Tooling with the process of migration tooling for the existing action ADO steps can be created in which Anaplan come into picture.