0

All environments are in the same tenant, same Azure Active Directory.

Need to push data from one environment's (Line of Business) Common Data Service to another environment's Common Data Service (Central Enterprise CDS) where reporting is running from.

I've looked into using OData Dataflows, however this seems like more of a manually triggered option.

Arun Vinoth-Precog Tech - MVP
  • 22,364
  • 14
  • 59
  • 168
surroundedbycode
  • 1

1 Answers1

1

OData dataflows is meant for and designed to support migration and synchronization of large datasets in Common Data Service during such scenarios:

A one-time cross-environment or cross-tenant migration is needed (for example, geo-migration).

A developer needs to update an app that is being used in production. Test data is needed in their development environment to easily build out changes.

Reference: Migrate data between Common Data Service environments using the dataflows OData connector

For continuous data synchronization, use the CDS connector in Power Automate and attribute filters for source CDS record updates to target CDS entities.

enter image description here

Arun Vinoth-Precog Tech - MVP
  • 22,364
  • 14
  • 59
  • 168