Virtual Stored Procedures

Data services allow reporting tools to take advantage of data and security models. Because reporting tools traditionally report on relational data, an extension is included that allows data to be accessed as a client of an OLE DB Provider. The data is accessed through virtual stored procedures, which show up in your reporting tool as stored procedures. This solution requires that the OLE DB Provider be installed on any client machine that is used for reporting.

When calling these stored procedures, you must supply your user name and password along with the name of your database connection stored in the web.config file on the application server.