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

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.

Elucidation:

An ODBC DSN holds the following information to configure an ODBC driver for use.

• Database Information
• UserID
• Password
• Connection Information

1. A User DSN is only accessible by the user who created it on the workstation.
2. A System DSN is accessible by any user logging into the workstation.
3. 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 learn how to Access SQL-Database via ODBC driver in Leapwork, click here

For clarification, please contact our Priority Support.