CloudWorks

CloudWorks
Have you been wondering about Anaplan CloudWorks™ and how it can help you? Anaplan Academy is pleased to announce a course that will answer all your questions. CloudWorks provides an integration framework that uses an agile approach to integrate data directly into the Anaplan platform. In this course, you’ll learn how to…
Cloudworks Only Exporting Column Headers
Hi All, I have created intergration processes via Cloudworks to export data into Azure blob but they are only exporting the column headers of the export action. I am having this issue for all intergrations created for this model. Other model does not have this problem. Do you know if it might be a bug or security issue. I…
Automating Cloud to Predictive Insights Integration
Introduction The following document describes the steps needed to automate integration between cloud data sources and Predictive Insights using CloudWorks. In the document, we will use Amazon S3 integration as an example, but other cloud data sources are also supported. For simplicity, account data will be referred to, but…
Use columnar file formats with cloudworks
WIth the ability to connect cloud storage to anaplan with cloudworks, it would be great to be able to use columnar file formats (like parquet or orc). Parquet format is considered a better file format for analytical workloads as large sets of data can be read faster than with row files format (.csv, .txt, .tsv..). As these…
Automate actions that run the Anaplan Optimizer with Anaplan Connect, Cloudwork and the Anaplan API.
Until today, actions that run the Anaplan Optimizer are not supported by Anaplan Connect, CloudWorks and the Anaplan API. Because of that, it is not possible to put any processes that include the optimizer on schedule. This is blocking a number of use cases that could add value to our client.
CW flow's step startup settings
This would be a very convenient option: start a step and not wait for it to finish. For example, I need to wake up the model that will be needed in step 7. It takes 30 minutes to wake up, so I have to start waking up in parallel with step 4.
CloudWorks - Ability to add up to 50 steps to the Integration flow
As a tenant administrator and model builder, I scheduled 39 CW processes during the nightly integration. It's pretty hard to schedule them separately one after another, so an integration flow would be a lifesaver, but now you can only add 10 steps to one integration flow, so the new mechanism doesn't solve the problem…
[UPDATED] OEG Best Practice: Integration Scheduling in Anaplan CloudWorks
Introduction Anaplan CloudWorks enables seamless data integration between Anaplan and other cloud-based applications. To optimize performance and efficiency, it's crucial to follow best practices when scheduling integration tasks. This article outlines recommended guidelines for creating integration schedules in Anaplan…
Allow .tsv files in the Cloudworks UI (again)
The Situation Currently we import all our files as a tab separated file (tsv), bundle a set of import actions in a process and orchestrate these processes trough Cloudworks Integrations. Tab separated files are one of the first possibilities in the file options: To indicate such a file is tab separated all our files are…
Tableau to Anaplan Integration
Hi Everyone, I was doing POC for Integration between Tableau and Anaplan, where we export the data from Tableau as a file(.csv) and load the file into Anaplan. Thought of sharing my approach here. Below are the prerequisites we would need to proceed further. Download the latest Tableau Desktop from the Tableau Website and…
Manual Input for Recipients of Notifications - CW
At the time of writing of this post, it's only possible to choose from a limited list of recipients who receive the Notifications of CloudWorks integrations. However, it would be very convienent to be able to manually input email adresses of the recipients. This would allow to send the notifications directly to Team…
CW settings report
It would be very convenient to export all CW processes to a table to quickly check settings between processes, without waiting to load, because now you have to click on each process and wait 2-3 seconds to load the fields in the first tab, then wait again for the second tab, then click on the next process and wait again.
New option: CW process on User Experience action cards?
Hi all, I noticed today that there is a new option in the CW process editing menu: "Make this available on User Experience action cards". I couldn't find any instructions on this field in Anapedia. When I set it to TRUE, nothing changed: I couldn't find it in the list of available processes on the NUX action card (the…
Cloudworks integration user role
As a tenant admin, i would like to allow users to run cloudworks integrations and processes that have been prepared by integration admins. This is required as currently only the integration admin can access and run cloudworks processes and if granted to non admin users, they could destroy existing production setups. I will…
Does file ID change if I update the import source for an action?
Hi all, We are testing bulk API's data import, on which I had 2 queries. Suppose I create an action in Anaplan for a file and then data in loaded using bulk API's, but later I went to manage import data sources and updated the import source of that action with a new file. Will this change the file ID of the file which is…
CloudWorks Integration Flow || Regarding Blocking Actions
With the new integration flow feature available in CloudWorks, I wanted to get some information on how it blocks the related models for running the import. Consider the below scenario. Integration Flow 1 consist of 2 integrations (INT 1 and INT 2) INT 1 runs a process in Model 1 INT 2 runs a process in Model 2 Now if I add…
Possibility to put a process into a process
Right now we have a large integration process with ~240 actions importing data from 8 different models into our Data Hub. As you might imagine, it's difficult to determine the right order of actions with the current interface. I would like to have 8 sub-processes (e.g. 1 per model) to have a better overview of the content.…
Schedule of CloudWorks only working days
Hi, I want to run process on 1st Working days in CloudWorks. If I want to do this, I should use CloudWorks API? Month First Working day 4 3 5 1 6 1
Waking up the model with Cloudworks
Hi everyone, As you know, initializing the model (moving it from disk to memory) can take a while, especially for the larges ones. This can be quite painful for the first users of the day, or for the first one to connect after lunchbreak. I don't find precise or recent informations about it, so here are my two questions:…
Non Workspace Admin Integration Admin
Hi, Just wanted to understand if it is possible to assign someone with the 'Integration Admin' rights but not the 'Workspace Admin' rights. Could not find any related literature. Regards, Aakash Sachdeva
How to connect azure blob storge in Cloud works to integrate Anaplan to Azure. Facing an error.
I have created a SAS token for azure blob storage, but when i enter it in Anaplan to create a connection it is giving me "Failed to create a connection. Azure Blob HTTP Error." I have followed technical documentation Steps, but unable to find a solution.
CloudWorks: sequential process startup
Hi everyone, In addition to the scheduled startup, please implement the ability to start the process sequentially. We have 30+ night integrations and we've spent a huge amount of time setting up start times for each of them. Since the duration of each integration is not a constant value, but can vary widely (instead of 4…
Reflections from ACE: CloudWorks for Anaplan CoE enablement
Author: Tiffany Rice, Certified Master Anaplanner and Anaplan Model Builder, Prudential Financial. With a new year upon us, this is a great time for reflection on the prior year and the capabilities that have been added to Anaplan. During the recent Anaplan Community Experience (ACE) this past November, there was an…
Workflow triggers Import/Export
Having CloudWorks schedule imports between models is useful, but users still need to wait. Our users are participating in a workflow, data is ready to move from the source model when a workflow step is completed. Can we trigger imports or exports, or model-to-model imports from workflow?
Cloud works AWS S3 Automatic file selection from dropdown
In Cloud works AWS S3 connection, user get to choose file from dropdown. If a similar file is generated month on month with a slight change in name (For e.g.: ABC_Apr22, ABC_May22 etc.), then user will have to manually change the data source and there will be no automation for this. I recommend giving asterisk/wildcard…
Any idea for getting current date that always up to date in Anaplan
I need an idea for getting current date in Anaplan.
CloudWorks: customizing the integration list
Hi all, To make working with the list of integrations faster and more convenient, I propose to make it possible to change the columns in the list by adding any necessary fields from the "Overview" and "Schedule" tabs (selecting the necessary fields with checkboxes in the list menu). This way, you won't have to click on…
delimiter options for exporting files from Anaplan
I love the two way integration that Cloudworks brings but there is a need for more delimiter options when exporting from Anaplan back to Data Lake. Example changing the delimiter from "," to "|". More export file options is needed.
Maxmise compatibility for exports containing dates and periods
Anaplan is using a unique date format “1 Jan 22” and “Jan 22” as opposed to “2022-01-01” and “2022-01”, which are more common in data science. When Anaplan data containing dates and periods (e.g. the daily traffic per shop) is exported to another system (in this example I use Google BigQuery with the CloudWorks Connector),…
When builders update action triggered from CloudWorks, don't require CloudWorks rebuild
Input from customer implementation team which uses CloudWorks to trigger Anaplan actions. "When we want to edit or change an Anaplan action that is embedded in a CloudWorks process, we risk breaking the process and requiring a rebuild. Our processes are large by necessity. We frequently update actions/process in the…

CloudWorks

Discussion List