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.
Prerequisites
Before you can create a connection to Amazon S3, you need the prerequisites listed in this table.
| Item | Notes |
| 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:
See File requirements for Anaplan Data Orchestrator for more information about CSV file requirements. |
Create a connection with Amazon S3
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:
- Select Data Orchestrator from the top-left navigation menu.
- Choose a dataspace from the list.
- Select Connections on the left-side panel.
- Select Create connection.
- 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. - 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.
- 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).
- AWS Key: The access key ID (for example,
- After the connection test is complete, select Done.
Import data
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.
Import data with an Amazon S3 pipeline
Import data with an Amazon S3 connection extract