.. image:: https://img.shields.io/pypi/dm/sqlalchemy-sybase.svg :target: https://pypi.org/project/sqlalchemy-sybase/
SAP ASE (Sybase) dialect for SQLAlchemy.
The latest version of this dialect requires SQLAlchemy 2.0 or later. To work with earlier versions of SQLAlchemy, do::
pip install sqlalchemy-sybase<2.0.0
This is a fork of SQLAlchemy's internal "sybase" dialect which was deprecated in SQLAlchemy 1.4 and was removed from SQLAlchemy 2.0.
This dialect is tested against SAP ASE version 16. Some features may not work on earlier versions of SAP ASE.
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.
.. _unixODBC: http://www.unixodbc.org/ .. _odbcinst: https://github.com/gordthompson/odbcinst
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
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.
.. _ODBC DSN (Data Source Name): https://support.microsoft.com/en-ca/help/966849/what-is-a-dsn-data-source-name .. _Getting Connected: https://github.com/gordthompson/sqlalchemy-sybase/wiki/Getting-Connected
sqlalchemy-sybase is affiliated with the SQLAlchemy Project <https://www.sqlalchemy.org>_ and
adheres to the same standards and conventions as the core project.
Please refer to the
SQLAlchemy Community Guide <https://www.sqlalchemy.org/develop.html>_ 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 <https://www.sqlalchemy.org/codeofconduct.html>_.
sqlalchemy-sybase is distributed under the MIT license <https://opensource.org/licenses/MIT>_.
FAQs
SAP ASE (Sybase) for SQLAlchemy
We found that sqlalchemy-sybase demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 3 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Research
The Socket Research Team breaks down a malicious wrapper package that uses obfuscation to harvest credentials and exfiltrate sensitive data.
Research
Security News
Attackers used a malicious npm package typosquatting a popular ESLint plugin to steal sensitive data, execute commands, and exploit developer systems.
Security News
The Ultralytics' PyPI Package was compromised four times in one weekend through GitHub Actions cache poisoning and failure to rotate previously compromised API tokens.