Connect Katalon Studio to Oracle Wallet

Oracle Wallet is a method to manage database credentials across multiple domains. Connecting to Oracle databases using a Cloud Wallet is a secure method that leverages Oracle security features for accessing authentication and user credentials.

To incorporate Oracle Wallet for data-driven testing with Katalon Studio, do as follows:

1. Go to JDBC and UCP Downloads page | Oracle Sverige and download the Oracle JDBC Driver and Universal Connection Pool (UCP) .jar files that are compatible with your Katalon Studio version:
   • if you use version 9.0.0 onwards, download orajdbc11.jar and ucp11.jar
   • if you use version 8.x, download orajdbc8.jar and ucp.jar
2. Add them to Library Management and exclude the current Oracle JDBC library. For detailed instructions, see Add and exclude libraries.
   
3. Open the katalon.ini file in a text editor. To locate the file:
   • On macOS: Right-click on the Katalon Studio application and choose Show Package Contents. Then, go to Contents > Eclipse > katalonc.ini. The file path should be: /Applications/Katalon Studio Arm64/Contents/Eclipse/katalon.ini
   • On Windows: Open the folder that contains Katalon Studio application. For example: C:\Users\<username>\Downloads\Katalon_Studio_Windows_64-8.6.9\katalon.ini
4. In the katalon.ini file, do the following:
   1. Input the Oracle TCPS connection java options in the katalon.ini file.
   2. Input the tnsnames.ora file and sqlnet.ora file in KS lib directory and point the TNS_ADMIN variable to this location. The TNS_ADMIN variable is set in the java options in substep (a).
5. In Project Settings > Execution > Launch Arguments, use the same -Doracle arguments as in the katalon.ini file. This is used during testing projects.
   
6. Restart Katalon Studio.
7. Use the TNS Alias name for the database connection and test the connection.