Connecting to SQL Server

For information on the available WHL files for supported environments, and how to install the appropriate file for your Python distribution, see Package Installation.

For information on the module to import, and how to configure the necessary connection properties in a connection string, see Establishing a Connection.

Other available connection properties can be used to configure other aspects of the connector capabilities.

Python Version Support

The CData Python Connector for SQL Server can be installed and used in Python 3.10 or newer.

SQL Server Version Support

The connector enables connectivity to SQL Server through the TDS protocol. SQL Server versions 2008, 2012, 2014, 2016, 2017, 2019, and 2022 are suppported.

Connections to Azure SQL Server and Azure Data Warehouse instances are supported as well.

See Also

• Using the Connector: Establish connections and query SQL Server through Python code.
• From SQLAlchemy: Use SQLAlchemy to establish a connection with dialect URL, and interact with SQL Server data using mapped classes and Sessions.