Databases and data warehouses
SAP (Sybase) ASE
Long-running Sybase estates are often the least documented part of a bank. Solidatus reads them automatically and gives you column-level lineage without a manual discovery exercise.
What it is
Structure and column-level lineage capture from SAP ASE, formerly Sybase ASE.
What Solidatus captures
Schemas, tables, temporary tables, views, columns, data types, key constraints, and view and script column-level lineage.
What you need
- A server-level login mapped to a user in each database that needs to be read. In ASE a login must be mapped per database.
- If the default public group permissions have been tightened, EXECUTE on the sp_jdbc_ procedures plus sp_help and sp_pkeys in sybsystemprocs, and SELECT on SYSOBJECTS, SYSUSERS, SYSCOLUMNS, SYSCOMMENTS, SYSINDEXES and SYSCONSTRAINTS.
Good to know
The grants cover the data dictionary only, never row data, which keeps security teams comfortable. Agent and Standalone mode and SOL.UIDs are both supported.
