SAP Sybase

https://www.sap.com/products/technology-platform/sybase-ase.html

SAP ASE (formerly Sybase) is an enterprise relational database.

Installation

Required packages: pymssqlsqlalchemy-sybasepyodbc

Drivers

pymssqlRecommended

pyodbc

PyPI Package: pymssql

mssql+pymssql://{username}:{password}@{host}:{port}/{database}

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 44/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Extended Aggregate Functions

The base aggregates (SUM, COUNT, AVG, MIN, MAX, COUNT DISTINCT) are supported everywhere; these are opt-in per engine.

MEDIANSTDDEV_SAMPVAR_SAMP

Notes

Requires SAP ASE ODBC driver installed and configured as a DSN.

Resources

Official Documentation

Help improve this documentation by editing the engine spec:

Edit sybase.py