To connect Oracle Database through ODBC Driver

Opkey features a built-in database connectivity engine, which facilitates various database operations.    

This article will guide you on how you can connect to Oracle Database through ODBC Driver.  

Follow the below steps for ODBC Configuration for Oracle Database:  

 
Search for ODBC Data Source 64-bit on the Start Menu  

 
Open Run as admin.  

Select the System DSN tab, select Oracle 64-bit platform, and click on the Add button.  

Select Oracle driver and click on Finish. 

On the next window, enter details of Data Source Name, Description, TNS Service Name, and User ID. 

Note: These details will be provided to you by your IT personnel. 

Next, click on Test Connection. 

On the next window enter details of Service Name, Username, Password and click on OK. 

The connection will be successfully established. 

The connection is established successfully.

Now before proceeding with Opkey configurations, we need to create an Oracle password as it doesn't reflect automatically in the connection string.   

To Do So:

Search for the Registry Editor on your system. To keep the registry operational, you need to register the password. Follow the steps below to register the password. 

In Registry Editor, go to : 

HKEY Local Machine >> Software >> ODBC >> ODBC.INI >> Oracle >> 

Scroll down and search for the Password. Right-click and enter the password. 

We need to register the password as Oracle doesn’t allow us to save it. 

Double-click on the Password tab and enter the password to be generated on the pop-up window.

Click OK 

Now go to Opkey create a test case and add two keywords: 

ConnectDataBase 

ExecuteQuery 

For the ConnectDataBase keyword provide data for Driver and Connection String. 

For ExecuteQuery keyword provide details for the Query and Command Timeout.

Execute the test case to verify whether the connection between the database and Opkey is established or not. Click the Run Button and select Execute.  

Enter details of Session Name, Build, and select the Execution Agent. Click on Finish. 

The test case is executed. View the results. 

The query is successfully executed. 

For more such articles on database operations with Opkey, click Here