Database

How to perform an Update operation in Leapwork using a Database Block?

Introduction There are various scenarios where a user wants to connect to any database (using DSN) in order to validate the data getting stored in the database. There are scenarios where you need to insert data into a database through automation. You can achieve this scenario by executing different database commands using Leapwork's...

How to perform Select Query operation in Leapwork using a Database Block?

Introduction There are various scenarios where a user wants to connect to any database (using DSN) in order to validate the data getting stored in the database. Moreover, there are scenarios where a user needs to insert data into the database through automation. In this article, we will be talking about how we can achieve these scenarios...

How to perform CRUD operations using Database block in Leapwork

Introduction While performing the back-end testing using the Databases, the most common operations performed over the databases are Create, Read, Update and Delete which are often acronym as CRUD operations. In Leapwork, users can perform these operations and manipulate the databases using the Database building block in Leapwork. Note:...

Accessing an Oracle database with Leapwork using ODBC

Introduction If you want to use the ODBC based Database block in a Leapwork flow to access an Oracle database, you typically have to run through a few steps to make it work. In the following article, you will learn how to connect a test case in a Leapwork installation with a cloud-based instance of an Oracle database. Prerequisites ODBC...

Access SQL-Database via ODBC driver in Leapwork

Introduction This article includes steps to configure ODBC Driver for SQL SERVER Database. Prerequisites ODBC driver with 64-bit version must be installed on your system (install AccessDatabaseEngine_X64.exe from here). You must be able to access SQL database either by windows authentication or by SQL username and password. Configure...

How to access MongoDB using database building block in Leapwork?

Introduction In Leapwork, users can access MongoDB using a Database building block in Leapwork. To do so, users have to run through a few steps to make it work. Prerequisites Make sure that the MongoDB ODBC driver has been already installed on the machine before configuring the ODBC connection corresponding to MongoDB (to install the ODBC...

I am getting error "Can not execute query" while using Database block

Introduction While using a database block, the user may get an Error Message " Can not execute query ". There can be multiple reasons for this error message. Let's have a look at below scenarios and their resolution. Resolution Scenario 1: User has not configured DSN properly. This can happen if the DSN is not configured as recommended....

Accessing Excel via ODBC driver in Leapwork

Introduction In this article, you will learn the process of configuring the ODBC driver for Excel so as to enable users to Read, Insert, or Update data in Excel through Leapwork. Below are the detailed steps to set up the ODBC driver for interaction with your Excel database. Note : Please note that Leapwork Studio, ODBC Driver, and...