Access Azure SQL DBs using Azure Synapse studio

Santhi Dhanuskodi 325 Reputation points
2024-04-22T08:25:56.1866667+00:00

I would like to understand how Azure Synapse Analytics can be used within the organization to facilitate data analysis and development.

How will developers access Azure Datasets in a convenient way

Is there a case for using Azure Synapse?

I have a use case where developers need to access azure SQL database. We dont want to enable public access. We can not keep on adding their IPs in SQL firewall settings. or we dont want any azure VPN setup for the same. Can we solve the access issue if we use synapse studio or any other synapse solutions?

Azure Synapse Analytics
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.
5,049 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA 90,261 Reputation points
    2024-04-22T08:39:27.8666667+00:00

    @Santhi Dhanuskodi - Thanks for the question and using MS Q&A platform.

    Azure Synapse Analytics is a powerful tool that can help you with data analysis and development. It provides a unified experience for big data and data warehousing, and it can help you to easily access and analyze data from various sources.

    Azure Synapse Link for Azure SQL Database is an option that you can consider for accessing Azure SQL databases. Azure Synapse Link is a cloud-native hybrid transactional and analytical processing (HTAP) service that allows you to analyze real-time data from Azure SQL databases using Azure Synapse Analytics.

    With Azure Synapse Link, you can easily connect your Azure SQL databases to Azure Synapse Analytics and perform real-time analytics on your data. You can use familiar tools like T-SQL and Power BI to query and visualize your data, and you can also use Azure Synapse Studio to build end-to-end analytics solutions.

    One of the key benefits of Azure Synapse Link is that it provides a low-latency, high-throughput connection between Azure SQL databases and Azure Synapse Analytics. This means that you can perform real-time analytics on your data without the need for complex ETL processes or data movement.

    For more details, refer to Get started with Azure Synapse Link for Azure SQL Database.

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


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.