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 ODBC

Open 64-bit ODBC App in your system.
Click Add.
Select SQL Server (as shown below) and click Finish.
Enter a logical name for ODBC data source, Name is used in database block as "Connection" while accessing the database from Leapwork.
Enter meaningful description. Select the database server you want to connect with, afterward click Finish.
Now next screen is meant for authentication, there can be two scenarios here:

Scenario 1: With Windows NT authentication using network login ID, if you can access your SQL server with your windows credentials (without entering other username and password) then you need to use this option.

Note: If you choose this option then "Connection" in Leapwork database block should be defined as “ SQL-DB” (as defined in step no 4 above. Please remember there should be No spaces in the before and after connection string).

Scenario 2: With SQL Server authentication using a login ID and password entered by the user, if you require a username and password to access SQL then you need to use this option.

Note: If you choose this option then the database connection in Leapwork should be defined as “ DSN=TestEnvironment;Uid=UserName; PWD=for_defined_user;”

After selecting Authentication choose the database you want to interact with this ODBC connection as shown below (attach database filename in case it is required) and press next.
Click Finish to complete the process.
After pressing Finish user will see below screen. Press "Test Data Source" to test the connection.
"TEST COMPLETED SUCCESSFULLY!!" message shown below shows that you are ready with connectivity.
Click OK. You are ready to access the database using Leapwork.

If you have any questions, please reach out to our Priority Support team.