Endjin - Home

Python

Using Python inside SQL Server

by Ed Freeman

Do you have a bunch of data in SQL Server that you’re using ODBC/JDBC to pull data to work with in Python? Using SQL Server’s Python integration, you can connect to a SQL Server instance within your preferred IDE and perform the computations on the SQL Server Machine. No more clunky data transferring. Operationalizing a Python model/script is as easy as calling a stored procedure. Any application that can speak to SQL Server can invoke the Python code and retrieve the results. Easy! This blog will provide a few, simple examples which make use of this capability to carry out some simple Python commands, so you can get up and running as quickly as possible.