Oracle 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.

• Oracle:
  • Version 11, 12, 18, 19, 21 (remote), or
  • Amazon RDS Oracle instance (19c or 21c)
• User having the following rights:
  • CONNECT and SELECT_CATALOG_ROLE privileges

• Connection parameters:

  • Name or IP address of the Oracle database
  • Port on which the Oracle database listens
  • User name
  • User password

  • SID or service name

    • You can run the following queries on the Oracle host machine to identify the SID:

      • select instance from v$thread;

      • select name from v$database;

• Database must be accessible via network
• Manta Flow supports scanning SQL and PL/SQL statements/scripts
• For Oracle 21.1 and earlier: when you use a connection in read-only mode, install the following Oracle patch on the Oracle instance: "30858671 - 18C DBMS_METADATA.GET_DDL FAILED WITH ORA-16000 IN READ ONLY MODE"

Known Unsupported Features

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

• SQL*Plus scripts — See How to Pre-Process Oracle and SQL*Plus Scripts
• SQL*Loader scripts
• Highly dynamic SQL code executed via EXECUTE IMMEDIATE — See How to Handle Dynamic SQL Scripts.
• Synonyms are included in the data lineage visualization only if they are referenced in the SQL queries, procedures, or functions. If they are not referenced, they will not appear in either the flow viewer or the object list.