I am looking for a web part that can be configured to access a SQL database. Instead of just presenting a list of data, I want to be able to have links in the results that allow you to dig deeper with other SQL queries if you click on a particular column in the results. Does anyone know of a web part that allows this functionality? All of the SQL web parts I can find just seem to be able to present a list of data from SQL and that is it.
Also, I assume something like this is possible with BDC? I am licensed for Sharepoint Standard 2010so I dont have a lot of the functionality for that and the Enterprise CALS are really expensive.