Set up database connection for data-driven testing and implementation in Katalon Studio.

Introduction

Hey Readers!!

Have you ever wondered what to do when you want to add external test cases and use them?

In this article, you'll learn about these steps to perform for Setting up a database connection for data-driven testing and implementing it in Katalon Studio.

Now let's begin to explore this.

Introduce database connection​

1. Go to Project > Settings > Database for setting up the global connection of database.

Connect to a database with a built-in driver​

1. Go to Project > Settings > Database. 

2. In Database: Follow these steps, then.

3. Select Secure User and Password.

4. Enter the connection URL, user name and password required for authentication.

5. To check if your Database is connected correctly, click Test Connection.

6. To save your selection, click Apply and Close.

Connect to a database with an external JDBC driver​

1. Download the external JDBC driver's executable.jar file. We've downloaded the MySQL Connector/J jar file from the maven repository.

2. To add the jar file, go to Project > Settings > Library Management and then click Apply.

3. Then go the Project Settings, and then to Database, and fill in the details below:

Firstly select the Secure USER  and PASSWORD.

• User
• Password
• Connection URL

Then click on Test connection to check whether the connection is established successfully or not.

• Click on Apply and Close, and your connection is established.

Must Recommended Topic, Schema in DBMS

Implement data-driven testing with MySQL

Now let's implement data-driven testing with MySQL. To do so, the steps are given below.

Requirements

• Katalon Studio version 8.0.0 onwards. 
• You already set up MyQSL Database. 
• MySQL Database is running.

Download MySQL library​

The MySQL executable.jar file can be downloaded. On the MySQL website, click here to download the MySQL library.

Add an external JDBC driver for MySQL database connection​

1. Go to Project > Settings > Library Management to add the jar file and click Apply.

2. Then go the Project Settings, and then to Database, and fill in the details below:

Firstly select the Secure USER  and PASSWORD.

• User
• Password
• Connection URL

Then click on Test connection to check that the connection is established successfully or Not.

3. Click on Apply and Close, and your connection is established.
Also Read - Cardinality In DBMS