Dataflow Connectors

[crmkeeper]

Can someone help me figure out how I can connect to CDS with the current list of dataflow connectors? I am actually trying to authenticate between organizations, keeping 2 tables in sync. 

In Customer Insight they have their own CDS connector, and it would make sense to reuse that one here.. 

[v-yutliu-msft]

Hi @crmkeeper ,

Do you want to import data from CDS to CDS?

Here are two ways:

1)use csv file (you could choose entities that you need)

Firstly, export CDS data in environment as csv file.

Then, import this data in your environment2.

2)use data integration(can not choose entities, it will import all the entities in another environments).

You need to act this in admin center.

Here's a doc about this in details for your reference:

https://docs.microsoft.com/en-us/power-platform/admin/data-integrator

Best regards,

[crmkeeper]

I see my picture might not have made it from the last time. 

Picture is from make.powerapps.com where you have something called dataflow. I have used this for onprem SQL, and it works quite well. I am trying to see if I can use this for CDS to CDS also. I have tried the WebAPI, but I don't know what to enter to get entities showing.

NB! I am looking for a scenario where i can integrate CDS to CDS where the CDS is not on the same tennant.

Strange how i feel we have 
Make.powerapps.com - one type of connections

admin.powerapps.com - another type of integration

admin.powerplatform.com - I think is the same tech as the one above. 

I will also look into the CDS - CDS for same org in admin.powerapps.com that you suggested, because I also have a scenario like that i need to figure out

[v-yutliu-msft]

Hi @crmkeeper ,

I'm afraid CDS from another environment can not be the source of dataflow.

I suggest you express your views about adding this dataflow source on PowerApps Ideas Forum. Your precious feedback will be very helpful for our work.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

For now, export CDS data from on environment and then import it to another environment, I suggest you use "export data" and "get  data"in CDS. These two could break the block between two environment.

Best regards,

[crmkeeper]

Exporting via Excel is a manual export, and is not something I can do. In that case I would use XrmToolBox to do the transfer. I just found it strange that we can't use WebAPI or something similar to connect. We can connect to SalesForce but not our own. 

Are we sure there is nothing we can do via WebAPI here? 

Thank you anyway for the answers