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
-
@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 flowFor 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.1