We have got a time tracker website in ASP.NET which is used by employees to record their daily time and work. The data is huge (about 10 years of data and ongoing) and stored in the SQL database.
We want to pick up this data from SQL and create reports on the SharePoint site. Please guide for the way to achieve this. I am guessing we need to make a BCS connection to the SQL server database and then how do we show up charts, etc?