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.
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.
Create a new user.
CREATE USER ddw_user IDENTIFIED BY <pass>
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.