Oracle OCI offers better performance compared to Oracle ODBC driver especially when access LOB data. When the ETL Validator Client is accessing ETL Validator Repository/Workschema, the performance of the client can be improved by using Oracle OCI driver instead of the ODBC driver.
Below are the steps for setting the Oracle OCI driver and using it from ETL Validator:
- Download the latest version of Oracle Instant Client Basic for Windows 64-bit (eg. instantclient-basic-windows.x64-12.2.0.1.0.zip) from the Oracle website:
http://www.oracle.com/technetwork/topics/winx64soft-089540.html - Unzip the packages into a single directory such as
C:\oracle\instantclient_12_2 - Add this directory to the
PATHenvironment variable. If you have multiple versions of Oracle libraries installed, make sure the new directory occurs first in the path - Modify the repository connection to use OCI driver as shown below
