Skip to main content

This package includes the Denodo Dialect for SQLAlchemy, which offers an easy way to connect to Denodo databases from SQLAlchemy https://www.sqlalchemy.org/

Denodo documentation and software resources are available at https://community.denodo.com

This dialect supports SQLAlchemy v1.4 and Denodo 7.0 and higher.

Pre-requisites

This dialect requires the following Python modules:
  • SQLAlchemy version 1.4.x. Not compatible with SQLAlchemy 2.0.

  • psycopg2 version 2.7 or higher.

However, these dependencies do not need to be installed because when you install Denodo Dialect for SQLAlchemy both should be installed automatically.

Alternatively, these packages can be manually installed by means of:

pip install sqlalchemy~=1.4.0
pip install psycopg2-binary>=2.7

Important: note also that psycopg2 has its own requirements for installation which need to be satisfied: https://www.psycopg.org/docs/install.html#prerequisites

Installation

The Denodo SQLAlchemy package can be installed from the public PyPI repository using pip:

pip install --upgrade denodo-sqlalchemy

pip automatically installs all required modules.

Usage

To connect to Denodo VDP Server with SQLAlchemy, the following URL pattern can be used:

denodo://<username>:<password>@<host>:<odbcport>/<database>

Metadata

Release files for denodo-sqlalchemy 1.0.6

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for denodo-sqlalchemy 1.0.6
File Size Uploaded
denodo_sqlalchemy-1.0.6.tar.gz 57.5 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for denodo-sqlalchemy 1.0.6
File Interpreter ABI Platform
denodo_sqlalchemy-1.0.6-py3-none-any.whl Python 3 none any Details

Total release size: 129.9 kB

Release files / denodo_sqlalchemy-1.0.6.tar.gz

Download URL denodo_sqlalchemy-1.0.6.tar.gz
Size 57.5 kB
Tags Source
SHA-256 checksum
How to use checksums
32b579f55869376b0fc580017be40c7101900ca5d7a5a8838eeb7d4b8fd36c80
BLAKE2b-256 checksum
How to use checksums
99dfac9d0b52090c01849210b59bb0c448a9db7b90996379b1b11af7d8949b79
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.1.1 CPython/3.10.12

Release files / denodo_sqlalchemy-1.0.6-py3-none-any.whl

Download URL denodo_sqlalchemy-1.0.6-py3-none-any.whl
Size 72.5 kB
Tags Python 3
SHA-256 checksum
How to use checksums
3acbff10f0bbe4fa1e83b5da1e341797c91ee9b6330a33708a2c2263cf9a7649
BLAKE2b-256 checksum
How to use checksums
7217914983740551bb33260975793e0603f127f914b4ddcd94b3f053d3a086cf
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.1.1 CPython/3.10.12

Release history Release notifications | RSS feed

2.0.5

2 release files

2.0.4

2 release files

2.0.3

2 release files

2.0.2

2 release files

2.0.1

2 release files

2.0.0

2 release files

This release

1.0.6 This release

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page