Skip to content

Scanner for Oracle

Requirements

  • Credentials to connect to Oracle database.
  • To extract metadata, the MySQL user needs to have access to the INFORMATION_SCHEMA.
  • Metadata Scan is supported for 12c, 18c, 19c, and 21c versions.
  • To ingest metadata from oracle user must have CREATE SESSION privilege for the user.

Depot Scan Workflow

DataOS allows you to connect to a database with JDBC driver to read data from tables using Depot. You can also scan metadata from an Oracle-type depot with Scanner workflows.The Depot enables access to all schemas visible to the specified user in the configured database, Oracle.

You can apply database, schema, and table filter patterns while scanning metadata.

version: v1
name: oracle-scanner
type: workflow
tags:
  - oracle-scanner
description: The job scans schema tables and register metadata
workflow:
  dag:
    - name: oracle-scanner
      description: The job scans schema from oracle-scanner tables and register metadata to metis2
      spec:
        tags:
          - scanner
        stack: scanner:2.0
        compute: runnable-default
                runAsUser: metis
        stackSpec:
          depot: oracle01          #depo name/address
          sourceConfig:
            config:
              markDeletedTables: false
              includeTables: true
              includeViews: true
              databaseFilterPattern:
                  includes:
                      - database1
                      - database2
                    excludes:
                      - database3
                      - database4
                  schemaFilterPattern:
                    includes:
                      - schema1
                      - schema2
                    excludes:
                      - schema3
                      - schema4
                  tableFilterPattern:
                    includes:
                      - table1
                      - table2
                    excludes:
                      - table3
                      - table4

After the successful workflow run, you can check the metadata of scanned Tables on Metis UI for all schemas present in the database.

After the successful workflow run, you can check the metadata of scanned Tables on Metis UI.