Skip to main content

Denodo Dialect for SQLAlchemy

Project description

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>

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

denodo_sqlalchemy-1.0.6.tar.gz (57.5 kB view hashes)

Uploaded Source

Built Distribution

denodo_sqlalchemy-1.0.6-py3-none-any.whl (72.5 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page