Connecting to JSON

For information on the available WHL and TAR.GZ 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 JSON can be installed and used in Python versions 3.9, 3.10, 3.11, 3.12 and 3.13.

JSON Version Support

The connector models local and remote JSON data sources as bidirectional tables. These can be local JSON files or remote JSON streams: RESTful APIs or file stores hosted on FTP servers or popular cloud storage providers. The connector abstracts processing JSON data and connecting to the remote data: HTTP/FTP, SSL/TLS, and authentication: The major authentication schemes are supported, including HTTP Basic, Digest, FTP, NTLM, and OAuth.

See Also

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