Forum Discussion

sovereignauto's avatar
sovereignauto
Helper III
4 years ago

Adding 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 list. 

 

Anyone know how best to do this?

 

Cheers 

Need Help
Tutorial Requests

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      sovereignauto
      Helper III
      4 years ago

      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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.