When working with Database building block in Leapwork, users need to create a database connection to work with with the Database. One common question that often puzzles a user is what to choose between a User DSN, System DSN or File DSN while configuring a database connection.
An ODBC DSN holds the following information to configure an ODBC driver for use.
- Database Information
- Connection Information
- A User DSN is only accessible by the user who created it on the workstation.
- A System DSN is accessible by any user logging into the workstation.
- A File DSN is shared between all users that have the same drivers installed. It can be stored on a workstation but can also be placed in a shared directory in a network location.
What is recommended?
A User or System DSN is recommended for consistent performance when using ODBC.
To know learn how to Access SQL-Database via ODBC driver in Leapwork, click here
For any clarification, please contact our Priority Support.