Data Integration

Is Anaplan Async or Sync? Export task status
I am connecting to Anaplan API from AWS using Python. I am able to connect, run export etc. https://private-anon-9863bbf5c2-anaplan.apiary-mock.com/1/3/workspaces/workspaceID/models/modelID/processes/processId/tasks/taskId. I am getting the status of task as IN PROGRESS but expeting COMPLETE. I need some help putting how…
Anaplan Integration with Data Lake
Hi Team, I am looking on implementing a possible solution of Anaplan sending data to a Data lake and In bound from a different set of a data lake. This will give me more flexibility to send my plan figures to enterprise systems. Do we have any proved architecture on this or will Informatica connect will be able to help us…
Issue in mapping creation in dell Boomi tool using Anaplan action
Hello Team Can anyone help me to understand the Dell Boomi integration with Anaplan. I am trying to integrate Oracle Databse to Anaplan using Dell Boomi. When i try to create Mappings in Dell boomi from Database to anaplan by using MAP . I am able to retrive columns from Databse but when i try to select anaplan action in…
Ana-plan Connect to SQL Server
Hi Team, Am trying to create a connection between Anaplan to SQL server to import the as list from MS Sql table to Anaplan. Please find the below script i am using. @echo off set AnaplanUser= roshin.rasheed@xxxx.com:password set WorkspaceId= 123434343 set ModelID= sdsfsdsdsdsds set Operation= -file "Source System from…
Import a Saved View with a page as a dimension into a List
Hi, I have this saved view in my Vault Line Master details module. The dimension being used is a page of the vault line. I want to import this view here with one single vault into a Vault Line Master Archive list pictured below, with just importing the display name into the list is all. The single vault in this view is a…
Multiple outputs from 1 Anaplan Connect Script or 1 Process
Hi, I want to be able to export 6 views of the same module to external file (xls). I have saved the 6 views and i have exported and saved the processes. I would like to have 1 script to run the 6 outputs, but if i use a script with all six, it only runs the final process. I did try creating one process with the 6 actions,…
import task id
Hi Everyone, Is there any way that I can see the import task ID in anplan? Please share your thoughts
Module to module import
Hi Guys I am trying to import data from data hub module structured with just line items (no dimensions) into A module in spoke model also structured as just line items ( no dimensions) and it just doesnt work . The value field doesnt come up source module time(line item) date formated target module time(line item) date…
INvalid Date - Import Model to Model
Hi, Please see the details of my inquiry in the attachment Regards,
Invalida Date - Import from one model to another
Hi, Please see the details of my inquiry in the attachment Regards,
Anaplan Connect 1.3.3.5 - multiple files import
Good evening, I have 4 files that need to be imported in anaplan, that have the exact same columns name and that will hence use the same action. Is it possible to write a single script by 'cumulating' the actions and having something like : set Operation=-file "file1.csv" -put "data/ImportModule.csv" -import "New Hire from…
Allow SSO Users to run cross Workspaces Imports with Anaplan Connect
Hello, It would be useful to allow accounts with Single Sign On activated to run Cross Workspaces Imports via Anaplan Connect. At the moment, only Exception Users (no SSO) can run these Imports, which is not in line with recommendations from our Internal Audit team. Thank you
It would be helpful to have an “aggregation operator” property that would apply to a hierarchy.
For example, consider the following hierarchy, applied to a module, with the following values: Net Income: $10 Gross Margin: $40 Sales: $100 Cost of Sales: $60 Operating Expense: $30 Clients would prefer to see Cost of Sales as a positive number. In aggregating, they would want to see Cost of Sales subtracted from Sales to…
Ad-Hoc Integration Using Flask Microservice
There are several cases in which it would be beneficial to allow users to trigger integration jobs, ad hoc, from within the Anaplan platform, but there is no native feature that allows this. Previously, I described a solution that simulates this functionality using only Anaplan Connect. This article presents a solution…
Data Hub Connection to multiple output models
Hi Everyone, We set up a Data Hub and would like to use it for multiple models, because there are lots common lists that we can use for various models. When we build connections among Data Hub model and other output models, we can set up actions in output models, by importing connecting "Data Hub" model's lists, to push…
How to sum a column by looking up a dimension in the module
Hi, I have this module that has a dimension list called Sales Title and a list called Quota Types. I have a line item called SSA Revenue, and it is 1 if it has SSA Revenue, else 0. I have a second line item and I want to sum the total number, grouped by Sales Title. Picture attached. Would I be able to get some help…
Intégration with consolidation tool to obtain consolidated budget
Intégration with consolidation tool to obtain consolidated budget
Import raw data of transaction
Dear gurus I'd like to import raw data of accounting transaction data from ERP. I created module "Accounting Raw data". In this case, we need to define unique key in module such as Document No, so I created new list "Sequence No" as numberd list. In this case, I have to import Document No to Sequence No list first, then…
Exporting data with a standard interface to SAP ERP
Is there a standard ETL to transfer data from Anaplan to SAP ERP? Several prospects in our country asked to manage budegting process in a dedicated application (as Anaplan) but transfer data to SAP in order to follow Budegt vs Actual?
Multiple Import Files
Is there a way to combine the multiple select files within an action when imports share a file i.e. updating a list then a module with the same .csv, without deleting and recreating the imports?
Mulesoft API Certificate Authentication
Hi, Does anyone know whether Mulesoft API can support Certificate Authentication? How to do it? I am referring to http://docs.anaplan.apiary.io/#
Anaplan Mulesoft Integration
The current Mulesoft does not support Anaplan connectors. Any advise on what to do regarding this? And how to find import id on Anaplan. Kindly provide your valuble input into this. Should I use backdated connectors/api ? -Thanks
Enable creation of new Version for model in deployed status when using ALM
Provide possibility to create and remove new Version when using ALM in the models that are in Deployed mode. For the enterprise organizations with strict sagregation of duties, it is neccesarry to have possibility to do as described, either manually or using Anaplan Connect API to create/remove versions on scheduler and…
How to Export a Dashboard to PDF?
I created a dashboard in one of the models I am developing. I want to export that dashboard out as PDF. I found this https://help.anaplan.com/anapedia/Content/Dashboards_and_Visualization/Work_with_Data_on_Dashboards/Print%20a%20Dashboard.html on anapedia, it says * Open the dashboard to be printed. * Click Export on the…
How different is 303 from 302
Hi Team We would like to know if 302 is different from 303, only difference we see is getting certified. Kindly clarify Kavin
PowerPoint Add-In and Conditional Formatting
When establishing a connection to a saved view in Anaplan that contains conditional formatting, Is it possible for the PowerPoint add-in to pick-up the conditional formatting as well? If so, can anyone please provide guidance?
Anaplan Integrations should work to edit model cells in addition to bulk upload.
Anaplan ETL connectors provide bulk upload capabilities. There should be capbilities for the customers to edit model cells in addition to bulk upload.
New workflow dashboards: auto-refresh when launching actions
In a standard dashboard data within are automatically refresh when a process/action is run. If you are loading data from a txt or from another module the user see that data are changing at the end of the action. With the new workflow this is not happening and, from an user stanpoint, this generate confusion and the need to…
Provide the workspace and model data available for querying in Bigquery
We have our data in Anaplan workspaces and models but our power users like to query the data. Would it be possible to make our workspace data available to query in bigquery ?
creating transactional store of plan data
I have various modules which use numbered lists as children of cost centres. Users add items to these numbered lists to capture planned costs for different activities over time. To export data to our reporting tool I've created a module which collects the values dimensioned by cost centre, gl and time. It is…

Upcoming Events

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 March as we expand on the insights shared in the previous session and explore how Workflow continues to evolve to support planning collaboration and process efficiency.…
Community Challenge Recap: Annual rollover best practices
In this ACE Spotlight event, we will cover the most effective techniques for making your annual rollovers seamless and repeatable, based on the solutions from our latest Community Q&A Challenge.

Data Integration

Discussion List