Data Integration

Anaplan Connect Workspace to Workspace
Hi Anaplaner, Can I use anaplan connect to import data from workspace to another workspace ?
Bulk Copy - Scheduling
We all know how useful Bulk Copy is - When the data across the model needs to be moved from one version to another or from one list item to another list item Bulk Copy plays the pivotal role. WS admin has to perform this task manually all the time as per the need. Can we have an action created when WS Admin runs the Bulk…
API export with a filtering parameter?
I have an API process that pulls data from a module that includes the Users dimension. There may be multiple users in the system concurrently and I need to keep their data separated. I need to filter the export from this module for a specific user -- the one who clicked on a link URL on an Anaplan dashboard to initiate a…
Update Target Object of Import Actions
Hi, It would be nice to have the ability to update the Target Object of and Import Action to a module or list with similar/identical definitions vs creating new actions from scratch. We have come across instances when building out a model we determine that an already created Import Action needs to have the source data…
Excel add-in German Localisation
As an end user I would like the Excel add-in to be localised for the Standard German language.
Error : Anaplan API: Could not connect to database! (SQL: No suitable driver found for
Hello, We are currently of migration from Anaplan Connect 1.3.3 to 1.4.3.When we launch our .bat, we get the following error message: Could you help us about this error message ? Regards,
Anaplan Connect Upload Error
Hi, This is the first time I am using Anaplan connect. While creating the script and looking at the documents, i drafted a script that allowed me to first upload, import thru an action followed by lastly a process. I have apparently uploaded the file successfully however I am met with problems with my action that imports…
Test Automation of Anaplan Application
Hi, We are trying to perform test automation on Anaplan. We tried using HP UFT and Wroksoft Certify tool. We tried to capture objects as it is done on a web application but We are not able to identify the objects. Can anyone please provide inputs on what platform Anaplan was developed (e.g.Java, Silverlight etc.). Thanks…
Excel Add-in 3.2 vs. 3.3 vs. 3.4
Dear everyone, I am part of the IT organization at my company, and I am responsible for the Anaplan environment from am IT perspective. We are currently using the Excel add-in v. 3.2, which meets our organization's requirement to control the data in Anaplan (read only, not write-back). My organization wants to keep the…
Imported data automatically multiply with 100
Dear everyone, My company is in the 1st stage of building Anaplan. Recently, we've managed to automate the process of data integration which is to import data from our server (Microsoft AX 2012) into Anaplan. To be simplified, we have 2 step. Firstly, a batch job will download data from server (pre-scheduled) to a local…
Data Import from excel
How do I import an excel data grid with no unique ID and no unique combination of property? Note: Customer is looking for keeping anaplan as system of records and wish to generate a unique ID within Anaplan, but key thing is it has to be a import/ not insert using dashboard. Thanks Arun
Update the Data in Current Module
In my current module which is dimensionalized by a numbered list I added additional 4 line items .. and I have a csv file based on which I want to update my current module. However, the dimension is a numbered list and display name has a logic to it. I have lot of other keys which can be unique to update the data, however,…
Set default file to everyone
Would be really handy if Anaplan did either one of the following actions for import data sources: * Set the default file type as everyone or; * Permanently saves files regardless of default file type selected. This would really assist in debugging and remapping import files.
Outlook connector for Anaplan to sync schedules for meeting invites and activities from workflow
Hi Anaplan, I believe a great development for the platform would be to have a native connector that links to Outlook or other schedule planning applications. This would allow users to sync their meeting and calendar invites and also sync workflow messages and requests directly with Outlook. This would mean in the most used…
API V2 Enhancement - more info about models
As a member of Anaplan Center of Excellence and user of Anaplan Integration API, I need to get more information about models. In old version of API (1.3), we could get more information about models than in newer one (2.0). The missing (and really useful) data are: -'isoCreationDate' -'lastModified'…
Ability to automate export of blueprint view for module through API/Anaplan Connect
It would be very useful to have the ability to automate the export of a blueprint view of a module through Anaplan Connect or the Anaplan API - in this way we could compare an export of a blueprint view of a module automatically, to check if the structure of a model had changed over time. I have been working with a client…
User Permissions in Excel add in
Hi, I am an admin and I want to create an excel file for users that have different list permissions. When another user opens the file they can still see the data for all the list. Is there a way to restrict this? Thank you
Does The Anaplan Way (or Agile) require a traceability matrix?
Hello, More of a methodology question than an Anaplan question. Is a traceability matrix required or a part of The Anaplan Way (or Agile)?
Using Python's statistical capabilities to Manipulate data already in an Anaplan Model
I want to leverage Python's statistical capabilities to manipulate data already in an Anaplan model. Has anyone done this before / had any experience with this? I know I can use Python as a data integration tool, but would like to also use it for calculations.
Anaplan Connect - Export via JDBC
Hi guys, This is my first time really getting to grips with Anaplan Connect and I'm trying to PoC exporting out a simple table of "Region Name" & "Region Code" using Anaplan Connect via JDBC into a SQL table. My scripts are as follows: ---------.bat script----------- @echo off rem rem rem set…
Upload - Non Mapped Source Items Identification
Hi team, Is there a way to identify Source Items in a list that have not been mapped to an item in the target for a Upload to a module in Grid Mode? I am aware you can manually identify the non-mapped items by scanning the Mapping tab but this seems inefficient and error prone (especially with large data sets). When you…
Manage Import Data Sources - Timing
Hi team, How long does Anaplan retain a file that has been uploaded to the 'Manage Import Data Sources' item in the Action Settings? It seems to retain the data for a certain length of time and then if you attempt to edit the Action to which the uploaded data is associated with you will receive the attached error Thanks…
Free S/MIME certificates to authenticate and use Python with Anaplan
Hi, I want to use Python with Anaplan. To do this we need to authenticate with either certificate or basic encoded authentication. I don't really want to use the latter as it's not as secure as Certificate authentication. I can see I need a S/MIME certificate to authenticate with Anaplan's API. Does anyone know of any free…
Display Action Notes on the Pop-Up Message, before a Process/Action is Run
In the Actions menu, all processes and actions has a text based "Notes" section. Being very upfront, I honestly didn't even know this section existed until about a few months ago, but I definitely think it can be further leveraged. It would be great if these notes could appear every time, next to your action, before you…
Data fields are offset when retrieving data in Chunks via API
I'm retrieving a large export via the API and because of the size of the file, Anaplan breaks up the export into multiple chunks. The issue is the column structure in the first and last record of each chunk isn't consistent. For example, in the attached image, the first chunk ended on the first row mid-way through the…
Download A File Using API V1.3 - Do I Always Need to Delete File First?
Hi Anaplanners! I finally have gotten around to asking this question that's been bothering me since I started using the APIs to download a file. I get inconsistent results when I test this on my own so I thought I'd ask the Community. The use case: I want to download a file (export) based on a view from a module using API…
Hyperconnect read and write to SQL database
Hi, I've been researching this and could not get a definitive answer from either here or the Infomatica forums. Can Hyper connect read from on-prem SQL tables, import into Anaplan, and write back to on-prem tables in a SQL database?
Import for Weekly Data
I am trying to import Historical Weekly Data, but am constantly getting error. Please assist how to import Weekly Data? I tried several times, I have attached Screenshot.
Anaplan Integration & Anaplan Connect
Hello Community, I'm reaching again support for some questions I have, some of which may appear silly for some experienced users. I've been trying to find an easy way to obtain Action's ID in Anaplan as those are used for our B2BI integrations with other ERP and EPM systems. Initially, I thought I can easily get them from…
Prompt for Import Data Source name and Import Action name
Something that would considerably help with building cleaner models would be if users could enter names for import data sources and import actions during the import dialogue. This would prompt model builders to assign a considered name, and substantially help to identify import data sources and import actions after the…

Data Integration

Discussion List