{"id":514,"date":"2016-01-18T10:49:37","date_gmt":"2016-01-18T10:49:37","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=514"},"modified":"2024-05-13T10:31:59","modified_gmt":"2024-05-13T10:31:59","slug":"ssrs-deployment-automation","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/ssrs-deployment-automation\/","title":{"rendered":"SSRS Deployment Automation"},"content":{"rendered":"

SQL Server reporting comes to life when SSRS (SQL Server Reporting Services) runs in\u00a0SharePoint integrated mode<\/h2>\n

Report deployment is a manual process from SQL Server Data Tools within Visual Studio. \u00a0If a report has to go to multiple locations, it can be a hassle to track all the locations and ensure proper deployment and updates.<\/p>\n

Companies often have a wide range of SSDT (SQL Server Data Tool) Solutions that contain reports. These reports today are deployed to SSRS running in Native Mode.<\/p>\n

We have developed a deployment solution to enable a single-stage deployment of reports to SharePoint to the correct and secure location per report.<\/p>\n

This tool facilitates report deployments to multiple locations across multiple VS solutions. It utilizes a single database table that contains the full mapping of Visual Studio reports to all the SharePoint locations each report may be published.<\/p>\n

The report deployment tool is able to run from any location that can connect to both the destination SharePoint and the SQL Server housing the mapping table.<\/p>\n

The tool requires credentials to be able to publish to SharePoint.<\/p>\n

The report deployment tool can be used to deploy and manage report publishing from multiple Visual Studio solutions to multiple SharePoint site collections:<\/p>\n

    \n
  1. Automate SharePoint Location Inventory<\/li>\n
  2. Automated inventory of all SSRS Visual Studio reports across solutions<\/li>\n
  3. Each SharePoint location can have a description associated, as can each report for publishing<\/li>\n
  4. Automatically create libraries and create the views, metadata and add the content types for as many libraries as needed<\/li>\n
  5. Each report can be published in more than one location. Reports can be mapped in bulk<\/li>\n
  6. Update all reports in SharePoint<\/li>\n
  7. Reports in SharePoint need to be rebound to data sources when published. The rebinding can be automatically done for you.<\/li>\n
  8. Define the sequence that reports appear in SharePoint<\/li>\n
  9. Category and Title fields are published automatically to SharePoint<\/li>\n
  10. Creation of libraries and folders fully configured for reports can be done visually within the tool<\/li>\n
  11. Retract or delete a report from all associated locations<\/li>\n<\/ol>\n

    The tool defaults to not overwriting data sources. This is to avoid overwriting credentials entered for use by the data source. A checkbox is available to force the overwriting of data sources.<\/p>\n

    Read More<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    SQL Server reporting comes to life when SSRS (SQL Server Reporting Services) runs in\u00a0SharePoint integrated mode Report deployment is a manual process from SQL Server Data Tools within Visual Studio. \u00a0If a report has to go to multiple locations, it can be a hassle to track all the locations and ensure proper deployment and updates. […]<\/p>\n","protected":false},"author":8,"featured_media":516,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[74,27],"tags":[],"class_list":["post-514","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-enterprise-solutions","category-ssrs"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/514","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=514"}],"version-history":[{"count":7,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/514\/revisions"}],"predecessor-version":[{"id":3940,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/514\/revisions\/3940"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/516"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}