Anaplan
Anaplan is a cloud-based platform for business planning and modeling.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | All tables |
History mode | ||
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 |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guide
Follow our step-by-step Anaplan setup guide to connect Anaplan with your destination using Fivetran connectors.
Sync overview
We use Anaplan's configurable export actions to move data from your models to your destination. We sync data from Anaplan by running export actions and obtaining results.
Export actions
Anaplan allows you to export data in different formats with different settings at different stages. You can save these settings as separate export action files for future use.
Fivetran saves each export result in a new table with the name following the pattern {workspaceId}_{modelId}_{exportName}
.
What are the requirements?
Fivetran only supports and syncs export actions with the following configurations:
- Comma Separated Values (.csv) file type
- Tabular Single Column (All line items) or Grid (Current Page) layout
- No empty rows
Deleted data
Fivetran updates all data in every sync because Anaplan doesn't provide any information about the updated and deleted records. In every sync, we soft delete the records where the _fivetran_synced
value is lesser than the sync_start
value.
Sync frequency
We cannot perform a sync while the models are being executed in Anaplan. Therefore, we recommend that you set the sync frequency in a manner so that we can perform the syncs outside your organization's working hours or when your models are not edited.
Schema information
This schema applies to all Anaplan connections.
To zoom, open the ERD in a new window.NOTE: The ERD includes two predefined tables,
WORKSPACE
andMODEL
. The other tables depend on your Anaplan configuration.