You can import data into Anaplan Data Orchestrator with connectors to create source datasets.
To import data into Data Orchestrator:
- Create a connection between Data Orchestrator and an external source system with a connector.
- Extract data from the connection and create a source dataset.
To create a connection and data extract with a specific connector, see the connector pages listed below.
Connectors
You can create a connection with these connectors:
- Amazon S3
- Anaplan Financial Consolidation
- Azure Blob Storage
- Google BigQuery
- Microsoft SQL Server (MSSQL)
- MySQL
- Oracle DB
- PostgreSQL
- Salesforce
- SAP
- Snowflake
Data extracts
Once you create a connection, use the connection to extract and add data into Data Orchestrator. The data extract pulls data from the connection and creates source datasets. A connection can have multiple data extracts.
After the data is extracted, create a transformation view, which transforms that data into the structure required for your Anaplan model.
You are limited to running a maximum of 100 data extracts and a maximum of 100 model links in any 24-hour period per package. Contact your account team to add additional packages to your entitlement to increase the total number of data extracts and models links that you can run within a 24-hour period.
