Anaplan Setup Guide link
Follow our setup guide to connect Anaplan to Fivetran.
Prerequisiteslink
To connect Anaplan to Fivetran, you need an Anaplan account with permissions to run export actions.
NOTE: We recommend using a dedicated Anaplan account for Fivetran.
Setup instructionslink
Find region link
Log in to your Anaplan account.
Find the region in which your account is hosted in your Anaplan URL and make a note of it. For example if your URL is
https://us1a.app.anaplan.com/
, your region isDefault
.
Create export definitionslink
In your Anaplan dashboard, select your Anaplan model.
Open the module, list, or grid, from which you want to sync the data.
On the tool panel, click Data > Export.
In the export pop-up window, configure the following fields:
- File type: Select Comma Separated Values (.csv)
- Layout: Select Grid or Tabular Single Column
- What to Include/Exclude:
- For the grid layout: Select Current Page and Omit Empty Rows
- For the tabular single column layout: Select All Line Items and Omit Empty Rows
Select Save Export Definition and provide a unique name.
NOTE: We don't recommend using special characters in export names.
In the Set as default file for drop-down menu, select Myself (keep private).
Click Run Export.
Repeat these steps for every module, list, or grid you want to sync.
Finish Fivetran configurationlink
In the connector setup form, enter your chosen destination schema name.
Select your authentication mode: Basic or Certificate.
In the Region drop-down, select the region you found in Step 1.
Provide the following credentials for your Anaplan account:
- If you selected Basic authentication mode, enter your Anaplan username and password.
- If you selected Certificate authentication authentication mode, upload the certificate and private key files.
Click Login to test your credentials.
Choose the Sync Mode you want to use: Sync All Exports or Sync Specific Exports. If you choose Sync Specific Exports, select the exports that you would like to sync.
Click Save & Test. Fivetran will take it from here and sync your data from your Anaplan account.
Related articleslink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration