Export data using Cloudworks

Hi,

Is there a way i can use CloudWorks to export data without using the connector? I cannot select the Target folder where i want to save the extracted file.

Thanks in advance for helping.

Regards,

Tom

Accepted answers

alexpavel

@tompatrick.ting Cloudworks is not the tool to be used to export automatically data from Anaplan on a shared local folder.

The reason is that the export action is triggered on Anaplan Cloud servers and Anaplan does not have access on your local shared folders.

You need to use some ETL tools that support REST API calls or Anaplan Connect or you can write custom REST API scripts to trigger export actions and download files on local folders.

Hope it helps

Alex.

All comments

alexpavel

@tompatrick.ting Not sure what would you like to achieve.

Anaplan needs to know where is the target to place the export files and this is why it is needed a connection to AWS or Azure.

Currently, for import from file/export actions, the source/target can be placed only from/into AWS or Azure.

Hope it helps

Alex

tompatrick.ting

Hi @alexpavel - is there an option that i can skip the AWS or Azure? I want to automate the data extraction and be able to save the csv file to a sharedfolder.

Thanks,

Tom

alexpavel

@tompatrick.ting Cloudworks is not the tool to be used to export automatically data from Anaplan on a shared local folder.

The reason is that the export action is triggered on Anaplan Cloud servers and Anaplan does not have access on your local shared folders.

You need to use some ETL tools that support REST API calls or Anaplan Connect or you can write custom REST API scripts to trigger export actions and download files on local folders.

Hope it helps

Alex.

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…