How to use a Database block

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

Users can perform operations to Create, Read, Update or Delete data (CRUD Operations) in a database such as SQL, Oracle, MongoDB etc. Users can perform INSERT, READ or UPDATE data operations in Excel files also when a DSN is configured for the corresponding Excel file. Users can't run a DELETE statement in Excel as the DELETE statement is not supported for the Microsoft Excel or Text driver.

Read the below articles for working with different data sources/database.

Excel - https://support.leapwork.com/hc/en-us/articles/360000704592-Accessing-Excel-via-ODBC-driver-in-LEAPWORK

SQL - https://support.leapwork.com/hc/en-us/articles/360000006451-Access-SQL-Database-via-ODBC-driver-in-LEAPWORK

Oracle - https://support.leapwork.com/hc/en-us/articles/360005115111-Accessing-an-Oracle-database-with-LEAPWORK-using-ODBC

Please note that Leapwork Studio, ODBC Driver and Database all 3 software should run under the same bit version. i.e if you have 64-bit Leapwork please install ODBC Driver and database also of the 64-bit version. And if Leapwork Studio is 32-bit, install the 32-bit version of ODBC Driver and database. 

Basically, an ODBC driver is, typically, a dynamic link library (DLL) which is loaded by its parent application. You absolutely cannot mix 32bit application and 64bit driver (or vice-versa). All executables, DLLs, etc that share the same process space must be the same bit'ness.

For any clarification, please contact our Priority Support.