Forum Discussion
sovereignauto
Helper III
Helper IIIAdding Dataverse to Gateway
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 lis...
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)
sovereignautoThank 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