Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Azure Synapse Analytics- SQL Server tables
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 75%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Satya Siddabattula
1
Reputation point
We are utilising the DES service from Dynamics 365 online to pull the tables to the Azure Server, and we have developed views on the SQL Management Studio that we are reporting on using Tableau. Because DES is being phased down this year, we made a connection with Azure synapse analytics for Tableau to extract the tables. However, we want to use SQL Management Studio to access the tables and views in the same way as before. Could you please share any details about this?
Azure Synapse Analytics
{count} votes
-
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator2022-06-29T11:11:30.82+00:00 Hi @Satya Siddabattula ,
Thanks for posting query in Microsoft Q&A Platform.
Little unclear on the ask here. Could you please clarify what you mean when you say pulling tables to Azure Server? You mean loading data to Azure SQL server DB tables?
Is your ask is now how to connect Azure Synapse dedicated SQL pool using SQL management Studio?
In Azure Synapse we have two types of SQL. One is serverless SQL and another one is dedicated SQL Pool. Both of these SQLs can be connected with SSMS using there end points. End points can be found in Overview page of Synapse resource in Azure Portal as shown in below image.
Hope this helps. Please let us know how it goes. Thank you.
Sign in to comment
Sign in to answer