Contribute in GitHub:

SAP ASE Integration Requirements

The following are the prerequisites necessary for IBM Manta Data Lineage to connect to this third-party system, which you may choose to do at your sole discretion. Note that while these are usually sufficient to connect to this third-party system, we cannot guarantee that the connection or integration will be successful since we have no control, liability, or responsibility for third-party products or services, including for their performance.

SAP ASE (formerly known as Sybase): version 12, 15, 16, or newer (remote)
jConnect JDBC driver of the corresponding version
The Manta Flow client distribution might not contain SAP ASE JDBC drivers that work with the version of the SAP ASE database you have, or it might not contain the most recent version of those drivers. Check if the file jconn4.jar is present in the directory <MANTA_DIR_HOME>/scenarios/manta-dataflow-xxx-cli/lib-ext in the most recent compatible version. If not, download the most recent compatible version of the JDBC drivers from the SAP website. (https://wiki.scn.sap.com/wiki/display/SYBCON/jConnect+Driver+Overview), remove the old drivers from the lib directory, and place the new drivers there in the form of JAR files.
User having the following rights:
- CONNECT SQL — to connect to the server
- VIEW ANY DATABASE — to extract the list of existing databases
- In each extracted database:
  - VIEW DEFINITION (or VIEW ANY DEFINITION on the server level) — to extract object definitions
Connection parameters:
- Name or IP address of the SAP ASE database
- Port on which the SAP ASE database listens for JDBC connections
- User name
- User password
Database must be accessible via network

Known Unsupported Features

IBM Manta Data Lineage does not support the following SAP ASE features. This list includes all of the features that IBM is aware are unsupported, but it might not be comprehensive.

Lineage through dynamically executed code through EXECUTE IMMEDIATE