Pipelines in Anaplan Data Orchestrator

Pipelines in Anaplan Data Orchestrator (ADO) enable automated data movement between Anaplan and external source systems. 

With pipelines, you can transfer data between ADO and external source systems. To create a pipeline, you must configure the pipeline’s source details and sink (target) details.

Pipelines require a connection that links Data Orchestrator with an external source system. You can either use an existing connection or create a new connection. They also require an Anaplan object.

You can create either writeback pipelines or read pipelines:

• Writeback pipelines: Writes back data from an ADO source object to external source systems.
• Read pipelines: Reads data from external source systems, and imports the data to ADO.

You can view and manage pipelines from the Pipelines screen in Data Orchestrator.

To view pipelines in Data Orchestrator:

1. Select Data Orchestrator from the top-left navigation menu.
2. Choose a dataspace from the list.
3. Select Pipelines from the left-side panel.

The pipeline details display in each column on the Pipelines screen. To change the displayed columns, select Edit columns. Edit the columns you want to display and then select Apply.

Select a pipeline link from the list to edit its source and sink details. If you select the pipeline row, the right-side panel expands and displays the pipeline details.

To rename or delete the pipeline, select the ellipsis icon to the right of the pipeline row. For more information, see Manage pipelines.

You can include additional functionalities to your pipelines to process data:

• Add additional steps: You can add additional steps to the pipeline to process the source data as it passes through the pipeline. Select the add icon between the Source and Sink to add additional steps.
• Row-based filters at the source: Based on the source you choose for the pipeline, you can add a row-based filter directly to the source. With the filter, only ‌rows from the source that meet the set criteria are passed through the pipeline.

After you create a pipeline, you can run the pipeline as part of an Anaplan Workflow. This enables you to automate data transfers based on a schedule, or trigger them manually as part of a larger sequence of tasks.