MicrosoftSQLServerToPandasDataFrame

Description

This package query data from any SQL Server Database and parse it into a Pandas Dataframe it can be useful for pipelines process and speed up your development process.

Usage

from SQLServerToPandasDataFrame import createConnection, runQuery

Base_Query = "select * from [DataBase].dbo.Table"

server = "HOST_DIRECTION"
user = "USER_NAME"
password = "PASSWORD"

conn = createConnection("MyDataBase", server, user, password)
print(runQuery(query1, conn))

Settings

This package performs by default all the connections to a SQL Server using ODBC Driver 17 for SQL Server driver. if you wanna use a different driver, please replace add the driver parameter in create Connection method.

conn = createConnection("MyDataBase", server, user, password, driver = "DRIVER OF YOUR PREFERENCE")

conn = createConnection("MyDataBase", server, user, password, driver = "ODBC Driver 17 for SQL Server")

We use Pyodbc as ODBC access library, for more driver options please ckeck the documentation PyODBC Documentation.

Collaborators

• Germán Andrés Jején Cortés @andres_jejen on twitter