Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

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!