Dear Dashboard Architects,
There are requirements at our side that we need to get data directly from MS SQL Server in Dashboard through queries. Is it possible?? If yes then plz help me in which way we can do it.
SAP Dashboard Integration with SAP B1
harshiljoshi.sap 
(BOB member since 2011-08-11)
Yes. Use an XML connection which calls an ASPX script to return the results as XML.
There are sample scripts in this forum. Start here: streamlining coding in aspx pages
This fires SQL at an oracle database but just substitute in the connection string for your SQL Server database.
Debbie
Debbie 
(BOB member since 2005-03-01)
THank You Sir…thank you very much for your reply…
harshiljoshi.sap (BOB member since 2011-08-11)