9.4. Summary
When you read SQL Server Reporting Services 2008 documentation and books online, it's recommended to use Business Intelligence Development Studio to deploy your reporting files. The issue is that people who are responsible for deployment are not necessarily developers and may not know how to use Visual Studio IDE. One might argue that they can be educated, but the second issue is that a lot of customers do not allow the installation of Visual Studio on their production environments. Directly uploading reports and data sources is not proper publishing, and in the case of data sources, it is not going to work.
To provide a custom deployment experience, this chapter demonstrated two options for automating the deployment of your reports and data sources to an instance of report server configured in SharePoint integrated mode. One option was by leveraging PowerShell scripting language, and the other option was to utilize Windows SharePoint Services 3.0 built-in packaging and deployment capability via solution and feature frameworks. In addition, this chapter demonstrated how developers can consume Reporting Services APIs via proxy endpoints installed as part of the integration Add-in.
Get Professional Microsoft® SharePoint® Server 2007 Reporting with SQL Server 2008 Reporting Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
