How to perform Database Testing using Katalon Studio

Katalon Studio allows users to create custom keywords to address specific needs. With custom keywords, you can connect to databases and perform database testing. This tutorial describes details on how to create custom keywords for database testing in Katalon Studio.

Below is a code sample demonstrating how to

  • establish a database connection
  • execute a query
  • close  the connection

Tips: Press “Ctrl + Shift + o“ to automatically import missing libraries in test scripts.

The Custom Keywords file will look like the following:

Katalon Custom Keywords

You can add the sample code above to your keyword file and modify the details as appropriated. Refer to these links for the formats of database connection strings:

Use Defined Keywords in Test Cases for DB Testing

1. Create new custom keywords for database connection (see above).

2. Copy the DB script provided above and paste it into the new keyword editor as illustrated below:Katalon Defined Keywords

thumb_up (12) thumb_down (4)

Resolve Git conflicts using Katalon Studio

1. Why do we have Git conflicts? In a source control system like Git, conflicts may occur when two or…

Automation testing of Shadow DOM elements with Katalon Studio

What is Shadow DOM? Shadow DOM is a technique to help web developers to better encapsulate their code. Shadow DOM…

Detecting elements with Xpath in Katalon Studio

Detecting UI elements of the application under test (AUT) is crucial for automation testing since they are the main objects…
Scroll up