MDGP 2013 Feature of the Day: Multitenant SQL Server Reporting Services Reports

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The forty fourth feature they’ve announced is Multitenant SQL Server Reporting Services Reports.

The current version of Microsoft Dynamics GP only supports a dedicated instance of SQL Server Reporting Services for each Microsoft Dynamics GP data instance. With the introduction of the Multi-tenant System Database Architecture, the SQL Server Reporting Services needed to be updated to allow for similar functionality.

With this Multi-tenant SQL Server Reporting Services Reports feature, multiple data instances can be deployed to a single SQL Server Reporting Services instance by allowing the implementer to to deploy the reports to a “tenant” folder.

This folder will be controlled by the reporting administrator only giving the customer access to their reports in the “tenant” folder.

The diagram below shows the current requirements for a dedicated SQL Server Reporting Server instance per data instance;

In this second diagram the multi-tenant functionality shows that only a single instance of SQL Server Reporting Server is required for multiple data instances in Microsoft Dynamics GP;

This screenshot shows the deployment window in the Microsoft Dynamics GP setup utility where the type and location of the Reporting Server is specified on installation. There is now an additional field for the “tenant” folder in the Reporting Server;

This new feature is targeted at the following roles:

• System Implementer
• Business System Developer

Learning script available for download.