Skip to main content

About the Oracle collector

Use this collector to harvest metadata for Oracle tables and columns across the enterprise systems and make it searchable and discoverable in data.world.

Important

The Oracle collector can be run in the Cloud or on-premise using Docker or Jar files.

Note

The latest version of the Collector is 2.189. To view the release notes for this version and all previous versions, please go here.

What is cataloged

The collector catalogs the following information.

Note

The collector harvests all versions of overloaded functions and stored procedures. Each version has its own title/name in the catalog, but a distinct identifier.

Table 1.

Object

Information cataloged

Columns

Name, Description, JDBC type, Column Type, Is Nullable, Default Value, Key type (Primary, Foreign), Column size, Column index

Table

Name, Description, Primary key, Schema

Views

Name, Description, Definitions

Schema

Identifier, Name

Database

Type, Name, Identifier, Server, Port, Environment, JDBC URL

Function

Name, Description, Function Type, Definitions

Stored Procedure

Name, Description, Stored Procedure Type, Definitions



Relationships between objects

By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the data.world Solutions team, you may see other resource pages and relationships.

Table 1.

Resource page

Relationship

Table

Columns

Columns

Table

Schema

Database that contains Schema, Table that is part of Schema

Database

Schema contained in Database



Oracle version supported

  • Oracle database 12.1.0.1 JDBC driver version available here.

Authentication supported

  • The Oracle collector supports username/password authentication to Oracle.