Data Integration

L1MB - 7.2.1 Activity
It seems that there is "Product" data but I cannot see data in Column SIZE. It is not allowing me to import it again. Any suggestions?
[UPDATED] OEG Best Practice: Integration Scheduling in Anaplan CloudWorks
Introduction Anaplan CloudWorks enables seamless data integration between Anaplan and other cloud-based applications. To optimize performance and efficiency, it's crucial to follow best practices when scheduling integration tasks. This article outlines recommended guidelines for creating integration schedules in Anaplan…
Allow .tsv files in the Cloudworks UI (again)
The Situation Currently we import all our files as a tab separated file (tsv), bundle a set of import actions in a process and orchestrate these processes trough Cloudworks Integrations. Tab separated files are one of the first possibilities in the file options: To indicate such a file is tab separated all our files are…
Level 3 Sprint 2 Employee Details into G3 Sales Reps
Hey Team, I have encountered some issue(s) with importing the datahub saved view employee details module into the G3 Sales Rep list in the Sales planning model. After a completing the import, the results (per the attachment) are not the employee names but numbers. Could you advise on how best to quell this issue and…
Cloudworks succeeds but doesn't actually run
Hi all, I've noticed for a CloudWorks process I have that the actual integration says "success", but when I check the model, the last run time of the process was not updated, nor was any new data added to the model. This is an integration from BigQuery that worked previously, and is now not actually pulling new data. Has…
Integration data between Anaplan and SFTP file
Do you know about integration data between SFTP (Filezila) to Anaplan? I want to import data from SFTP file to Anaplan.
How to import Negative Values from txt files
Hi All, I am importing data from tab separated txt files and I noticed wherever the values are negative, its populating as positive numbers in Anaplan. As shown in above example the negative values are denoted by a negative sign after the number in the txt file. Is this format supported by Anaplan? Thanks in advance
Trigger mail to end user
Hi All, Greetings! I have a request from one of the user if I can trigger an export of dashboard to email ID at a particular time slot. I am assuming this can be achieved through integration only. But I would be glad to know if there are other ways to achieve it. Thank you, Harshitha N.
Anaplan Connect with Snowflake & Public/Private Key
I am attempting to utilize Anaplan Connect to move data from Snowflake into Anaplan. In order to work with our snowflake setup, I need to use a public/private key pairing as opposed to a snowflake username/password. I have been told the most recent version of connect (3.0.0) does not work without these fields and that an…
DCA and Internal (Full Access) user Issue
Hi Anaplaners, I have a scheduled job run by an integration [Internal (Full Access)], in the target module some data/values (text or numbers format) are imported correctly however, in some line items with DCA the values imported are zero and this is not the value in the source module. Internal (Full Access) has WRITE…
Tableau to Anaplan Integration
Hi Everyone, I was doing POC for Integration between Tableau and Anaplan, where we export the data from Tableau as a file(.csv) and load the file into Anaplan. Thought of sharing my approach here. Below are the prerequisites we would need to proceed further. Download the latest Tableau Desktop from the Tableau Website and…
Text formatting within email's body
I am building email template for MAILTO formula. Is it possible to format the text (make bold, italic, colored) and create paragraphs in the emails' body? Maybe implement html tags?
How can we automate data imports from IBM sterling on premise server to Anaplan
Hi Team, Please help me in understanding how can we import data from IBM sterliling on premise server to Anaplan and automate it.
Manual Input for Recipients of Notifications - CW
At the time of writing of this post, it's only possible to choose from a limited list of recipients who receive the Notifications of CloudWorks integrations. However, it would be very convienent to be able to manually input email adresses of the recipients. This would allow to send the notifications directly to Team…
Ragged and Balanced Hierarchy help. Many to Many relationship with Ragged Hierarchy.
Hi Community, I have been reviewing the knowledge around Ragged and Balanced hierarchy. I have a bit of a unique situation and need some help from the Community. Attached is a file that breaks down the flat file I have put together of a relationship between entity-owner. Each entity has an owner. That owner can also be an…
Time treated as common list on Import Action
Hi, I am loading a CSV into a module that has simple time list at month level – however the import action is treating TIME as a common list rather than allowing to do the specific time mappings as expected. Im sending below the details with all the screeenshots I believe are necessary to help understanding the issue. Here…
Export/Import Time Periods
Hi team, I have a situation whereby users have the option to export the data from a module, adjust the relevant cells & then import the same CSV file to the module. There is an issue with 2 line items that have Time Period as the format. When they are exported the format in the CSV is 'MMM-YY' rather than 'MMM YY' & if you…
"invalid name: ....." error
Hi community. When trying to import into a list I receive the error "invalid name". Do you know where I can find the explanation of this error? Thank you.
2.3.8.2 Import into DEM01 Module
Hello All I m stuck in this activity, can you tell me if my mapping is correct ? I think that the probleme is with the time mapping, i actually change the time scale to month bu stell have this error: Help me please , Thank you
Data Import Integration
Hello, I have a question for my understanding on data import integration. When data is being imported from a database, source, etc how does Anaplan remove duplicate data from WS02 and are there any specific requirements on the sequence of data, or does that depend on the organization? How does Anaplan remove duplicate data?
Sending data from Anaplan through Informatica
Hi, I have an export action which is exporting a list. I want to send this list data to informatica. I have mapped this list columns to columns of a table in informatica. However the job is failing with below error. [ERROR] Error occurred while reading data from the target native system :…
Import error log enhancement in new UX
Suggest to enhance the current import error report in the new UX. The new overview only contains very limited information about any errors which occurred during import and it is not possible to get a preview of the errors as you can in the classic UX. At the same time, the ability to export errors is limited to 50,000 rows…
Impact of saved views in Connected Planning
As companies are growing, their use of the workspace is also growing resulting in multiple models. From an user standpoint, it is complicated to audit every saved view, as you can only see those that are being used in the model where they are being imported. As such, could we have a new tab in imports not only to see the…
Applying filtering on Tabular Single Column Exports
Being an Anaplan builder/user, I would like to be able use set on the view filters for export option "Tabular Single Column". Currently, if you prepare a view with set filters, if you run "Tabular Single Column" export, Anaplan will ignore filters and include all items from all dimensions in the extract. It has two major…
Make available for a Import Data source these system columns: Current Timestamp, Current User, RowID
As a Model builder, when I create an import action and I choose an Import Data Source ( File, Saved View, etc…) I would like that the Import Data Source to have available these additional system columns: Current Timestamp, Current User, RowID that can be mapped to target elements. Current Timestamp: should be populated at…
custom source connector plugins
As an integration admin, i need to be able to create custom source connector that can be scripted (using typically python, java) to get access to different types of sources data formats without the need to go through a csv or txt file upload each time. This would allow to get data sets from reading apis endpoints,…
Hyphen formatted numbers issue when exporting to excel.
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue When setting a numbered line item to hyphen format. When exporting as xls or xlsx, the hyphen formatted cell will only ever display a hyphen, even when edited to be non zero cell values.…
Custom page separation for dashboard PDF exports
Description of the enhancement required: Allow for page separation when exporting dashboards to pdf so that two published items may be printed on separate pages, back-to-back. An example of the enhancement: When selecting options for a PDF export on a dashboard, users would have the option to choose where the page…
SAP S/4 HANA & SAP PO to Anaplan integration best practices
Hi all, Looking to see if any other members of the community have integrated SAP S/4 HANA to Anaplan. If you did, were you able to achieve the integration with Anaplan Connect or the API through the SAP Process Orchestration middleware? Or did you *have* to write some custom wrapper program using either Anaplan Connect or…
Set the fields in a certain order that will not change for exports and have alias headers
For downstream systems, the headers must have specific names that are not related to how the Planners use Anaplan. Also, some of the downstream systems are very specific about the order of the fields in the export. When Anaplan has to adapt to business changes, the export to the downstream systems has to remain constant or…

Data Integration

Discussion List