Data Integration

Automating Cloud to Predictive Insights Integration
Introduction The following document describes the steps needed to automate integration between cloud data sources and Predictive Insights using CloudWorks. In the document, we will use Amazon S3 integration as an example, but other cloud data sources are also supported. For simplicity, account data will be referred to, but…
Managing Anaplan ALM with API using Postman Tool
Hello Team, While am trying to retrieve syncable revision tag from the source model, am facing issue of whose screenshot i have attached below, Reference : I have cross verified the ALM between source and target and also i have verified the Model whether its defined correctly in the environment variable and also checked…
Controlling ALM using Anaplan Connect
Hello Team, Is there any batch script/Anaplan Connect script where we can automate the revision Tag Sync of Datahub with Multiple Production Models ?
Is there a way to integrate mailto function?
Hi, I would like to integrate MAILTO function so that it automatically sends email to dynamic users based on selections done at the backend. Thanks
2.3.8.2 Import into DEM01 Module
Hi everyone, I am trying to do the import into de DEM01 Module, but I keep getting this error. I've seen some similar questions here at the Community but can't really figure it out what everybody did to correct it. I am attaching some screenshots so you can see what I am doing. I really don't know what else I can do. Any…
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…
[Part 2] Script example: Leveraging the SCIM API to bulk remove users
* Prerequisites * Getting started * High level process * Recommended usage * Script walkthrough * Section 1: Libraries * Section 2: Logging configuration * Section 3: SCIM API configuration * Section 4: Authentication * Section 5: Parse CSV file containing Users * Section 6: Call the SCIM to perform the selected operations…
Anaplan Add-On for Google Sheets Not Working
The Add-On for Google Sheets will not open and allow us to connect from large workbooks. It only seems to work with smaller/single sheets. Has anyone else experienced this? Is this a limitation of the add-on?
Where is the data coming from?
There is an error in the data in the spoke so I looked and the the spoke indicates that the mapping came from this module in the Data Hub. However, the data isn't flowing through in the Data Hub but is coming through in the Spoke. Is there anywhere else I can look? I've tried pivoting the view but no data pulls through at…
Bulk API Integration
Hi All, If I upload a file to Anaplan server using Bulk API, can a user manually run the import action from actions page in Anaplan to import the uploaded file into the Anaplan Model, are there any limitations or pre-requisite? For example I understand if I am uploading the file using basic authentication with a user ID…
RESTful API - Postman examples
I have attached a json file for to be imported into the POSTMAN application. These are example calls to Anaplan's API. Please note that most of the API calls were using certificates. The URL to get POSTMAN is here: https://www.getpostman.com/
Building a Chat Bot - Part 3: Interacting with Anaplan from Slack
Since you’ve reached this point, I believe it is useful to remind you what we achieved so far. In both Part 1 for AWS and Part 1 for GCP, we used both platforms in order to host a function that can generate a new token every time that you need one. This could be very helpful in any integration scenario that you can come up…
Use columnar file formats with cloudworks
WIth the ability to connect cloud storage to anaplan with cloudworks, it would be great to be able to use columnar file formats (like parquet or orc). Parquet format is considered a better file format for analytical workloads as large sets of data can be read faster than with row files format (.csv, .txt, .tsv..). As these…
Question for Level 1 Activity 4.8.2: Import Data into E2 Employees# List
Hello there, I have one question regarding the activity 4.8.2 in level 1 where I imported the data successfully but employees of departments all shows up like numbers (please refer to why number.PNG). As you can see from the screenshots enclosed, the mapping was correctly done before importing (refer to Import set up.PNG)…
Management Reporting slides download for multiple page selector at once
Currently we can download slides for each page selector by one by one .It would be great if we can download one slide for all item in page selectors at one click . Scenario - In page selector , we have 100 employees Data in slide changes according to page selector (using dynamic text ) .Customer wants to export slide for…
[Post Work] Join the Conversation: Unleashing the Power of Anaplan Integration
Hey there, fellow Anaplan integration enthusiasts! After attending the Anaplan Community Event (ACE) OEG training in San Diego on June 5th, we invite you to be part of an exciting discussion that holds immense potential for your organization's growth and success. We want to hear your thoughts on how learning about the…
Export data from Anaplan to SQL server through Anaplan Connect script
Hi Anaplan Connect experts, I need some help. I know how to write a Anaplan script to load data from SQL Server to Anaplan module. I need sample script from you, how to export data from Anaplan to SQL server. Could you share me your sample script please? Thank you & regards, Anil
Ability to copy/paste values incl. hidden decimals from Excel
When copy/pasting values from an Excel table to Anaplan, it only includes the decimals shown in Excel. E.g. if the value 0.5499 is in Excel but the cell in Excel is set to only show one decimal place, the value displayed will be 0.5. When copy/pasting to Anaplan, 0.5 will be used and not the full 0.5499. This issue can of…
2.3.10 Activity: Create Demand Forecast_unable to see FY21 data
Hi, As per process I have created DEM03 Demand Forecast Module. It shows FY20 data but FY21 data is missing in the data. Could anyone please assist me If I am wrong anywhere. Please refer below screenshots. required output- I got below output -
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…
Volumes for DATA02 SKU
Hi team, I have mapped the data SKU.csv as per below screenshot. And under DATA02 sku line items mapped volumes However, only Jan 2019 and Jan 2020 data is visible in the sheet attached jpg, Please guide me with steps to rectify so that volumes are visible under each month.
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…
Automate actions that run the Anaplan Optimizer with Anaplan Connect, Cloudwork and the Anaplan API.
Until today, actions that run the Anaplan Optimizer are not supported by Anaplan Connect, CloudWorks and the Anaplan API. Because of that, it is not possible to put any processes that include the optimizer on schedule. This is blocking a number of use cases that could add value to our client.

Data Integration

Discussion List