-
Exact time in CW process details
I am a CW integrations Admin and have built CW integration between different models that runs every night. I have a lot of processes so I can't put them in one flow. Also I have some processes that should run in parallel, so I left them out of flows and set their own schedule. Setting up the runtimes is very time consuming…
-
How I Built It: Integrations using CloudWorks
Author: Gokul Selvam Sadasivam, Certified Master Anaplanner and Senior Manager, Business Platforms at Okta. Hello Anaplanners! I’m excited to share a video that I created as part of the ‘How I Built It’ video series — diving into Integrations using CloudWorks. In the video, I give a live demonstration of how to use the…
-
CloudWorks Integration with Amazon S3: "There was an internal server error"
Hello, I'm trying to get Anaplan to an Amazon S3 bucket. I have set up a connection and it seems to work, however when trying to pick a data target I keep running into the issue of there being an "internal server error". Any thoughts on how to resolve this?
-
Loading file with different file names for the same action in deployed model
Hi All, I am trying to run the action through Anaplan Connect with different files in deployed model. But the action is running only for the file that matches with the source label of that action and if I use the different file name scripting is failing. Attaching the screenshots for reference. Screenshot1:File name same…
-
Automating Salesforce to Predictive Insights Integration
Introduction Please note: the Salesforce connector for CloudWorks is currently in beta The following document describes the steps needed to automate integration between Salesforce and Predictive Insights. The overall flow described by this document can be depicted like this: This flow will: Load a list of accounts and…
-
Workaround for Access issue with Cloudworks?
Hello everyone, I am currently struggling with CloudWorks integration and I would like to ask if anybody in the Community have faced similar issue before. The setup: We have few modules which have DCA enabled in them - both Read and Write This Read and Write DCA is based off another modules where you basically set up…
-
Extend CloudWorks to support *External tables* in Google BigQuery
CloudWorks currently integrates with Google BigQuery and supports the following table types: Standard BigQuery tables, and Views. It would be useful if this support could be extended to include External tables (where the data is stored outside of Google BigQuery). At the moment I need to create an intermediate table in…
-
Schedule automated Anaplan notifications
As a Page Builder/Integration Administrator, I'd like to be able to schedule Anaplan native UX notifications. This would allow me to send native (instead of email) notifications to a set of users (hard-coded or lineitem-driven) about a predefined page. I'd like to be able to have different scheduling options, each being at…
-
CloudWorks Handshake
Hi, I would like to ask if CloudWorks is able to furnish a handshake mechanism once it picks up a file from an AWS S3 folder? For instance if CloudWorks runs an import into Anaplan, it picks File A from Folder 1 and imports it into Anaplan. How can it provide a handshake that the import has been run? Because the…
-
Impact of model archival on Cloudworks
Hi all, I had to archive the production model, and when I restored it to deployed mode, I've noticed that the connection to Azure scheduled for last night didn't work (I had it rescheduled but it failed). The status is set to "auto deactivated", however if I manually run the processes, they are successful. I have…
-
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…
-
Pro tip: Process & Import IDs
When setting up data integrations the process or import actions are often referred to by name, however, this practice isn't robust and can cause process failures if names are changed in the model. During development and enhancements, a model builder may choose to edit the name of a process or import to the model. This…
-
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:…