SQL Server 2016
The new SQL Server version integrates analysis into transactional databases.
Until recently, the worlds of OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) were detached – a typical scenario wpould be the “normal” database and the cubes, which were using a separate data store. SQL Server 2016 is an HTAP (Hybrid Transactional and Analytical Processing) database system and enables fast analyses, directly on the transactions, in real-time.
The new SQL Server Version was developed in a close collaboration with the team for the new Microsoft Dynamics AX.
Therefore, it is hardly surprising that the Microsoft SQL Server Blog uses the ERP system Microsoft Dynamics AX as an example of how applications can benefit from the new possibilities, in their SQL Server 2016 release announcement:
“Eliminating the need to move data out of the database for analytics dramatically reduces the latency for insights. For example, Microsoft Dynamics AX, a cloud-scale online ERP offering, gains real-time insights by using a non-clustered columnstore index on their transactional tables to reduce aggregation latency from hours to seconds.”
By the way: The availability of SQL Server 2016 is also a very important step towards the availability of the on-premises version of the new Microsoft Dynamics AX!
Microsoft Dynamics AX 2012 customers using SQL Server 2014 can benefit from Microsoft’s continued development efforts as well – since a few days, AX can be connected with a so-called Entity Store. This makes is possible to create analyses, dashboards, etc… in PowerBI for Microsoft Dynamics AX 2012 in a native way, with near-real-time data, based on a database with in-memory clustered columnstore indexes.
The Dynamics AX Business Intelligence Blog gives a technical overview on the new functionality – again, we are looking forward to your questions!