#Using sql in visual studio install
#Using sql in visual studio driver

Now we have the library imported, we need to get the details for connectivity like ServerName, Db name, Login Credentials and a suitable driver for connecting to the Azure SQL Database. Use the below script to import the library, which helps us to connect to any ODBC databases: We need to import a open source library built for Python. Since we are trying to connect to a SQL Database which is ODBC by nature. Now let us focus on Visual Studio code to figure out connecting to Azure SQL Database. The data we have used for this demo comes from the AdventureWorks dataset which is a property of Microsoft. Let us first look at the data in Azure SQL Database using SQL Server Management Studio.

#Using sql in visual studio install

Install Python extension within VSCode and setup Environment variables as required.IDE: Visual Studio Code (Version: 1.24.1 or above).

Below are the software and their versions used at the time of this article. News – Check out our most recent news, key announcements & Press releasesĮver tried accessing data on Azure SQL Database from a Python IDE? This article will walk you through the steps required to reach the data in Azure SQL Database tables.īefore beginning, let us set up the pre-requisites needed for the process.Innovation Lab – The Innovation Lab is built with an aim to create market-ready BI & Analytic solutions.Careers – Explore intellectually rewarding careers in the field of Business Intelligence & Analytics.About Visual BI – We make the best in BI possible through our passion and commitment to innovation.Events – Check out events hosted and attended by Visual BI Solutions.Webinars – Get latest updates on our webinar schedules & register to learn from our experts.Videos – Handpicked video resources showcasing you the latest BI trends and technologies.Case Studies – A growing collection of more than 50+ case studies exhibiting our customers’ success.Blogs – Get your inside scoop into our take on the latest developments in BI & Analytics.Data Science & ML – Unlock endless possibilities with an optimum mix of Data Science and Machine learning.Modern BI & Analytics – Experience the power of data with modern visualization techniques.Strategy & Architecture – Drive successful outcomes with the right data strategy and architecture.Data Architecture & Engineering – Build a modern data foundation that supports your business.