About Collectors
Pre-requisites
-
Python 3.6 - 3.10
-
Access to Oracle
Oracle Access
Create an Oracle user with read access to the following tables: dba_hist_active_sess_history, dba_hist_snapshot, dba_users, dba_hist_sqltext, dba_mviews, dba_views, dba_procedures, dba_constraints, dba_cons_columns, dba_tab_columns, dba_audit_trail, dba_tab_privs, dba_role_privs, dba_roles, proxy_users_and_roles, dba_synonyms
You can connect 3 ways: 1) Host/servicename 2) TNSNAME in the tnsnames.ora file 3) A connection descriptor
Step 1: Create the Source in K
Create a Oracle source in K
-
Go to Settings, Select Sources and click Add Source
-
Select "Load from File" option
-
Give the source a Name - e.g. Oracle Production
-
Add the Host name for the Oracle Server
-
Click Finish Setup
Step 2: Getting Access to the Source Landing Directory
Step 3: Install the Collector
Run the following command to install the collector
pip install kada_collectors_extractors_<version>-none-any.whl
pip install kada_collectors_lib-<version>-none-any.whl
Step 4: Configure the Collector
The collector requires parameters to connect to Oracle. Key fields include username, password, dsn, oracle_client_path, oracle_major_version (12c), database_name, host_name, wallet_path, meta_only, output_path, mask, and compress.