Skip to main content

Preparing to run the Oracle collector

Setting up pre-requisites for running the collector

Make sure that the machine from where you are running the collector meets the following hardware and software requirements.

Table 1.

Item

Requirement

Hardware

RAM

8 GB

CPU

2 Ghz processor

Software

Docker

Click here to get Docker.

Java Runtime Environment

OpenJDK 17 is supported and available here.

JDBC Driver

Oracle database 12.1.0.1 JDBC driver available here. The computer should have the appropriate JDBC driver on its file system.

data.world specific objects

Dataset

You must have a ddw-catalogs (or other) dataset set up to hold your catalog files when you are done running the collector.



Setting up permissions

Run the following SQL statements to set up a new user with appropriate permissions to harvest from Oracle.

  1. Create a new user.

    CREATE USER ddw_user IDENTIFIED BY <pass>
  2. Grant permissions to the user.

    GRANT create session, SELECT_CATALOG_ROLE TO ddw_user;
    GRANT SELECT ON "<schemaName>"."<tableName>" TO ddw_user;

Update <schema> and <table_name> for each schema, table, or view you want to harvest.