DataZen is Officially Dead, Customers Need to Transition to SQL 2016

Microsoft has officially killed the independent DataZen product stack with most of its features now incorporated into SQL Server 2016, SQL Server Reporting Services and Power BI.

Customers will be given 1 year of support following the release of SQL Server 2016 and then the product will be considered end of life. 

To offer Datazen customers more time to plan on when to transition to SQL Server 2016 Reporting Services Microsoft will provide support for existing deployments of Datazen-branded products for 1 year following the SQL Server 2016 GA release.

Our team is actively working on the SQL Server Migration Assistant for Datazen which will help customers in migrating content from Datazen Server 3.0 to SSRS 2016. We plan to release the Migration Assistant shortly after general availability of SQL Server 2016.

Read More

New SQL Server 2016 RC1 Released with SSRS Updates

Microsoft has just released RC1 of SQL Server 2016 and with it a number of SSRS enhancements.  Here are a few of the key updates to reporting services – see this blog post for the full list of enhancements.

Web Portal Replaces Report Manager

Leveraging the DataZen technology the acquired, Microsoft has been working on a new modern HTML 5 based web portal for displaying dashboards and reports.  It is now “feature complete” and replaces the old report manager.

image

One of the latest features in RC1 is search – you can enter in a query and be provided all the KPIs, reports and dashboards matching the search terms.

New Custom Branding

The new Web Portal can be branded to reflect your organization’s fonts, colours and logo. 

image

Easy Embedding of Reports into other Apps

All reports are now embeddable through an IFrame – for example, in order to embed into a SharePoint page.  You just add the rs:Embed=true query parameter to the end of the URL and it will strip away all of the SSRS chrome to make it optimized for inserting into another page.

Newly Modern Paginated Reports

SSRS reports no longer need to look like they were created in the mid-90s!  Styling is now much easier and is now modern design by default. 

Read More

Vision for Microsoft Business Intelligence Starting to be Integrated with SQL 2016

Over the past several years, MIcrosoft has had several reporting and business intelligence streams working somewhat in siloes – we have currently DataZen, Power BI, Excel Services, Power View, SSRS and various other dashboarding components in Microsoft’s other products (Visio, CRM, SharePoint, etc.).  Each tool provides different benefits and is targeted to different audiences.

With the latest announcements about SQL Server 2016, Microsoft is starting to provide a more cohesive and integrated vision that integrates their various reporting tools into a common platform.  Some of these key changes were announced at PASS this week and others have already been released as part of CTM versions of SQL Server 2016.

Power BI for the Cloud, SSRS for On Premise

Power BI will continue to be a 100% dedicated cloud service but SQL Server Reporting Services is being revamped to be the equivalent platform on premise.   You will be able to build SSRS reports and deploy them to Power BI and develop Power BI and publish them to SSRS.

SSRS will be Responsive

The new version of SSRS will be designed for responsive to support HTML 5 based browsers on phones and tablets.

One Mobile App for BI

Microsoft is going to provide a unified mobile experience based on DataZen technologies.  The mobile app will be able to deliver both Power BI and SSRS reports and dashboards through a single user experience.

Read More