Data Integration

Selective access for lists from dashboards.
I am trying to enable the user to give selective access on a list via dashboard. I published the list to the dashboard and can clearly see the "Read" and "Write" columns on the dashboards, however if I save the dashboard and close and reopen it , the columns of "Read" and "Write" are not visible. Can somebody explain what…
Part 8: Import data into REV02 Volume Inputs modulePage
Hello Group, I got lost in trying to import Volume+inputs.csv into my Rev02 Module. In the attached screenshot what should map into "REV02 Volume Inputs Line Items (Volume)". Thank you very much in advance. Jayan
Docusign not reading Anaplan fields
Hi , I am trying to integrate anaplan with Docusign for my client . Letter is sent but without data in tags . I am trying with only one tag ,doing mapping correctly . When I tried the same in my own company's workspace ,it worked well that to with free trial docusign account but same set up not working in clients workspace…
Anaplan + Boomi Integration
Hi Team, I have flow which runs using Boomi. In this flow data being pushed from DB to Anaplan (upload). While running this flow, i'm getting below error message. [1001] cannot parse the JSON response. HTTP Response: Unable to complete the HTTP call due to a communication error with the remote server.…
Easily Get Current Date Using CloudWorks
Almost any model builder has had to come up with a solution to get the current date in Anaplan. We used to build integrations and use API for that. @JaredDolich posted a great article about using python for getting today's date. But this approach has some cons: * You must learn to code or involve someone who can do it.…
Headers in export files
When Exporting files from Anaplan I would like the possibility to remove the list name from the header when adding properties properties in the export file. Today I can only choose Include or exclude Row Label headers. I would like to have the possibility to exclude the name of the list in the header. From above export I…
Integrate NetSuite Consolidated Balance Sheet
I'm trying to set up an integration to get our consolidated balance sheet ending balances from NetSuite into Anaplan. Initially I was able to load transaction data using a saved search, which works for our income statement, but for the balance sheet it doesn't allow me to get the right values for foreign accounts that have…
L1 SYS08 Employee Details module - Import and Mapping Issue
Can anybody please write down the steps for the particular SYS08 - import and correct mapping As after several attempts and struggling to get it right . Appreciate your support guys.
Is it possible to access Amazon Redshift data warehouse via ADO?
Hello, Brain Trust! My organization uses Amazon Redshift data warehouse and some data we need for Anaplan will be stored there in the near future. The current assumption is that we will use Informatica to query, stage, and then import to Anaplan, BUT…. I really was hoping we could use ADO. In a prior life, I used Anaplan…
Anaplan Integration API Error - API path not found
Hi , I am encountering the following error: { "status": { "code": 404, "message": "Not Found" }, "path": "/2/0/workspaces/<workspace ID>/models/<Model ID>/exports", "timestamp": "2025-05-26T16:09:29.716228003Z" } Using CURL: curl -X GET "https://api.anaplan.com/2/0/workspaces/<workspace id>/models/<model id>/exports" ^ -H…
Evolve your Anaplan ecosystem with enterprise governance
In this article, you'll find resources to support evolving your Anaplan ecosystem with enterprise governance. This broad topic was covered in depth during Anaplan Live! 2022 — including focused discussion on Centers of Excellence; model governance; workspace architecture; data hubs and data integration; build and…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Does S/MIME Certificate Renewal Impact Anaplan Connect Functionality?
Hi Community, We are currently using Anaplan Connect to run scheduled batch scripts on a daily basis for data integration. A query came up regarding the renewal of an S/MIME certificate (used primarily for email encryption and signing). I wanted to confirm: 👉 Does the renewal or expiry of an S/MIME certificate have any…
True ALM for Anaplan Data Orchestrator
Currently ADO only has a single tenant level environment to all store source data, transformations, and links. This can make managing ALM challenging. Being able to have separate (and sync-able) ADO Dev/Test/Prod environment(s) would be more manageable than housing everything in a single tenant wide space. Having true ALM…
Make Integration admin role available for visitors & partners
It's currently not possible to assign an integration admin role to visitors and respectively also not to Anaplan Partners. This makes it a challenge when helping customers with Cloudworks or when just setting up a scheduled model-to-model import. It requires always someone at the customer capable to set-up the connections.…
Ability to exclude time dimension from an export
A description of the enhancement requested: When you export a module, in the Labels tab you have the option to remove any labels for a list dimension on rows and therefore effectively remove it from the export. This cannot be done with time and the customer would like it to be. A story for why they want the enhancement…
Restrict Characters in Open Text Line Items
It would be great if text formatted line items that are user inputs could be restricted to only allow certain characters. When users are allowed to input an escape character or newline, it can create problems for exports.
OEG Best Practice: Data Hubs: Purpose and peak performance
You may have heard about a model called a Data Hub, but perhaps you aren’t confident that you understand the fundamentals, primary functions, or considerations when architecting one. There are three main advantages to incorporating a Data Hub: Single source of truth : Stores all transactional data from the source system.…
Inquiry About Connecting SFTP Server to Anaplan Data Orchestrator
Hi Everyone, I am reaching out to inquire about the possibility of connecting an SFTP server to Anaplan Data Orchestrator (ADO).Could you please let me know if such a connection is supported? If so, I would greatly appreciate it if you could provide detailed guidance or documentation on the process involved. Any specific…
Data Related Training Classes
* Anaplan Connect (301) * Anaplan Data Integration Basics (303) * Creating a JAVA keystore for use with Anaplan Connect Overview This set of classes address how data is used and managed within an Anaplan model: Anaplan Connect (301) Anaplan Connect enables the Anaplan administrator to automate Anaplan imports of data and…
Option to export conditional formatting in export to xls
Description of the enhancement: Add an option to include conditional formatting in exports to xls
Save UX Export Definition as An Action
It would be great if we could save/automate dashboard exports from the UX in the same way that we can in the old dashboard experience. Right now, if we want to automate the sending of a dashboard export (a PDF), we need to do it as a saved view of a grid or build an old UX dashboard to export from. Right now, if I export a…
Quick 5 minute Test : ADO Navigation - Share your insights !!
We are looking to capture your feedback on the new navigation system compared to the old one. With a quick 5 minutes un-moderated navigation test. You don't have to currently use ADO to participate — if you have experience with ETL Tools, Data Warehouse Tools, or similar systems, we’d love to hear from you! We currently…
CloudWorks Integration with BigQuery: Understanding the Error Message Table
Hi Team, In the official documentation under "Google BigQuery Permissions" I found details about creating an optional error message table with the following structure: integration_id run_id run_date error_code error_message failed_row While the documentation outlines the table structure, it lacks details on how records are…
Anaplan Connect Install 1.4.4
I am installing Anaplan Connect for the first time. When I try to run the import script, I get the below error message. I do have the WorkspaceID in there. I also want to runt the script on a shared drive in Unix if possible. Can anyone help? Thank you. ======================================================================…
Error anaplan connect
Hi team, I have problem with anaplan connect 1.4, sometimes i get error 2020-07-13 09:21:25 INFO 88 |-- Initializing Service... 2020-07-13 09:21:25 INFO 88 |-- Authenticating via Basic... 2020-07-13 09:21:47 INFO 88 |-- Retrying API request: Attempt (1) 2020-07-13 09:21:50 INFO 88 |-- Retrying API request: Attempt (2)…
Model Migration from Anaplan Cloud workspace to Google Cloud workspace
Hi Anaplan, Does anyone know if it is possible to migrate a model from the Anaplan Cloud to the Google Cloud and vice versa? If a model has been constructed in a customer's Anaplan Cloud workspace can it still be migrated to a different customer's Google Cloud workspace using a Model ID and Workspace ID? Any information…
Streamlined Workflow Migration for Environment Transitions
I suggest enhancing the product feature to streamline the migration of workflows from the Dev Model to the UAT and Production environments. Currently, the process requires manually duplicating existing workflows and updating each task—such as the source workspace, source model, import actions, and ADO links—to reflect the…
Data integration and scalability: A framework for model assessment and optimization
Author: Avnish Goel is a Certified Master Anaplanner and Founder at ScriptStory. Recently, I led a model assessment initiative to identify suboptimal design elements in the data architecture for a leading investment banking firm. The project involved analyzing source systems and Anaplan models, leveraging both Anaplan best…
4.6.7
I used the mapping column 3 family code to P2 product family column headers to parent column 1 product code to code I get the error another row has already been processed with this key and invalid name 53 failed

Data Integration

Discussion List