Anaplan link
Anaplan is a cloud-based platform for business planning and modeling.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | |
Custom data | check | All export actions. For each action we create a table. |
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
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?link
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?link
Fivetran only supports the following export configurations:
- Comma Separated Values (.csv) file type
- Tabular Single Column (All line items) or Grid (Current Page) layout
- 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. In every sync, we soft delete the records whose _fivetran_synced
value is smaller than the sync_start
value.
Sync frequencylink
We cannot perform a sync while the models are being executed in Anaplan. Therefore, we recommend that you set the sync frequency in a way that we can perform the syncs outside your organization's working hours or at a time when your models are not edited.
Schema informationlink
This schema applies to all Anaplan connections.
To zoom, open the ERD in a new window.