In this recipe, we will create a report that connects to an Online Transaction Processing (OLTP) datasource and retrieves data through an SQL query. You will learn how to add a generic report datasource that can be used across all reports. The report here will retrieve the employee information from the Adventure Works sample database.
In order to execute this recipe, you will need the Adventure Works database installed in the SQL server. This is available for free to download from Microsoft at http://technet.microsoft.com/en-us/library/ee873271.aspx.