question

ShawnMathew-8116 avatar image
0 Votes"
ShawnMathew-8116 asked ShawnMathew-8116 commented

Azure synapse data warehouse connection string

I have a connection string for Azure Synapse data warehouse provided by another party, what are the next set of steps I am supposed to follow to get access to their data warehouse?

azure-databricks
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for you for your reply, I will try it the way you have mentioned

0 Votes 0 ·

Hi could you please mention where I have to enter the connection string ive got to get access to the databse? is it inside azure data studio?

0 Votes 0 ·

Hi,

You can connect and query using Visual Studio SSDT, Azure data studio, SQL Server Management Studio (SSMS), SQLCMD
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-visual-studio

You can connect to a SQL pool in Azure Synapse with several different application protocols such as, ADO.NET, ODBC, PHP, and JDBC.

0 Votes 0 ·

hi I tried to create a new connection in Azure Data studio but its not working

0 Votes 0 ·
PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered ShawnMathew-8116 commented

Hello @ShawnMathew-8116,

You can use multiple tools to access the data table.

Here are the steps to connect Azure Synapse Analytic using Azure Data Studio:

For Dedicated SQL pool (formerly SQL DWH):

Step1: Go to Azure Portal => Select Dedicated SQL pool => Overview copy server name

84863-image.png

Step2: Open Azure Data Studio => Create a connection => Give the below details as shown below.

 Server name: servername.database.windows.net
 Authentication: SQL Server Authentication
 Login:admin
 Password:***********

85510-datastudio-sqldwh.gif

For more details, refer Quickstart: Connect and query a dedicated SQL pool in Azure Synapse Analytics with SQL Server Management Studio (SSMS).


For Azure Synapse SQL pool:

Step1: Go to Azure Portal => Synapse Workspace => Overview => Copy any SQL endpoint

 Dedicated SQL endpoint :synapseworkspacename.sql.azuresynapse.net 
 Serverless SQL endpoint: cheprasynapse-ondemand.sql.azuresynapse.net

84864-image.png

Step2: Open Azure Data Studio => Create a connection => Give the below details as shown below.

 Server name: synapseworkspacename.sql.azuresynapse.net
 Authentication: SQL Server Authentication
 Login:admin
 Password:***********

85566-datastudio-synapse.gif

For more details, refer Connect to Synapse SQL.

Hope this helps. Do let us know if you any further queries.


Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.



· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @ShawnMathew-8116,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @ShawnMathew-8116,
Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!

0 Votes 0 ·

thank you for your reply

0 Votes 0 ·
learn2skills avatar image
0 Votes"
learn2skills answered learn2skills edited

Hi @ShawnMathew-8116
Thank You for posting in Q & A.

To get access to Azure Synapse follow the URL Azure Data Studio is fully supported starting from version 1.18.0. SSMS is partially supported starting from version 18.5, you can use it to connect and query only.
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/connect-overview

Download and install Azure Data Studio
Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.

You can use SQL Server Management Studio (SSMS) to connect to and query Synapse SQL in Azure Synapse Analytics through either serverless SQL pool or dedicated SQL pool resources.
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-ssms


If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.