File requirements for Anaplan Data Orchestrator

You can upload CSV files into Data Orchestrator locally, or through a connection with Amazon S3, Azure Blob, Google Cloud Storage, or SFTP.

For local files, Data Orchestrator supports CSV files only. The file limit for local CSV files is 5 GB.

You can only upload the local CSV file manually. When the CSV file is uploaded, columns are uploaded as strings. 

Once you set up a link to the file, you can update the file with the same file or a new file. The new file must have the same structure as the previously uploaded file and have the same column headers (the content can be different).

CSV files uploaded locally must include these items:

• The first row must include the column headers.
• Every column must have a header.
• Each column header must have a unique name.

The CSV files uploaded locally can only use:

• Commas
• Underscores in column headers

Don't include these characters in the column header names:

• Special characters (only use alphanumeric characters).
  Special characters are replaced by an underscore (_).
• White spaces at the beginning or end of the header name.

The file limit for CSV files is 5 GB. When the CSV file is uploaded, columns are uploaded as strings.

CSV files uploaded through a connector must include these items:

• Configuration of the column separators and text delimiter characters.
• Each column header must have a unique name.
• Every column must have a header.
• Include column headers.
• Row number for the column headers.
• Start row for the data.

Don't include these characters in the column header names:

• Special characters (only use alphanumeric characters).
  Special characters are replaced by an underscore (_).
• White spaces at the beginning or end of the header name.
• Column headers starting with numbers (see note).