Adding Dataverse to Gateway

[sovereignauto]

Good Morning, 

I run a on Prem gateway with a SQL and i am not trying to add a Dynamics365 connection (dataverse) but in the Gateway i cannot add dataverse as a connection as it is not in the list. 

Anyone know how best to do this?

Cheers 

[Daryl-Lynch-Bzy]

I believe, not absolutely certain, that the Data Gateway allows the "pass through" concept because there are Flow connector for SQL database.  For example, Flow to Synch Dynamics 365 with an On Premise Database - Joe Gill.

This scenario should required an normal ODBC connection.  This option will be available if the TDS protocol endpoint is enabled.

[Daryl-Lynch-Bzy]

Hello @sovereignauto , I don't think the Data Gateway is used for data flowing from Cloud to On-Premise.  The Data Gateway is normally to flow from On-Premise to Cloud.   There a setting called Tabular Data Stream (TDS) Protocol endpoint that needs to be enabled in the Dataverse.  This would allow SSMS to connect to the Dataverse.  Ideally, an connection to D365 would use a API call rather than Linked Server connection.

The following might help get you started:  Use SQL to Query Data from CDS and Dynamics 365 CE (powerobjects.com)

[sovereignauto]

Thank you for this. 

my understanding is that you can use the Gateway as a "pass through" so you can connect on Prem and cloud services in the same dataflow