About Collectors
Pre-requisites
Collector Server Minimum Requirements
Oracle Analytics Requirements
-
Access to Oracle Analytics
Step 1: Establish Oracle Analytics Access
Create an Oracle user with read access to following tables: dba_hist_active_sess_history, dba_hist_snapshot, dba_users, dba_hist_sqltext, dba_col_comments, dba_tab_columns, dba_audit_trail
You have the option to create a wallet if you are using Oracle Cloud for authentication, otherwise username and password will suffice.
You can connect 3 ways: 1) Host/servicename 2) TNSNAME in the tnsnames.ora file 3) A connection descriptor
Step 2: Create the Source in K
Create an Oracle Analytics source in K
-
Go to Settings, Select Sources and click Add Source
-
Select "Load from File system" option
-
Give the source a Name - e.g. Oracle Analytics Production
-
Add the Host name for the Oracle Analytics Server
-
Click Finish Setup
Step 3: Getting Access to the Source Landing Directory
Step 4: Install the Collector
Run the following commands to install the collector:
pip install kada_collectors_extractors_<version>-none-any.whl
pip install kada_collectors_lib-<version>-none-any.whl