Data Integration

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…
Event Registration - API Developer Virtual Meetup
Hi All Our first event for 2023 is right around the corner! Agenda: Welcome and Intro Update from the Anaplan team Demo Q&A Event times: AMER/EMEA: 25th July 09:00-10:00 (PDT) APAC/EMEA: 26th July 13:00-14:00 (SGT) We will record the sessions for those who cannot make the times listed Registration Steps: Register here ⇒…
AnaplanClient.bat is not recognized as internal or external command, operable program or batch file
Hi Team, Could you please, assist with this problem? @echo off rem example. Set AnaplanUser="example@example.com:password" set WorkspaceId="*****************" set ModelId="*****************" set Operation=-via http://example.net:10085 -export "Export_action.xls" -execute -get "D:\output.xls" rem *** End of settings - Do…
3.5.4.1 Level 2 Sprint 3 Supplied By
There is no supplied by in the original data imported into the original models.
CloudWorks scheduled status types
What are the different status definitions for a CloudWorks scheduled process?
Populating list subset based on a Boolean from a specific version of a module
All, I need to update my hierarchical list subset from a module with versions. I have a module dimensioned with my list and a saved view in forecast version with a Boolean formatted line item (already populated and true for several items) based on which I need to update my list subset using action but I couldn't find my…
ALM setup DEV to Test to Prod
Hi Guys How do i setup ALM so that it only works From DEV -- > Test and then only Test --- > Prod Currently i have DEV TEST In deployed mode synced with DEV NO PROD PS:- I know this is against the best practice as we should do DEV --- > Test and DEV ----> Prod but trust me client only want above . Thanks
Anaplan export action list via POSTMAN
Hi All, I have this issue on not being able to get the list of Anaplan export actions or any other artifacts via POSTMAN. These are the steps I am taking - a. Authenticate — https://auth.anaplan.com/token/authenticate (I using basic auth and I am able to authenticate, and I am able to get the tokenValue. b. Model list -…
How to upload file in postman while running a collection
Hi Team, I am trying to import a csv file into Anaplan through API in Postman. When I am running individual requests and upload file in body(binary), it gets uploaded into Anaplan but while running the collection all together and putting file into collection runner, it is throwing error "500 Internal Server Error".…
Integration to a non jdbc driver data provider
Hello all, Can someone let me know different/efficient way to connect a data source for automation syncing data which doesn't have jdbc driver in it.
Application of Filter Condition on Tabular Multiple Column Export
Hi Team, We see a challenge in not getting the Cost Center dimension when filtered to the saved view, it is not getting exported as per the Named Saved views instead we get all the Cost centers as default to the module. This feature is required for us to have it in the Tabular Multiple Column Export for the Integration…
Export from Anaplan to cloud using bulk API
Is it possible to export the files from Anaplan to the cloud other than Azure, Google and AWS? I believe by using Cloud Works API we can export only to Azure, Google and AWS. My client's requirement here is not to use the on premise server for the exports from Anaplan. Primarily they have no on -premise server in their…
L2 Sprint 2 2.3.9.1 Import data into DAT03 Historic Volumes module
H All, What happens in this case. I already pulled DATA from DATA HUB model in to Supply chain model DAT03 Historic Volumes module manually. What happens if I run the process 9 9.1 Import Historic Volumes9.2 Import Opening Stock9.3 Import Shipping Metrics Will I receive any errors in DATA in supply chain. Or The earlier…
Allow option to display status of a running Process/Action via Cloudworks
We are able to trigger a cloudworks job via UX page but there is no way to show the status of the job if its running or finished on the page. This information is vital to inform users so they are aware process if finished and if they are able to continue working.
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…
Bulk Copy On Items Within Modules and Bulk Copy Actions On Dashboards
Hi Anaplan, Currently the ability to 'Bulk Copy' of data only exists a list items data to be copied to another list item across the entire model. My idea is to have the ability to 'Bulk Copy' but only within a module from a list item to another list item within that model. Meaning that the data being copied only happens…
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…
"Line Item identifier(s) were not mapped and ignored" during data import
Hello! I am running an import from saved view into a model and I am facing this notification - it is not an error, but at the same time nothing gets imported because of it. Weird thing that this line item was indeed mapped and it was mapped automatically. Any idea what could be wrong here? Thank you!
Community Perspective: Using OAUTH2 to develop custom Anaplan connector for Azure
Introduction The release of OAUTH2 authentication for the Anaplan API opens the door to developing more native connectors across all the major cloud platforms. In this article, I explain how you can configure a custom connector on Azure for use in Logic Apps. The benefit of a custom connector is that you can expose all the…
HTTP Error 422
I had an import which loads salesforce data into Anaplan using the RestAPI fail today with the 422 error code below: { "status": { "code": 422, "message": "Unprocessable Entity" }, "path": "/2/0/workspaces/8a81b08e5cdbe172015cfb45189104ca/models/43955D63B8BD4E3FA3EA72776BE2CC41/files/113000000080", "timestamp":…
Calendar in the NUX Pages
Hi, Is it possible to put a calendar wherein I can choose the specific month or date in the New UX pages? if possible, how? Thank you!
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…
Managing Anaplan ALM with API using Postman Tool
Hello Team, While am trying to retrieve syncable revision tag from the source model, am facing issue of whose screenshot i have attached below, Reference : I have cross verified the ALM between source and target and also i have verified the Model whether its defined correctly in the environment variable and also checked…
Controlling ALM using Anaplan Connect
Hello Team, Is there any batch script/Anaplan Connect script where we can automate the revision Tag Sync of Datahub with Multiple Production Models ?
Is there a way to integrate mailto function?
Hi, I would like to integrate MAILTO function so that it automatically sends email to dynamic users based on selections done at the backend. Thanks
2.3.8.2 Import into DEM01 Module
Hi everyone, I am trying to do the import into de DEM01 Module, but I keep getting this error. I've seen some similar questions here at the Community but can't really figure it out what everybody did to correct it. I am attaching some screenshots so you can see what I am doing. I really don't know what else I can do. Any…
[Part 2] Script example: Leveraging the SCIM API to bulk remove users
* Prerequisites * Getting started * High level process * Recommended usage * Script walkthrough * Section 1: Libraries * Section 2: Logging configuration * Section 3: SCIM API configuration * Section 4: Authentication * Section 5: Parse CSV file containing Users * Section 6: Call the SCIM to perform the selected operations…
Anaplan Add-On for Google Sheets Not Working
The Add-On for Google Sheets will not open and allow us to connect from large workbooks. It only seems to work with smaller/single sheets. Has anyone else experienced this? Is this a limitation of the add-on?

Data Integration

Discussion List