Adding Microsoft SQL Server Data Warehouses
Microsoft SQL Server is a data warehouse that contains the tables and views that you want to access as cube facts and dimensions. It also contains aggregate-table instances that either you or the AtScale engine creates in a schema that you specify.
info
Attention
- To configure a MSSQL Data Warehouse, you must have a special AtScale license. Ask your sales representative about obtaining a MSSQL-enabled license.
- Microsoft supports database compatibility levels. The compatibility level is the version of SQL Server that your database uses. AtScale supports SQL Server Version 2016 and above which starts at compatibility level 130. Support for Azure Database starts at compatibility level 130 as well.
- Microsoft SQL Server does not support POSIX Regular Expressions. Inbound queries that specify POSIX Regular Expressions, such as the Hive RLIKE function generated by some Tableau text filters, are not supported when connected to MS SQL Server.
Before you begin
- Ensure that your user ID in the Design Center is assigned the Super User role or is assigned the Manage Data Warehouses role permission.
- Aggregate Schema: Ensure that you know the schema to use for aggregate tables to be built in the data warehouse. AtScale creates tables, drops tables, and reads and writes aggregate data to this schema.