Data Integration

CloudWorks Integration with BigQuery: Understanding the Error Message Table
Hi Team, In the official documentation under "Google BigQuery Permissions" https://help.anaplan.com/set-your-google-bigquery-permissions-5bb8f011-3fad-452a-8765-b5a7b52405a7 I found details about creating an optional error message table with the following structure: integration_id run_id run_date error_code error_message…
Netsuite & Successfactors integration
Hi, Does anybody have experience of integrating Netsuite & Successfactors with Anaplan. Would be keen to understand the best practices. Regards Sanjeev
Export Model Map to PDF/Excel
Capability to Export Model Map from Contents page to PDF/Excel.
Cloudworks Integration run vs Schedule
Now using the cloudworks integrations and have come across an annoying situation. Once I set a schedule for an integration the option to run it now disappears. Only way I can find to run it now is to cancel the schedule (deactivating not sufficient) and then rebuild the schedule after I have run it and made any changes.…
7.2.3 Activity: Import Data into Employee Details Module
When importing data into the SYS08 Employee Details module, my end results looks like the second photo when the goal is the first. I have imputed the correct mapping, and manually mapped the employee detail line items as well as changed the date format to YYYYMMDD. I'm not sure what the error is, I keep getting the error…
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…
Anaplan connector 3.1.0 for Mule 4 Integration
I am getting below when we use load data Anaplan component for model and workspace. Can some one help on this? details" : [ { "localMessageText" : "Import into FDL001 Data Hub - Casework module failed: The dimensions in the target module do not match the import definition.", "occurrences" : 0, "type" :…
How to maintain complex Anaplan environments — Part 2: Technical foundations for scale
Author: Piotr Weremczuk is a Certified Master Anaplanner and FinSys Application Specialist at EQT. In the first part of this two-part article, I explored the non-technical foundations of maintaining complex Anaplan environments: leadership, governance, accountability, and the importance of building the right team. All of…
Reset index of Anaplan List using API
Hi, I want to reset the index of a list using API, not sure how to go about it. I am very new to APIs, I went through Anaplan API docs, however, if someone can help me with the step by step process, or any resources it will be very much appreciated. Thanks
Cloudworks Status "Auto_Deactivated"
Have noticed that in the last couple of days a couple of Cloudworks integrations have got a status of "Auto_Deactivated". Couldn't find anything in Anapedia and wondered if anyone knew what this was about? Seems to be something about the schedule as deleted the existing one, added it back and is now running fine but is…
Provide a Native Anaplan Connector for Microsoft Power Automate
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Anaplan currently does not provide a native connector for Microsoft Power Automate.In our enterprise environment, this is a critical…
Data Hub: Will multiple imports and loads at the same time slow it down or lock it?
If two spoke models pull data from the same Data Hub at the same time, will it slow down the Data Hub or cause any locking? Also, if the Data Hub is being loaded/updated with a different set of data while it’s sending data to two spoke models, will that slow down the Data Hub or cause any locking/issues?
Current page filters and sorts are applied to all pages of multi-page exports
This item has been identified as an outstanding known issue. Issue Setting a current page filter or sort and then exporting this data to file, will apply the current page filter/sort to all pages of the data. Workaround Remove all filters/sorts, export the data, and apply the filters/sorts in Excel --- Internal Reference:…
model building activity 6 add formulas to REP04 module line items
hello. is there anybody, who can help with the LEVEL 1 Model Building Exam? I do not know what formulas to write in the model building activity 6
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…
ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
Getting data integration right: Best practices for building robust, scalable connections
Author: Dmitri Tverdomed is a Data Architect and Director at Zooss Consulting. Data integration isn’t just a technical exercise anymore — it’s foundational to a business’ ability to move quickly, make informed decisions, and scale sustainably. Whether you’re integrating Anaplan with upstream data platforms or pushing model…
Do scheduled CloudWorks actions run in parallel or sequentially?
If we schedule two CloudWorks actions to start at the same time, using the same source model but different saved views, and updates two different target models, will they run in parallel or sequentially (with one finishing before the other starts)?
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
8.5.3 Activity: Import Data into Volume Inputs Module
Hi everyone, I'm getting this error message and I don't know what I'm doing wrong.
Can Anaplan ADO (Source Data step)append all similar files in a folder and auto-include new ones?
There is a client requirement to load multiple structurally similar files (the system generates new files) from the source data. Is it possible for the ADO "source Data " step to read multiple files from a folder path (instead of a single CSV file), append all these files, and then pass the combined data to the ADO an then…
I am struggling with my mapping and import of E2 Employee List
Hello Model Builders! I need your help in Model Building. I have tried over 10 times to import data into E2 Employees# under Lesson 4.8.2. I have spoken to some colleagues on my team and the we were unable to resolve this issue. If anyone could assist please share a solution or trick to this. I noticed other colleagues had…
4.6.6 Activity: Import Data into P1 Product Family List Unable to import data from product families
I am trying to upload the product family data into my model in lesson 4, and each time I try I get a notification saying "Multiple files inside an upload package are not currently supported." I was wondering if anyone knew how to troubleshoot this problem.
CloudWorks Job Dependency Timing
If I schedule two CloudWorks jobs, one that loads data into Module A from different Model and a second that runs the actions to move that data into Module B from Module A, will the second job wait until the first job finishes before starting, or will it start at its scheduled time even if the first job is still running.
ADO - On Premise MSSQL Server Connector
I’m trying to understand how Anaplan Data Orchestrator (ADO) connects to an on-premises SQL Server. In Anapedia, I found this: An MSSQL instance hosted on a cloud platform, such as Amazon Web Services (AWS), Azure, Google Cloud Platform (GCP), or any other cloud provider. The solution is compatible with on-premises SQL…
Docusign Integration
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…
API certificats renewal
Hello Anaplan Community, We are currently facing an issue related to certificate validation and would appreciate your help or guidance. We are getting the following error: Unable to build certificate chain for Cert [subject DN = EMAILADDRESS=********, CN=service account email address, cert serial number = XXXXX; issuer DN…
API Call for Imports and Import Data Sources Metadata
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: It would be helpful to be able to pull the information from the Imports and Import Data Sources tabs within actions via API. It would…
Cloudworks Integration Flows in UX
At the moment, we are able to add Cloudworks Processes to the dashboards and the addition is great. Could we do the same with the Integration Flows? I see multiple benefits from this for several customers and I do not think that the implementation would be too different from what is currently in there. Is this currently in…
Microsoft Teams - Anaplan Integration
A number of customers have expressed a desire to have an Anaplan - Microsoft Teams integration in the same way as now exists between Anaplan and Slack. * Push links to pages to users' Teams accounts * Anaplan notifications * Subset of above: as Anaplan Process Orchestration progresses the need / benefit from Teams link…

Upcoming Events

Quarterly Platform Release Webinar
Join us for our Quarterly Platform Release webinar where we highlight the latest enhancements and updates to the Anaplan platform. In this session, members of the Anaplan team will walk through key capabilities released this quarter, explain how they support better planning and modeling experiences, and share guidance on…
CoModeler for Clear, Correct, Continuously Improved Models
This session focuses on making the model building process more efficient, structured, and less reactive. It covers how to turn business requests into clear updates faster, improve visibility into model structure and documentation, catch issues earlier, and make changes to live models with more confidence. Designed for…
Community Challenge Recap: Polaris Modeling and Optimization
In this Community recap event, we will cover the most effective techniques for module rebuilding and optimization with the Polaris calculation engine, based on the top solutions from our participants in the latest Polaris Community Challenge.
Analyst Agents for Clear, Contextual, Connected Insights
This session focuses on simplifying how users get insights from their data by reducing reliance on manual reporting and back-and-forth analysis. It covers how Analyst Agents can be used to quickly surface contextual answers, connect insights across models, and streamline how questions are asked and answered. Designed for…
ACE: Anaplan Workflow
Registration and events details will release closer to the event date. Join us for the third session in our Workflow Expanded series as part of the Anaplan Community Experience program. This session continues our exploration of Workflow best practices and builds on the lessons from the earlier events in the series. We will…

Data Integration

Discussion List