Working with Oracle Database in ORQA

ORQA supports interaction with any DB that has a compliant JDBC driver. For Oracle, you’ll need a copy of the Oracle JDBC driver, e.g. ojdbc6.jar. Copy the driver to ./drivers folder in ORQA.

Let’s assume you want to read from an Oracle DB. For that, just create a new task, add “Read from Database” operation from the toolbox and give it the below details:

jdbc:oracle:thin:@myhost:1521/myservicename

Then just run the task, you will get data back from the DB for the select statement you gave.