Skip to main content

SAP ASE (Sybase) for SQLAlchemy

Project description

sqlalchemy-sybase

https://img.shields.io/pypi/dm/sqlalchemy-sybase.svg

SAP ASE (Sybase) dialect for SQLAlchemy.

Objectives

This is a fork of SQLAlchemy’s internal “sybase” dialect which is soon to be deprecated and will be removed from a future release.

Pre-requisites

You will need an ODBC driver for SAP ASE installed on the machine from which you want to connect to the SAP ASE server. This dialect is tested with the SAP ASE ODBC driver (libsybdrvodb-sqllen8.so on Linux).

Also, if you are running on Linux and using unixODBC, check the version via odbcinst -j from a console prompt (or use the odbcinst module). The official repositories of several Linux distributions contain versions of unixODBC that are quite old and somewhat buggy.

Installing

SQLAlchemy and pyodbc are specified as requirements so pip will install them if they are not already in place. To install, just:

pip install sqlalchemy-sybase

Getting Started

Create an ODBC DSN (Data Source Name) that points to your SAP ASE database. Then, in your Python app, you can connect to the database via:

from sqlalchemy import create_engine
engine = create_engine("sybase+pyodbc://scott:tiger@your_dsn")

For other ways of connecting see the Getting Connected page in the Wiki.

The SQLAlchemy Project

sqlalchemy-sybase is affiliated with the SQLAlchemy Project and adheres to the same standards and conventions as the core project.

Development / Bug reporting / Pull requests

Please refer to the SQLAlchemy Community Guide for guidelines on coding and participating in this project.

Code of Conduct

Above all, SQLAlchemy places great emphasis on polite, thoughtful, and constructive communication between users and developers. Please see the current Code of Conduct at Code of Conduct.

License

sqlalchemy-sybase is distributed under the MIT license.

Project details


Download files

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

Files for sqlalchemy-sybase, version 1.0.6
Filename, size File type Python version Upload date Hashes
Filename, size sqlalchemy_sybase-1.0.6-py3-none-any.whl (14.7 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size sqlalchemy-sybase-1.0.6.tar.gz (16.6 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page