Opkey features a built-in database connectivity engine, which facilitates various database operations. Currently, Opkey supports the following databases:
1. MySQL
2. ORACLE
3. SQL SERVER
4. PostgreSQL
5. RedShiftDB
6. SQLite
Pre-Requisites to connect databases.
1. Opkey offers two methods to connect with a database: through ODBC driver or ODAC driver. For the standard approach, users typically connect via ODBC driver. To do so, users must first install the ODBC driver on the agent machine from where the test runs will be executed.
2. Configuring a Data Source Name (DSN) is essential at the system level.
3. Ensure there is connectivity between the agent machine and the machine where the database is hosted. This enables the successful execution of database queries through Opkey keywords.
4. Users must match the version of the database with the version of the driver installed on the agent machine, whether it's ODBC or ODAC drivers.
5. For connecting MySQL databases, we need to install the MySQL connector externally.
ConnectDatabase Keyword in Opkey takes two parameters DriverName and ConnectionString.
Here is the list of databases, their Drivers, and connection strings.
*To establish Oracle Database connectivity, it's essential to install Oracle Data Access Components (compatible ODAC drivers for the installed Oracle version) on the machine from which the user intends to establish the database connection.
For downloading compatible ODAC drivers, please Click here:
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article