You can import data from Amazon S3 to create source datasets in Anaplan Data Orchestrator (ADO). To import data, you must create a connection to Amazon S3 with the Amazon S3 connector in Data Orchestrator.

Before you can create a connection to Amazon S3, you need the prerequisites listed in this table.

ItemNotes
Amazon Web Services (AWS) S3 bucket A S3 bucket hosted on AWS or any S3-compatible cloud service.
AWS IAM user with security credentials

An IAM user with an AWS access key ID and an AWS secret access key. 

They also need at least read permissions for ‌the bucket and objects.

CSV file in Amazon S3

For the CSV file, make sure that:

  • You specify the prefix or folder path if you restrict access to a subset of the bucket.
  • CSV files are UTF-8 encoded.

See File requirements for Anaplan Data Orchestrator for more information about CSV file requirements.

Use the S3 connector in Data Orchestrator to create a connection.

You will need your S3 credentials to connect your S3 data with Data Orchestrator. View the S3 documentation for more information about your credentials.

To create a connection:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Choose a dataspace from the list.
  3. Select Connections on the left-side panel.
  4. Select Create connection.
  5. Select the S3 connector on the Select a connector screen, and then select Next.
    If you can't find the connector, enter a search term in the Find... field.
  6. Enter these details on the Connection details screen, and then select Next:
    • Name: Create a name for your connection. The name can contain alphanumeric characters and underscores.
    • Description: Enter a description about your connection.
  7. Enter your S3 credentials on the Connection Credentials screen, and then select Next:
    • AWS Key: The access key ID (for example, AKIAIOSFODNN7EXAMPLE). 
    • AWS Secret Key: The secret access key (for example, wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY).
    • Bucket: The S3 bucket where your data is stored (for example, S3-EXAMPLE-BUCKET).
  8. After the connection test is complete, select Done.

You can import data from Amazon S3 with a pipeline or a connection extract. Use the connection you created to configure the pipeline or connection extract.

Setup your ADO Demo using an AWS S3 Connection