Data Integration

Run model-to-model imports in Anaplan on a schedule that works best for you
You can use the native capabilities in CloudWorks to distribute data from the Data Hub to Spoke models, or between different models in the platform, any time you want with its model-to-model import functionality. No activation or add-on services are required to use this—everything you need to get started is in CloudWorks…
Keep Model In Memory (KMIM)- can we keep model cache alive , it will help with performance
n we keep the model cache in the buffer/memory (Keep running) alive, instead of clearing eveytime after logout? This will take a long time to load the model every time when size is huge ..otherwise we have to keep some dummy job running to Keep Model In Memory (KMIM)
File ID In Anaplan
Hi Team, Does anyone know where can i find the File ID in Anaplan? Thanks, BS
PlanIQ [internal server error] Meaning
Hello while making the data collection for PlanIQ, I faced with "internal server error" and failed data collection. By adjusting the original module (by putting time dimensions for row), the issue is now solved, but I'm now confused about the term "internal server error" since the term seems to be broader than "your module…
Python and Anaplan: Pt 2—Anaplan Model Registry Case Study
Welcome back to the second article of our Python and Anaplan series! If you're joining us for the first time, please see Python and Anaplan: Pt 1—Setting Up Your Environme... - Anaplan Community for help setting up your environment. What's best next—start using your Python environment in a real and useful scenario. With…
Parquet file format
It would be great to have the capability to load parquet format files to Anaplan as it becomes more and more popular in databases. At the moment we need to add one more step to the integration process to change the format to csv./txt. before loading data to Anaplan.
Error while exporting error dump from Informatica
Hi, I'm using informatica cloud for importing from source system to Anaplan Module. The error dump is exported to a windows server to view incase there is an error in the import. Error dump is exported in csv format. But incase of an error in import when the error dump is being exported I get the following failed…
Level 1: 10.2.2 - unable to load non employee expenses data
With the above mapping With the above time settings Still the data is not getting uploaded while message says it is success. Tried all optio
Weird Character in fist column of .csv import
I have been noticing on some .csv imports weird characters appearing in the first column of the .csv When I open in excel or text editor the characters are not there. Additionally, I seem to be seeing this quite a bit with exports directly from Anaplan.
Tableau connector usable with other tenants?
Is there some way to connect from Tableau to other tenant workspaces than your default tenant? I can't find anywhere to change the tenant and there is no word about it in the documentation. In the connector I can only select from workspaces within my default tenant.
Anaplan Connect API - Max size of single chunk
Hello everyone, Our integration developers want to connect to Anaplan via API 2.0. However, they need to know what is the upper limit of single chunk size. I know that Anaplan recommends dividing uploaded files into chunks not bigger than 50 MBs (source), so I assume it is a safe limit. However, you cannot set up chunk…
How to create Import/Export/Action or Process using Command Line/Shell Script in Anaplan
Iam running the below Command: java -classpath "E:/Neha_Nayal/Anaplan/anaplan-connect-1.4.3-jar-with-dependencies.jar" com.anaplan.client.Program -k E:/Neha_Nayal/Anaplan/keystore.jks -ka keystore -kp keystore_password -workspace workspace_id -model model_id -service service_url -auth auth_url -file…
DocuSign Connector: Part 3 - 5 tips and tricks you didn't know about the DocuSign Connector!
* 1: Set Signing Order First * 2: Use Saved Views to your Advantage * 3: Use 1-Dimension Output Module * 4: Use Flat Lists * 5: Do not use 'List' format Before we get started, if you need a refresher on the DocuSign Connector, go here, and if you want to leverage Anaplan, DocuSign and Box, go there. The Anaplan DocuSign…
DocuSign Connector: Step 2 - Layering in Box
* Phase 1: Setting up Box * Step 1: Set-up your Box Folders * Step 2: Format all Folders * Phase 2: Setting up DocuSign * Step 1: Add a Box Recipient Layer in DocuSign Workflow * Phase 3: Setting up the Anaplan Model * Step 1: Update Model Logic * Step 2: Add the Box Layer Line Items into your Output modules * Phase 4:…
[Start Here] Anaplan Connector for DocuSign – Part 1: The Basics
Welcome to your introduction to the Anaplan Connector for DocuSign. What you’ll find here is a quick walkthrough of the DocuSign connector, where we’ll quickly cover the basics of what the DocuSign connector is, who it’s for, and a quick discussion of some popular use cases for it. Let’s get started. What is the Anaplan…
List Item Count Reset Accessible via Anaplan Connect
Description: The ability to trigger the “Reset” action/button in the list configuration tab (for numbered lists), using Anaplan Connect to automate this process. Example of Enhancement: Anaplan Connect has an operation that enables reset of a list. And the index for a list can be reset without limitation (i.e. it doesn’t…
Anaplan Connect - Cannot locate 'Anaplan-connect-@re@.jar'
Hi Team, Attempting my 1st upload using Anaplan connect but receiving the below/attached error. I have below/attached the batch file I am using I have looked in the User Guide & online but cannot find a solution, appreciate any help Thanks! Mark
Help with Python API 2.0 & Transactional API
Hello I am attempting to utilize the transactional API in Python. Specifically trying to retrieve all line items in a model w/ID I tried doing this in Anaplan Connect earlier, however, it did not work for me. I am now trying in Python. However, it's quite the challenge as 1 article does not have the steps, I am having to…
'cmd' is not recognized as an internal or external command - while importing
Hi, I am trying to use a bat script to import in a list. When I manually enter username and password in the script, it works fine but when I change it to read it from a .txt file, it shows the error: "'cmd' is not recognized as an internal or external command, operable program or batch file.". It's not like there is an…
Suggested Import Data Source
Would be nice if I could quickly select an import data souce when setting up new import based on the most recently created saved view. The suggested source item can be based on whatever the last source in the Import Data Source list is.
Schedule model-to-model imports in Anaplan as often as you'd like
Use the native capabilities in CloudWorks to distribute data from the Data Hub to Spoke models, or between different models in the platform, any time you want with its model-to-model import functionality. No activation, add-on services, or technical resources are required to use—everything you need to move data between…
Ability to change Pivot in Google Sheets Add-on
The Google Sheets add-on doesn't let us change the dimensions in the Pivot when setting up the connection, unlike the Excel add-in. We need to create custom views in the model to be able to pull the data in the format we want. This is a big deterrent towards adoption of the Google Sheets add-in and restricts the…
Issue with Anaplan Certificate and Anaplan Connector
Hello All - It is my understanding that the latest version of Anaplan REST APIs and Anaplan Connector (v 1.4, lets call this AC) requires a CA Certificate for authentication against Anaplan. As…
Is Anaplan Add-in application the same for both MS Office 32bit and 64bit?
Our Finance team is upgrading to MS suite 64bit. Is there any known incompatibility between Anaplan Add-in 4.2 and MS Suite 64bit?
Export not Utilizing Filters
Hi Anaplan Community, I am working on a dashboard that includes a module with 3 dimensions (list 1, list 2, list 3), one for each dimension. On the dashboard there is an additional a module with a single line item that is list formatted. The second module is page synchronized and works as a drop down selector for the…
Cloudworks to include all Process status just at running in Model manually
In Cloudworks, only the detailed status of failed Process/import/export is shown, the successful ones are not shown. Would be great if the details status (Updated, Ignored, Unsuccessful) will be recorded for all imports/exports run, so that users will be able to confirm if the Process has been run correctly.
Informatica Scheduled job
I have an Informatica Linear Taskflow that consists of running some exports in Anaplan (via mappings) and then moving the output files to an FTP via Informatica FileProcessor (with Filemove in a Synchornization Task). This works great, when Anaplan has data to export. The problem is that this job is scheduled to run 3…
Anaplan Excel Add-in Prerequisites
I wanted to share an uncommunicated prerequisite for the Anaplan Excel Add-in 4.x series. Reading through prerequisites, the documentation explicitly indicates certain items that are not natively part of an operating system, like the version of MS Office or the supporting technologies of .NET 4.7.2 and Visual Studio Tools…
CloudWorks–This is how we use it - Part 5: Model-to-model
If you need a reminder on CloudWorks; go here. Why we are excited With the new CloudWorks release comes a long-awaited feature: “model-to-model" (or M2M) actions. Until now, you had 2 options to automate Anaplan-to-Anaplan flows: Implement a third-party tool such as Anaplan Connect (requiring a server that can run Java) or…
Building a Chat Bot - Part 1: using AWS
* What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Introduction * Using Anaplan APIs on AWS Cloud * Authentication * Create a role * Python Code * Examining the code * Best Practice: Information encryption * In summary What is covered in this article? First of…

Data Integration

Discussion List