Updated: November 27, 2023 (September 29, 2019)

SQL Server 2019 BI and Data Integration

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

SQL Server 2019 BI and integration will interest only customers with legacy multi-dimensional models or customers adopting Power BI and Azure hosted services.
Limited updates and competing capabilities could lead customers away from Integration Services.

SQL Server 2019, expected in late 2019, will likely only appeal to business intelligence (BI) customers who need to migrate away from legacy Analysis Services multi-dimensional workloads or have plans to deploy hybrid environments, leveraging Power BI and other Azure services. Unlike other SQL Server 2019 updates, the BI changes, which include cancelling plans to add BI services to SQL Server for Linux, highlight Microsoft’s desire to move customers to hosted services.

BI and Integration Services Overview

SQL Server provides three services that deliver BI and data integration capabilities. These services can be deployed separately or together to provide a complete data transformation and BI solution.

These on-premises services have matching hosted services and products that are mostly compatible with their on-premises counterparts but are updated more frequently and receive features that are not made available on-premises.

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now