SQL Server 2014 Columnstore: Released for SAP BW
- This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/SQL-Server-2014-Columnstore-Released-for-SAP-BW/ba-p/367872
- This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html
SAP generally released SQL Server 2014 for SAP NetWeaver two weeks ago as announced in https://blogs.msdn.com/b/saponsqlserver/archive/2015/03/11/sql-server-2014-now-released-by-sap-for-sap-netweaver-7-xx.aspx
As of last week, the SQL Server 2014 In-Memory Optimized Columnstore is generally available for all supported SAP BW releases. The required SAP BW Support Packages are described in detail in https://blogs.msdn.com/b/saponsqlserver/archive/2015/01/08/sql-server-column-store-for-sap-bw-status-and-release-planning.aspx
SQL Server 2014 Columnstore can now be used in three scenarios within SAP BW:
- Read-Only Columnstore on the e-fact table of SAP BW cubes and aggregates in BW 7.x
- Writeable Columnstore on f-fact and e-fact table of SAP BW cubes and aggregates in BW 7.x
- Columnstore Optimized Flat Cube in BW 7.4
The documentation for the Columnstore in SAP BW is available at https://scn.sap.com/docs/DOC-62873 and here:
The documentation for the Columnstore Optimized Flat Cube is available at https://scn.sap.com/docs/DOC-63091 and here: