Anaplan Sink

The Anaplan sink is available in the Hub.

Sink plugin for supporting data import from CDAP to Anaplan server.

Due to the limitation of Anaplan API 2.0, this plugin does not write data in parallel so it might take some time on larger datasets.

Configuration

Properties

Macro Enabled?

Description

Properties

Macro Enabled?

Description

Workspace ID

Yes

Required. The target Anaplan Workspace ID.

Model Id

Yes

Required. The target Anaplan Model ID.

Server File Name

Yes

Required. The name of the placeholder file in the Anaplan model. You must define the placeholder file in the Anaplan model before using the Anaplan sink in a pipeline.

Service Location

Yes

Required.  The root service location of the Anaplan API.

Auth Service Location

Yes

Required. The service location for the authentication.

User Name

Yes

Required. The service account used for the connection. Recommended: If the service account changes periodically, use a macro.

Password

Yes

Required. The password for authentication. Recommended: Use secure macros for sensitive values like User passwords.


Data Type Mappings from CDAP to Anaplan

The following table lists out different CDAP data types, as well as the corresponding Anaplan data type for each CDAP type.

CDAP Data Type

Anaplan Data Type

CDAP Data Type

Anaplan Data Type

array

unsupported

boolean

bool

bytes

unsupported

date

date

datetime

unsupported

decimal

numeric

double

numeric

enum

unsupported

float

numeric

int

numeric

long

numeric

map

unsupported

record

unsupported

string

text

time

unsupported

timestamp

unsupported

union

unsupported

Created in 2020 by Google Inc.