cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
opticshrew2
Helper II
Helper II

CDS to CDS Data Integration

Hi all,

 

I have two environments each with their own CDS database. I've created connections for both of these databases and created a new Connection Set.

 

However when creating a data integration there appears not to be a template to connect them. Additionally, there appears to way to create a custom template.

 

The Microsoft documentation states that this should be possible however on further review, this only applys when making changes to their existing templates.

 

Can anyone advise if a CDS to CDS integration is possible?

 

Thanks,

J

1 ACCEPTED SOLUTION

Accepted Solutions
EricRegnier
Super User
Super User

Hi @opticshrew2,

It is possible with Dataflows (formerly named Data Integration) using the out-of-the-box OData connector. URL is your WEB API url (i.e. https://<org name>.api.crm6.dynamics.com/api/data/v9.1/) and sign in with the Organisation Account option. See images below. Hope this helps!

  1.  
  2. 2020-06-06_10-58-50.png
  3. 2020-06-06_10-59-24.png
    2020-06-06_11-00-18.png

 

 

View solution in original post

5 REPLIES 5
EricRegnier
Super User
Super User

Hi @opticshrew2,

It is possible with Dataflows (formerly named Data Integration) using the out-of-the-box OData connector. URL is your WEB API url (i.e. https://<org name>.api.crm6.dynamics.com/api/data/v9.1/) and sign in with the Organisation Account option. See images below. Hope this helps!

  1.  
  2. 2020-06-06_10-58-50.png
  3. 2020-06-06_10-59-24.png
    2020-06-06_11-00-18.png

 

 

View solution in original post

Additional to @EricRegnier's post, there are some steps for using dataflows to migrate data between CDS environments

 

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/cds-odata-dataflows-migrati...

You can also use power automate if you use the common data service connector

opticshrew2
Helper II
Helper II

Works a treat! I'm cautious not to use Power Automate as the inbuilt dataflow will also remove non-existant rows. Might give it a try anyway, we'll see 🙂 

Awesome, glad that helped!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,257)