Anaplan is a cloud-based platform for business planning and modeling.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture Deletes | ||
| Custom Data | check | All export actions. For each action we create a table. |
| Data Blocking | ||
| Column Hashing | ||
| Re-sync | check | Connector level |
| History | ||
| API Configurable | check | |
| Priority-first sync | ||
| dbt Package |
Setup guidelink
Follow our step-by-step Anaplan setup guide to connect Anaplan with your destination using Fivetran connectors.
Sync overviewlink
Fivetran uses Anaplan’s configurable export actions to move data from your models to your destination.
Export actionslink
Fivetran syncs data from Anaplan by running export actions and obtaining results. There are only two predefined tables: WORKSPACE and MODEL.
Each export is saved in its own table with the names following the pattern {workspaceId}{modelId}{exportName}.
What is an export action?
Anaplan allows you to export data at different stages in different formats with different settings. You can save these settings as a separate named export action for future use.
What are the requirements?
Fivetran only supports the following export configurations:
- Comma Separated Values (.csv) file type
- Tabular Single Column layout
- All line items
- No empty rows
Export actions with different configurations will not be synced.
Deleted datalink
Because Anaplan doesn’t provide any information about updated and deleted records, each sync updates all data. Soft delete and change-data capture aren’t supported.
Sync frequencylink
We recommend that you set a sync frequency of once every 12 hours.
Schema informationlink
This schema applies to all Anaplan connections.
To zoom, open ERD in new window