I have a new project that will need me to create a report for over 20 clients. The problem is that the company's IT team has a separate database for each client. Some of these databases are on separate servers (actually five different ones in total).
I will have to set this app up on 7 different user machines. What is the best way to connect to these databases for easy installation?