Anaplan

This page describes how to use Census to sync data from your warehouse to Anaplan.

Getting Started

In this guide, we will show you how to connect Anaplan to Census and create your first sync.

1. Locate your workspace and model ID

The Workspace ID can be found under Administration -> Workspaces within the Anaplan dashboard.

Locate the workspace ID

Select the Models tab under the selected workspace and click on the desired model. This action will open the model details page.

Select the model

The model ID can be found on the model details page.

Locate the model ID

The Model Id needs to be the model to which you want to sync, both the Workspace ID and the Model ID should be 32 characters long

2. Configure the Anaplan Connection

Navigate to the connections tab in Census. Select Anaplan

Authentication options

1. User credentials

   • You'll need to provide your

     • Username

     • Password

     • Anaplan Workspace ID

     • Model ID

     • Which region your Anaplan instance is hosted in.

The username and password will be the username and password used to authenticate to Anaplan

Add a descriptive label and copy your credentials

1. Self service OAuth

• You'll need to provide your

  • Client ID

  • Client secret

  • Anaplan Workspace ID

  • Model ID

  • Which region your Anaplan instance is hosted in

Add a descriptive label and copy your credentials

Creating your client ID and secret

Navigate to Administration -> Security -> OAuth Clients and click the New button in the upper right.

Create an oauth client

Name the client, choose Authorization code grant as the type, and set the allowed callback URLs to include https://app.getcensus.com/anaplan_callback. Then, click Create.

Clicking on the created OAuth client will provide access to the client ID and secret.

Creates oauth client

3. Test the Connection

You have successfully configured and tested the connection, so you can now sync data into your financial models from your data source! 🎉

️ Supported Objects and Behaviors

Object	Supported?	Behaviors
Import Action	✅	Replace

Import Actions must have the Source Type of File in order for Census to be able to sync to it. Look here for more details on how to configure this on the Anaplan side

Learn more about all of our sync behaviors on our Core Concepts page.

Contact us if you want Census to support more Anaplan objects and/or behaviors.

Replace Behavior in Anaplan

When using the Replace sync behavior with Anaplan, data is not deleted as it might be in other destinations. Rows are not removed. In certain cases, individual columns within existing rows can be cleared, but this depends on how the original import action was set up in Anaplan.

Clearing applies only to Module imports, not List imports. For clearing to occur, the import action must have been created with specific options enabled when the file was first uploaded manually in Anaplan. When importing data initially into the module, the Clear target prior to import option must be set in the import mapping, and the settings for both the underlying list and the module’s line items must specify that All Items should be cleared prior to import.

If these configurations were in place, a Replace sync will clear column values for records not included in the source data. If they were not set, no column clearing will happen during the Replace sync.

Need help connecting to Anaplan?

Contact us via [email protected] or start a conversation with us via the in-app chat.