Anaplan V2 Connector

Anaplan V2 Connector

Rules and Guidelines for Anaplan V2 Connector

Rules and Guidelines for Anaplan V2 Connector

  • 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 ` ~ ! @ # $ % ^ & * ( ) + = < > [ ] { } ?.
  • The data being transferred must contain ASCII characters. See the list at https://en.wikipedia.org/wiki/ASCII#ASCII_printable_code_chart
  • 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.

0 COMMENTS

We’d like to hear from you!