I would like to connect and query some data from MS SQL Server which is running on the local network and show the data on the Xibo player. This may be more than 5 queries at the same time. Is it possible? Any help or suggestions will be highly appreciated. Thanks.
You would need to write an integrator application that connected to your MSSQL database, picked up whatever data you want, and then connects to the Xibo API and loads that data in to a dataset.
You can then use the standard tools inside Xibo to show that content.
Alternatively, if you have an application that can export the data you want from your database and render it as json, you can use the remote datasets feature of Xibo to pick it up automatically and import it in to a dataset that way.