You can push updated datasets from Anaplan Data Orchestrator to an Anaplan model with your created links. To update the model list items data, you can choose whether to upsert (update existing data and insert new data) or replace the existing list items. The model data that's updated are members of a list in the model and their associated module data.

Upsert and push data

A link is created with the upsert update type by default. The upsert update type updates existing list items data that exists in both Data Orchestrator and in the model. It also inserts new data from Data Orchestrator that doesn't exist in the model. 

If data exists in the model but doesn't exist in the Data Orchestrator, the upsert update type doesn't remove data from the model.

To keep the upsert update type and push the revised data to model:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Select Links on the left-side panel.
  3. Select a link row.
    The Information panel opens on the right.
  4. Select Push data.

To view the updated data in the model, open the updated list in the model and select Refresh.

Replace and push data

If you change the link update type to replace, the model list item data in the model is replaced with a new data from Data Orchestrator. 

New data from Data Orchestrator is added to the model. Data that exists in both the model and Data Orchestrator are retained and updated. 

Data that exists in the model, but doesn't exist in Data Orchestrator, is deleted from the model. When list members are deleted, it also removes associated data from modules that use the list as a dimension.

To change the update type to replace and push the updated data to a model:

  1. Select a link row.
    The Information panel opens on the right.
  2. Scroll down to Update type and select replace from dropdown.
  3. Select Push data.
    Before the data push completes, you can review the records that'll be added, deleted, and updated. If the updates look correct, select Push data again to continue with the data push. Otherwise, select Back to cancel the operation.

To view the updated data in the model, open the updated list in the model and select Refresh.