Data Integration

Excel Add-in login Issue
Hello All, Our users are having SSO access to Anaplan, but we are getting a non-sso login page while log-in into the Excel-add-in. We already tried to uninstall/install the package a few times and we follow the same installation procedure for all the users. Only 3 users are facing this problem and they were able to log in…
API not showing all the workspaces
the login which is under https://api.anaplan.com this link are working properly and showing all workspaces but when i try to login in https://us1a.app.anaplan.com/ this link ,its not showing workspaces and even authentication failed. Mean API not getting values when it is diff. link which uses Single Sign on also
Anaplan Connect Quick Start Guide - Windows Installation
This Anaplan Connect Quick Start guide is specifically for the Microsoft Windows platform. Its purpose is to help you swiftly set up and get started with Anaplan Connect. Please follow the steps below to guide you through the installation process. If you are utilizing macOS, kindly refer to the Anaplan Connect Quickstart…
Optimizer: process incl. optimizer action with import on timeout should continue in case of timeout
For optimizer actions, there is the possibility in the action setup to enable "Import on timeout" to fetch back the results from Gurobi processing when the specified timeout is reached but the desired MIPGap is not achieved yet. If the optimizer action is embedded within a process, the process is shown as failed when this…
level2 - Create Inventory Ordering Saved View and Export- export setting
I am trying to do this activity: This is my export view: I used Tabular multiple column export, and got this result: which is differ from expected one: Which export setting needs? Regards Roya
Simplifying User Access Management in Anaplan with the SCIM API
Introduction: In today's fast-paced business environment, effective identity management and governance play a crucial role in maintaining data security and ensuring smooth operations. Anaplan, a leading cloud-based planning platform, offers a powerful SCIM (System for Cross-domain Identity Management) API that integrates…
How to Import Data from one drive into Anaplan Using Power Automate
Hi Community, We are trying to import the CSV file from one drive to Anaplan using the power automate custom connector. But we are having a challenge importing the data into Anaplan, it is not coming as expected in tabular format. Any thoughts and solutions on this one? @JaredDolich Thanks & Regards Badam Anjani Prasad
Anaplan Certificate obtained from Sectigo - Private Key issue
I recently helped a client obtain a certificate for use with Anaplan Connect from Sectigo, using the document below. https://community.anaplan.com/t5/Releases/How-to-Use-Third-Party-Certificates-With-Anaplan/ba-p/49116 The public key that Sectigo send as per the guide works when installing it in Anaplan tenant admin. The…
Anaplan Connect Quick Start Guide - Linux & macOS Installation
This Anaplan Connect Quick Start guide is specifically for the macOS and Linux platforms. Its purpose is to help you swiftly set up and get started with Anaplan Connect on these operating systems. Please follow the steps below to guide you through the installation process. If you are utilizing macOS, kindly refer to the…
How to import data into anaplan using power automate by custom connector?
I have worked with custom connectors and created the action that is to be used to create flow and I got stuck in uploading the file and the data is not reflected in Anaplan. Need to figure out the CSV file reading and loading the CSV file through API
Moving Production Model to new workspace
We currently have ALM set up between our DEV -> QA and DEV -> PROD models in our workspace. We have 1 DEV and 2 PROD with the same DEV model. So now the Production workspace is almost full, so we are planning to move one of the PROD model into a new workspace. Please confirm if we will still be able to sync any changes…
7.2.3 Activity: Import Data into Employee Details Module
Hi everyone, I'm a newbie to Anaplan. I have checked and tried every suggestion in this forum regarding this problem. Kindly help me out. Attached are the screenshots of everything I have done. Any suggestion would be appreciated. Currently stuck. Thanks
Run Process 9 Import Data from the Hub
Hi Team, While I'm Running the process I'm getting error. Please help me to run the process sucessfuly.
Better Formula Editor for Anaplan; A new Chrome/Firefox/Edge Extension
Hello all! I have made a Google Chrome and Firefox extension that enhances Anaplan formula editing by using the Monaco editor. This is the editor used by Anaplan's new modelling experience. My extension works with this new experience adding enhancements over and above what Anaplan have done. It also works with the…
8.5.2 Activity: Import Data into Price Book Module issue?
Hi everybody. I import the Pricebook.csv file to REV01 Price Book module. Everything seems in order until the importing process is completed. As you see on the screenshots after importing the file the prices don't represent the correct value as in the .csv file. Where have I done wrong?
SYS08 SKU Details Missing Data
I am reviewing a specific module in the Lvl 2 Supply Chain Model and noticed the "distribution center" column in SYS08 SKU Details isn't populating. I have the format set correctly - list: s G3 Location: Distribution center. The data is just not showing up. Is there something I am missing?
7.2.1 Activity: Import Data into Product Details Module - Invalid line item identifier
Hi, For L1 Model Building activity 7.2.1, I am having some issues importing the data file for SYS06 Product Details module. I am getting the following error "Invalid line item identifier" when importing the file Below my mapping selection Doe Does anybody know what the issue might be? Thank you
L1MB - 7.2.1 Activity
It seems that there is "Product" data but I cannot see data in Column SIZE. It is not allowing me to import it again. Any suggestions?
[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…
Level 3 Sprint 2 Employee Details into G3 Sales Reps
Hey Team, I have encountered some issue(s) with importing the datahub saved view employee details module into the G3 Sales Rep list in the Sales planning model. After a completing the import, the results (per the attachment) are not the employee names but numbers. Could you advise on how best to quell this issue and…
Cloudworks succeeds but doesn't actually run
Hi all, I've noticed for a CloudWorks process I have that the actual integration says "success", but when I check the model, the last run time of the process was not updated, nor was any new data added to the model. This is an integration from BigQuery that worked previously, and is now not actually pulling new data. Has…
Integration data between Anaplan and SFTP file
Do you know about integration data between SFTP (Filezila) to Anaplan? I want to import data from SFTP file to Anaplan.
How to import Negative Values from txt files
Hi All, I am importing data from tab separated txt files and I noticed wherever the values are negative, its populating as positive numbers in Anaplan. As shown in above example the negative values are denoted by a negative sign after the number in the txt file. Is this format supported by Anaplan? Thanks in advance
Trigger mail to end user
Hi All, Greetings! I have a request from one of the user if I can trigger an export of dashboard to email ID at a particular time slot. I am assuming this can be achieved through integration only. But I would be glad to know if there are other ways to achieve it. Thank you, Harshitha N.
Anaplan Connect with Snowflake & Public/Private Key
I am attempting to utilize Anaplan Connect to move data from Snowflake into Anaplan. In order to work with our snowflake setup, I need to use a public/private key pairing as opposed to a snowflake username/password. I have been told the most recent version of connect (3.0.0) does not work without these fields and that an…
DCA and Internal (Full Access) user Issue
Hi Anaplaners, I have a scheduled job run by an integration [Internal (Full Access)], in the target module some data/values (text or numbers format) are imported correctly however, in some line items with DCA the values imported are zero and this is not the value in the source module. Internal (Full Access) has WRITE…
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…
Text formatting within email's body
I am building email template for MAILTO formula. Is it possible to format the text (make bold, italic, colored) and create paragraphs in the emails' body? Maybe implement html tags?
How can we automate data imports from IBM sterling on premise server to Anaplan
Hi Team, Please help me in understanding how can we import data from IBM sterliling on premise server to Anaplan and automate it.

Upcoming Events

Anaplan Academy Open Office Hours [AMER]
Join us for Anaplan Academy Open Office Hours, an open, interactive space designed to support your learning journey. Whether you’re just getting started with Anaplan training, working through course content, or preparing for certification exams, this session is your chance to get direct answers to your questions. Our…
Anaplan Academy Open Office Hours
Join us for Anaplan Academy Open Office Hours, an open, interactive space designed to support your learning journey. Whether you’re just getting started with Anaplan training, working through course content, or preparing for certification exams, this session is your chance to get direct answers to your questions. Our…
Save the Date: Anaplan Workflow - Next Steps in 2026
We’re continuing the conversation! Following the success of our first Anaplan Workflow event, we’re bringing you a deeper look at what’s next. Join us in February as we expand on the insights shared in the previous session and explore how Workflow continues to evolve to support planning collaboration and process…

Data Integration

Discussion List