cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
corew50
Level: Powered On

Reporting Replica or Keeping Entities in Sync

Hello everyone,

 

I am trying to figure out how I can keep entities in sync between different environments.  One use of this would be that my test environement has the same data as my prod environment to make for better testing.  The other use would be to create a reporting replica so that my reports don't pull off of production data.  I haven't seen any way to do this so far.

 

I looked at data integration projects, but those all seem to be for data external to CDS coming in.

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Level 8

Re: Reporting Replica or Keeping Entities in Sync

Hi @corew50 ,

 

Do you want to copy entity from production entity to test entity and keep data in sync with each other?

Though in PowerApps, I think it is not supported at this stage to keep Entities in Sync between environments.

However, via Flow, you may can realize that, although it's a little bit complicated.

 

In Flow, it is unable to synchronize directly between entities from two different environment.

But we can use SQL to transfer.

  1. Create the first flow to transfer entity to SQL in environment A.
  2. Create the second flow to sync SQL to CDS entity in environment B

For more help, maybe you can post on Microsoft Flow Community or refer to these similar thread:

Sync SQL table into CDS

How-to copy attachments from the CDS to SharePoint Online

 

Best regards,
Sik

3 REPLIES 3
v-siky-msft
Level 8

Re: Reporting Replica or Keeping Entities in Sync

Hi @corew50 ,

 

Do you want to copy entity from production entity to test entity and keep data in sync with each other?

Though in PowerApps, I think it is not supported at this stage to keep Entities in Sync between environments.

However, via Flow, you may can realize that, although it's a little bit complicated.

 

In Flow, it is unable to synchronize directly between entities from two different environment.

But we can use SQL to transfer.

  1. Create the first flow to transfer entity to SQL in environment A.
  2. Create the second flow to sync SQL to CDS entity in environment B

For more help, maybe you can post on Microsoft Flow Community or refer to these similar thread:

Sync SQL table into CDS

How-to copy attachments from the CDS to SharePoint Online

 

Best regards,
Sik

Highlighted
DavidJennaway
Level: Powered On

Re: Reporting Replica or Keeping Entities in Sync

I think you're asking about 2 different topics: synching data between CDS environments, and creating a replica for reporting (which may or may not be in CDS).

For synching data between CDS environments, I'd normally use a tool to do scheduled or ondemand updates, e.g. SSIS with the KingswaySoft component

For a reporting replica, you could use the Data Export Service to sync data to a SQL database in Azure, which has the advantage of giving you direct SQL access for reporting

corew50
Level: Powered On

Re: Reporting Replica or Keeping Entities in Sync

Thanks for the response.  They could be two different topics, but for me they would be the same.  Our intention is to create a reporting replica in CDS.  I see that you have reccomended an external tool to keep the CDS environments in sync.  Does that mean that there isn't some sort of internal way of handling this?  

 

The data export service may be a good way to go.  Do you know if that handles custom entities as well?  We have both Dynamics 365 data and custom entities that drive canvas apps.

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 526 members 5,501 guests
Recent signins:
Please welcome our newest community members: