Data Integration

Data Export Options in Anaplan Data Orchestrator ?
Hi Anaplan Community, I'm new to Anaplan and exploring integration options for moving data between Anaplan and cloud services. I successfully exported model data to Google Cloud BigQuery using the CloudWorks integration. However, I couldn't find an option within Anaplan Data Orchestrator (ADO) to directly link model data…
Integration via Amazon S3
Hi, I created a connection via Amazon S3 without any problem, the status is "Connected", but I don't manage to select a file when I try to create the integration : Thank you in advance for your help. Best Regards Alex
Which of the conditions require the use of a numbered list
This seems to be a tricked question, I can not figured how this is not correct [Image Removed by Moderator] This is the reference from Planual: [Image removed by Moderator]
Error in key for this row; refers to invalid list item
Hi everyone, " Error in key for this row; refers to invalid list item : Headcount " I get the above error when I tried to import data into Numbered List, which is uniquely identified by combination of properties. Actually, the list item which is formatted by some "xyz" list has list item ' Headcount' Even after that, I am…
JSON as Import File Format
With the JSON format being the pervasive format for API data interchange it would be excellent if Data Import actions could use this format of file as a data source.
Does having multiple models in a single workspace (standard or hypermodel) affects performance?
Hi All, I have a query where currently we have 3 models in 3 different workspaces(standard). In all the 3 models we have intergrations running at different times(5-6 times a day for each model) to update Actuals/Forecast from other sources. We are looking into getting a hypermodel workspace for future enhancements &…
Enhancement to existing Bulk API for Import Metadata
There is an existing bulk API endpoint that allows workspace admins to retrieve the full list of Import actions from a given model. This endpoint is in the format: https://api.anaplan.com/2/0/models/{{mdlID}}/imports/ where {{mdlID}} is the model GUID. This returns a JSON response, which contains an object called "imports"…
Issue: Informatica Cloud Connection to Anaplan Success but 0 rows processed.
Hi Anaplanners, I am trying to use IICS to establish a connection between my oracle db to Anaplan module. But everytime I test my IICS process, it's giving me a success status but showing 0 rows processed, and when I check the module, nothing was imported in. I also tested my action manually and it worked fine. I also…
Import Shipping Expenses into OTH01 Module
Import Shipping Expenses into OTH01 Module In the Financial Planning & Analysis model: Import the data from the Supply Chain model into the OTH01 Non Employee Expenses module, Shipping Cost line item. * For department, import into the Sales department. * Run the import. * Results should have none ignored and 0 errors .…
Level 3 Sprint 1 Import
Its regarding Level 3: Sprint 1 : User Story says " Import the Financial Forecast data from the Level 1 FP&A model" I have used the "Baseline+Financial+Forecast.csv" file. I am struggling with the import mapping "Time" and "Baseline Financial Forecast" portion. I keep getting failed errors regarding date format…
Stale Module Data in Power BI
I've successfully built out a Power BI semantic model that appears to connect to Anaplan just fine. When I created the model, I logged into the Anaplan Connector using my company SSO. Once the credentials were validated, I selected the Export Action that I had previously created and loaded the data. Initially, all data…
ADO Access
Hi Everyone, Can anyone will help me how can i get the access for Anaplan Data Orchestrator(ADO). Regards Rakesh ****
Ability to mask or sanitize all of the Production Data within a model
I would like to be able to easily mask all Production Data within a model. Currently, this involves a lot of manual effort. For example, replacing all names with fake names, and all numbers with fake numbers. Being able to do this is useful for a couple of different purposes: * If I need to have Anaplan Support take a copy…
Use Microsoft EntraID for Azure Blobs
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: Use Microsoft EntraID to connect to Anaplan and use this EntraID to connect to an Azure Blob, instead of using a SAS token. Our…
BULK COPY - How to choose the SOURCE member and the TARGET member from a page in the app?
Hello Anaplan Community! Does anyone know how to choose the SOURCE member and the TARGET member from a page in the app? Thanks in advance. #NewFeature #UX #Dashboards #BulkCopy #Data #AnaplanRelease
How to integrate Azure blob and Anaplan For transferring files
Is there way to connect azure blob and Anaplan to upload/import data can it done by rest api call or can i use custom script to call Anaplan connect import hub from azure??
Anaplan to SAP journal posting
Hi All, I am working on automating journals from Anaplan into SAP via SAP BTP/API. The API is linking to saved exports with a saved view. Journal data updates on a monthly basis but the changes in data don't get picked up by the API and instead old data gets posted into SAP. Has anyone encountered this before? Is there…
August 2021 Release and Sneak Peek at September
August 2021 Release and Sneak Peek at September Bulk Open from Table of Contents: From the Table of Contents section of New Modelling Experience (NMX) you can quickly open the objects of a particular functional area for faster access to the information that you may need. It leads to increase in productivity. Tab…
How to Automate and Retrieve Authorization Code in Anaplan OAuth API Automation using Python
Hi, I'm facing an issue with the Anaplan API integration. Currently, the authorization code retrieved manually, but we are looking for a way to automate this process as part of our integration workflow. Thanks
Workflow builder - Include or Exclude emails
Workflow Builder Enhancement It would be fantastic if you could toggle the option to include or exclude emails generated from Anaplan from the Workflow builder. I have a two step machine task process in workflow that is published to the UX. The process steps are to run an action in the workforce planning model to prepare…
Data Source or Target issue
Hi everyone, I am wondering if anyone else has encountered an issue with Data Source or Target not working correctly in CloudWorks. For some reason, the Data Source or Target list is diminished for all administrators/integrators in the Workspace. As you can see on the screenshot below, there's a list of few items and then…
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 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…
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…
[Start Here] Anaplan Connect 2.0 and JDBC Connectivity
* What is Anaplan Connect? * What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Deep Dive on Integration * Integrating with SAP HANA Cloud * Integrating with Snowflake * Integrating with Azure SQL Database * Integrating with Google Cloud (GCP) BigQuery * Integrating…
Ability to Add Data Write Action to Existing Process
1. It would be really a game changer if we are able to add Data Write Actions to the existing processes, It would not only scale up the usage of the Data Write Action but also would save a lot of time and effort and would save us from creating multiple saved views and actions. 2. Currently, Data Write actions can only…
2.3.8.2 Import into DEM01 Module All Products Growth rate
Hi, I am having problem getting the total of all products for each month and I have no idea why it is not populated. Can anyone please help on finding out why it is not populating?
Log exports in the model history
Description of the enhancement required: Customer wants to capture the export information also to be captured in the history log. Currently, only import information is available. A story for why you want the enhancement: For the customer, apart from imports that are scheduled , if a user clicks on export they want that…
Anaplan Connect - Running the proccess/imports
Hi All, I need your help regarding process or imports in anaplan connect. In the import or process when any of mapping is selected as ' ask everytime while import'. How can we complete that process or import successfully using Anaplan connect
Anaplan Connect cannot connect to database
Hi, We recently set up a new database to export data from Anaplan to Azure. The database is a SQL database on Azure VM. I am trying to set up connection. Export out of Anaplan is always successfull, but keeps failing when connecting to the database. Jdbc connection string: Anaplan connect is also running on a VM.…

Data Integration

Discussion List