Data Driven

Insert, Read or Update data in Excel Files

Introduction Users can perform operations to Read/Insert/Update data in files through Leapwork with the help of the "Database" block. However, there are certain pre-requisites for using a Database block. For pre-requisites, see article: Accessing Excel via ODBC driver in Leapwork . The two input fields viz. Connection & Query are the...

How to update data in already selected Excel file

Introduction Leapwork allows users to perform Data driven testing using the Excel block, it's very easy to add an excel file using the "Read Excel" block, however, users must understand the below scenarios using which users can update the content of already used excel files. Scenario 1 : User selects Data File and defines a Range When a...

What is the difference between System DSN, User DSN, and File DSN when working with Open Database Connectivity (OBDC)?

Introduction When working with the Database building block in Leapwork, users need to create a database connection. A common question is how to choose between a System DSN, User DSN, or File DSN when configuring a database connection. ODBC DSN An ODBC DSN holds the following information to configure an ODBC driver for use. Database...

How to use a Database block

Introduction Leapwork allows the users to connect to any database which supports the Open Database Connectivity (ODBC) interface by Microsoft. The ODBC allows applications to access data in database management systems (DBMS) using SQL as a standard for accessing the data with the help of the "Database" block. Perform Operations in a...

Where to host an Excel file while running flows in the Agent machine?

When running test cases on remote machines with the help of the Leapwork Agent, It is sometimes confusing where to keep the excel sheet that's used as a data source. There are two ways to handle this situation: 1. Keep the data file in a shared location that is accessible to all. The screenshot below shows the path of the shared drive...