Monday, August 31, 2015

What is a UDL and what advantages does it have?

Universal Data Link defines a data source. Advantages are portability, so that moving packages from environments is easier since data source information is stored in the UDL on each machine. For UDLs should you use Windows or SQL Server authentication? Since the UDL is an unencrypted text file you should use Windows Authentication otherwise the stored password is not secure.

No comments:

Post a Comment