How to configure ODBC client to collect from Oracle DB instances
To collect log events from a Oracle database audit table, the following prerequisits must be met:
1) Download instantclient-basic-nt-12.2.0.1.0.zip and instantclient-odbc-nt-12.2.0.1.0.zip
2) Extract both archives to C:\instantclient_12_2
3) Open CMD Command Prompt as Administrator
4) Run odbc_install.exe
5) Open Computer Proprieties
6) Go to Advanced system settings
7) Open Environment Variables
8) In System Variables edit/add TNS_ADMIN with value: C:\instantclient_12_2
9) In Path tab add C:\instantclient_12_2
10) Install Microsoft Visual C++ 2013 X86 Redistributable 12.0.40660
11) Create file tnsnames.ora in folder C:\instantclient_12_2 and edit it with TNS Instance setting
dbInstance=
(description=
(address_list=
(address = (protocol = TCP) (host=)(port=))
)
(connect_data=
(service_name= dbInstance)
)
)
12) Navigate to C:\Windows\SysWOW64 and run odbcad32.exe
13) Setup as shown below