You cannot use comma-separated values, tab-separated values, or other formats with Anaplan V2 Connector.
You must use double-quotation mark (") as the text-delimiter.
You must populate all column names. Empty columns are not supported. For example, tabular single-column CSV exports of Lists contain an empty cell, which can be replaced with a "_DUMMY" or any other string placeholder. In the Informatica field-mapper, this can be addressed.
Import row counts in Anaplan
synchronization
tasks return zero. Export row counts are reported correctly.
To check Import row counts, check the
session.log
file from the Monitor page.
Note that Anaplan tested with a 500 MB file using with the following settings:
Data buffer for FileContentAsBase64String: 104MB
Informatica Secure Agent: 6 GB of RAM
DTM JVM: -Xmx4096m
Tomcat JRE INFA_MEMORY: -Xms512m to -Xmx4096m
To increase the field buffer size and Secure Agent memory, see Informatica documentation.
You can perform model-to-model import in a process operation and not in an import operation.
A process operation generates a dump file only if it contains an import action.
A process is limited to any combination of model-to-model import actions and/or delete actions.
When you use API based field mapping, ensure that the import action does not contain custom date formats.
You must enter alphanumeric characters in Anaplan column names and field values.
Data Integration
does not support names that contain spaces or the followingspecial characters ` ~ ! @ # $ % ^ & * ( ) + = < > [ ] { } ?.
You must refrain from using numeric column headers or column headers starting with numbers in order to avoid confusion with the “_NUMHDR_” tags
The Anaplan V2 Connector uses the values for Column Separator and Text Delimiter that are set in the model through the File Import Data Source Definition.