CloudWorks performance question

We were considering using Cloudworks for integration instead of Anaplan Connect scripts and someone is dissuading us from using Cloudworks because it had "performance" issues because there is only one server dedicated executing all actions setup on Cloudworks? Is this true as I'm unable to find any such information on this forum? Also, are there any advantages of using Anaplan Connect scripts vs Cloudworks and vice versa?

Accepted answers

Misbah

@TristanS

CloudWorks indeed is slower as compared to any other tool but that doesn't mean it takes hours instead of minutes. I have experienced it to be slower but it does the job very well. I would say if you are planning to schedule the jobs in non Business hours then there should not be any issues. As of today CloudWorks can work only with AWS S3, Google Big Query and Azure Blob. You can also build your own integration with CloudWorks API. It is easy to use and doesn't need any technical resource.

Anaplan connect on the other hand works on batch or shell scripts. You will have to have common interface to place Anaplan Connect and Scripts on the folder and then you would need scheduler to run the jobs. Anaplan Connect OAuth need you to have dedicated resource who could understand the technicalities of these scripts.

Thanks,

Misbah

Miz Logix

All comments

Venki9902

Hi @TristanS ,

I think its totally depend on the business needs.

Advantages and disadvantages of using Anaplan connect:

1.For suppose if you are getting files monthly basis and your file name has timestamp then using cloudworks is not feasible option.

2. If you want the maintance of the files like archiving the loaded files then using Anaplan connect achive that.

3. You would definitely need some server or something to schedule your scripts and getting files to that server.

4.using cloudworks makes filenames as static.

These are some of the differences.

hope this helps:)

regards,

Venkatesh

Misbah

@TristanS

Thanks,

Misbah

Miz Logix

TristanS

Just to close this topic off, I have done some performance statistics on Cloud Works. High level summary I would recommend it's use. There are some lag which I believe is negligible. For detailed statistics continue to read below.

I scheduled it to run an Anaplan Integration Flow containing 2 processes every hour at 20 minutes past the hour for 7 days.

Statistics on scheduled execution

96% of the time it ran within the minute of it's scheduled execution time
2% of the time it ran 4 minutes past it's scheduled execution time. It happened on a weekday and not the weekend where I would assume most batch processes are executed
2% of the time it ran 1 minute past it's scheduled execution time.

Statistics on execution time

Each of the process in the integration flow ran about the same time if the process was ran manually
Where it got interesting though was the gap between execution of processes within the integration flow. So I had 2 processes sequenced in my integration flow. The second process would start roughly one minute and thirty seconds after the 1st process completed execution. I'm guessing it has to do with condition checks Cloud Works does to determine whether to execute or abort subsequent processes. In the scheme of things this is an acceptable delay.

TristanS

Providing an update on CloudWorks as we've experienced with one of our clients. Since we went live with CloudWorks on Nov 2023, there has been 2 instances that CloudWorks did not execute a set of scheduled daily integration flows (occurred once a month). There were no scheduled Anaplan outage when this occurred and Anaplan Support is currently investigating. There were jobs scheduled to execute at 2am and 8.15am. The jobs scheduled at 8.15am did not execute at all in these 2 instances but executed the jobs scheduled at 2am.

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…