Data Integration

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…
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…
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
Export Formats
Hi, Just wanted to know that while exporting from the New UX is there any way in which the pdf export format be obtained as an A3 page. Currently the export is landscape oriented by default so is there any way out that this can be changed. Thanks in advance!
Level 2: Sprint 2: Error while running the 9 Import data from HUB for Importing Import Opening Stock
I may not be clear because I'm using a translation tool to convert Japanese to English. I'm in a lot of trouble and need your help. The problematic area: level 2 sprint 2.3.9.2 When I try to execute Process 9. Import Data from the Hub according to the instructions, I get an error as shown in the third image. Please tell me…
Bulk copy
Can you set up a bulk copy between models? I have two models. One is a stand alone Financial Forecast with numbers adjusted in various modules and saved views. The version in that model is named the working forecast. The other model is our main Financial Forecast and I have created a version specifically for the data to be…
Anaplan & MS Access Transactional API using Python
Hi, I'm trying to update the data in Anaplan module line items directly from MS Access by converting into json format using Python transactional APIs. I'm keep getting the "Status code 400" , "Message - Post body is not a valid json". I have tried by printing the json format before sending the data into Anaplan and format…
Model Integration details
Hi Anaplanners, I would like to know what are the different ways to fetch information about the integrations (versions, type of integration etc) that are present in my model? Are there any direct API calls using postman or I can find this information somewhere in the model itself? Regards
Adjusting CloudWorks Integration Schedules for Daylight Saving Time (DST) Using Postman
Intended Audience Level of Difficulty: Intermediate Requires familiarity with APIs and Postman Resources Required: Internal Expertise: IT Developer / API User Tools Needed: Postman, CloudWorks Access Requirements: CloudWorks, Postman, Anaplan Integration Admin Estimated Level of Effort (LoE): Low Approximately 1-2 hours…
Adjusting CloudWorks Integration Schedules for Daylight Saving Time (DST) Using Python
Intended Audience Level of Difficulty: Intermediate Requires familiarity with APIs and python scripting Resources Required: Internal Expertise: Python Developer / API Expert Tools Needed: Python, CloudWorks, Code Editor Access Requirements: CloudWorks, Anaplan Integration Admin Estimated Level of Effort (LoE): Low A few…
Connecting Anaplan Connect to Snowflake Using JDBC Driver with Java 16 or Higher
Addressing JDBC Driver Compatibility Issues Intended Audience Level of Difficulty: Intermediate Requires some familiarity with APIs, scripting, or database concepts Resources Required: Internal Expertise: Data Engineer/IT Admin/Integration Admin Tools Needed: Anaplan Connect, Snowflake, Notepad Editor Access Requirements:…

Upcoming Events

Anaplan Community Power Hour: COE Building in your Organization
Anaplan Community Power Hour is a live, interactive event hosted by the Anaplan Community, designed to bring together model builders, business leaders, and planning professionals for focused discussions on high-impact topics. In this session, we’ll explore best practices for building a successful Center of Excellence (CoE)…

Data Integration

Discussion List