Python Connector for Oracle について

PythonアプリケーションからOracleデータベースサーバーおよびマネージドデータベースサービスにアクセスして、保存されたデータに対して作成、読み取り、更新、および削除操作を実行

Python Connector for Oracle is a reliable connectivity solution for accessing Oracle database servers and managed database services 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 Oracle Features

  • Direct Connection - The solution enables you to establish a direct connection to Oracle Database or Oracle Database Cloud Service through TCP/IP, eliminating the need for Oracle Client. A direct connection increases the speed of data transmission between a Python application and an Oracle server.
  • High Performance - The connector supports a direct connection to Oracle Database through TCP/IP without Oracle Client. 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 install Oracle Client on every workstation since this connector supports a direct connection.
  • Secure Communication - The connector supports encrypted communication between the Oracle database server 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 Oracle and Python data types. It offers additional options to control data type mapping between the Oracle data types and Python data types.