Python Connector for SQL Server について

PythonアプリケーションからSQL Serverマネージドデータベースとセルフマネージドデータベースにアクセスして、格納されているデータに対して作成、読み取り、更新、削除操作を実行

Python Connector for SQL Sever is a reliable connectivity solution for accessing SQL Server managed and self-managed databases from Python applications to perform create, read, update, and delete operations on stored data. The solution fully implements the Python DB API 2.0 specification and is distributed as a wheel package for Windows, macOS, and Linux.

Python Connector for SQL Server Features

  • Direct Connection - The solution enables you to establish a direct connection to a SQL Server instance through TCP/IP, eliminating the need for the database client libraries. A direct connection increases the speed of data transmission between a Python application and SQL Server.
  • High Performance - The connector supports a direct connection to SQL Server through TCP/IP without the database client library. It also lets you submit multiple update statements to the database for processing as a batch to improve execution time.
  • Fast Deployment - If your Python application must be deployed on multiple user workstations, you don't have to supply the database client library for every user since this connector supports a direct connection.
  • Secure Communication - The connector supports encrypted communication between a SQL Server database and Python application using SSL/TLS, SSH tunneling, and HTTP/HTTPS tunneling.
  • Platform Support - The Python connector is available for Windows 32-bit and 64-bit, macOS 64-bit, and Linux 64-bit.
  • Unicode-Compliant Connector - The Unicode-compliant connector lets you retrieve and update multilingual data, regardless of its character encoding (Chinese, Cyrillic, Hebrew, and more) in any language environment.
  • Data Types Support - The connector supports all SQL Server and Python data types. It offers additional options to control data type mapping between the SQL Server data types and Python data types.