AtScale Supported Tools and Platforms

Supported Business Intelligence Tools

Excel and Power BI contain the required drivers. SQL tools such as Tableau must use one of the supported Hive drivers listed below. AtScale requires a Hive driver because it emulates the Hive SQL interface.

For more information, see Connecting to AtScale from business intelligence software.

Tableau

Tool	Connection Type	Client Driver
Tableau Desktop 2023.3	Thrift SQL	* See Vendor Drivers
Tableau Desktop 2023.2	Thrift SQL	* See Vendor Drivers
Tableau Desktop 2023.1	Thrift SQL	* See Vendor Drivers
Tableau Server 2023.3	Thrift SQL	* See Vendor Drivers
Tableau Server 2023.1	Thrift SQL	* See Vendor Drivers
Tableau Cloud ¹	Thrift SQL	* See Vendor Drivers

¹ With Tableau Bridge

Excel / Power BI

Tool	Connection Type	Client Driver
Excel 2021	XMLA	Embedded SQL Server Analysis Services
Excel 2019	XMLA	Embedded SQL Server Analysis Services
Excel 365	XMLA	Embedded SQL Server Analysis Services
Power BI Desktop, February 2024	XMLA, DAX, Live Connection	SQL Server Analysis Services database
Power BI Service	XMLA, DAX, Live Connection	SQL Server Analysis Services database

Looker

Tool	Connection Type	Client Driver
Looker 24.2	PostgreSQL Connector	Embedded PostgresSQL Driver

Microstrategy

AtScale offers Beta support for MicroStrategy. Official support is planned for future releases. If interested in beta testing, please contact your Account Executive.

Qlik

Tool	Connection Type	Client Driver
Qlik Sense Desktop May 2023 Patch 1	Thrift SQL	* See Vendor Drivers

Vendor Drivers

Cloudera ODBC Driver for Apache Hive:
- Tableau 2021.x and 2021.x, tested with Cloudera Hive ODBC Driver 2.6.11 (64-bit)
MapR Hive ODBC Connector 2.01.08.1005
Simba Hive ODBC by AtScale, tested with Tableau 2022.x

Support Definitions

Supported
Defined as the maintenance of a test suite that exercises the tool's core reporting features with AtScale. Some features may not be supported for reasons that include: a) the feature may not apply to an OLAP data model, b) AtScale has a different method of solving the same problem, c) the feature may not be a visualization feature, d) the feature has yet to be implemented.
Beta Support
Means that there are no known blocking issues, however complete testing of all supported features is not complete.
Unsupported Tools
The following BI tools have basic connection and query support, however they are not fully supported: Business Objects, Cognos, Saiku, Spotfire.
Experimental Tools
AtScale has experimental support for Qlik. To use Qlik with AtScale, you must have a special AtScale license. Ask your sales representative about obtaining a Qlik-enabled license.
Deprecated
Functionality will not be removed from AtScale for the period of time specified in the Support Policy. However no further bug fixes or enhancements will be scheduled for this feature. It is strongly recommended that customers retire or migrate reports that depend on deprecated functionality as soon as possible.

Data Catalogs

Alation 2023.3.3
Collibra 2023.09

For more information, see Data Catalog API.

Directory Services

Windows Active Directory 2012 (Supports Kerberos authentication protocol)
Google Directory Service (NOTE: Does not support Kerberos, which is required for Tableau Single Sign-on)
LDAP 2 compatible directory service providers

Data Warehouse Support Matrix

Platform	Interactive Engines	Agg Build Engines	HLL/Portable	NTILE/Portable	TLS	KRB	PWD	Imp	Custom Auth	Part
Azure SQL Server	Engine Compatibility in Version 130 (and above)	Engine Compatibility in Version 130 (and above)	x	x	x	x	x	x		x
Azure Synapse	Engine Compatibility in Version 130 (and above)	Engine Compatibility in Version 130 (and above)			x		x	x		x
CDP 7.1.9¹¹	Impala 3.4.0¹¹, Livy	Hive, Impala 3.4.0	x	x	x	x	x	x		x
Databricks SQL	Databricks	Databricks	x¹⁰	x¹⁰	x		x			x
Databricks Spark 9.1	Databricks	Databricks	x	x	x		x			x
GBQ	GBQ	GBQ	x¹⁰	x¹⁰	x			x	x	x
HPE Ezmeral Data Fabric 6.2⁵ (MAPR), EEP 8.0, 8.1⁸ (MEP)	Spark 2.4	Hive 2.3, Spark 2.3 (Customer-Managed UDAF Required)⁵	x	x	x	x	x	x⁶		x
IBM 11.5	Db2	Db2	x		x		x			x
InterSystems IRIS 2022.3	InterSystems IRIS	InterSystems IRIS	x		x		x
PostgreSQL 14⁷	Postgres	Postgres	x		x		x
Redshift	Redshift	Redshift	x¹⁰	x¹⁰	x		x		x
SQL Server 2016 (and above)	Engine Compatibility in Version 130 (and above)	Engine Compatibility in Version 130 (and above)	x	x	x	x	x	x		x
Snowflake	Snowflake	Snowflake	x¹⁰	x¹⁰	x		x			x

For more information, see Adding Data Warehouses.

Data Warehouse Support Matrix Column Key

Column	Description
HLL	HyperLogLog - Support for Estimated Count Distinct
NTILE	Support for Quantiles
TLS	Transport Layer Security
KRB	Kerberos Authentication Protocol
PWD	Username and Password based authentication
Imp	Impersonation - Proxy user query execution on behalf of another user
Custom Auth	Custom authentication mechanism, platform specific
Part	Partitioned Aggregate Table support

Note

A "secured" platform is a platform with Kerberos, TLS, and Impersonation compatibility.

Notes

⁵ Customer-Managed UDAF Installation: Only Customer-Managed UDAF installation is supported for these platforms. See Customer-Managed UDAF Installation for more information.

⁶ Secure MapR Connections: Requires the MapR Client. AtScale must be installed on MapR client hosts when connecting to secure MapR clusters. For Hadoop platforms, it is required that the platform be configured to use Storage-Based Authorization.

⁷ PostgreSQL NUMERIC Data Type: AtScale does not support the NUMERIC(p,s), aka DECIMAL(p,s), data type on the PostgreSQL database.

⁸ MapR Ecosystem Pack (MEP): Provides a set of ecosystem components that work together on one or more MapR cluster versions. One version of Spark and one Version of Hive is supported in a MEP.

¹⁰ This platform takes advantage of native functions for HLL and NTILE, and does not support AtScale sketch. Therefore it cannot be a source or target for preferred aggregate storage or virtualized aggregates.

¹¹ If upgrading from HDP using Hive LLAP, note that CDP 7.1 requires configuring Impala to process Aggregate Build workloads.

Additional Data Warehouse Support Matrix Terms

Data Warehouse Support Matrix Term	Description
ADLS	Azure Data Lake Storage (Gen 2)
Azure	Microsoft Azure compute cloud
CDP	Cloudera Data Platform
Databricks	Databricks
GBQ	Google BigQuery
GSuite	Google GSuite directory service
HDP	Hortonworks Data Platform Distribution
Hive	Vendor distributed Hive sql engine
Impala	Cloudera distributed Impala sql engine
IBM Db2	International Business Machines DB2 RDBMS
MapR	MapR Converged Data Platform
On-prem	On-premise, dedicated hardware installation. On-premise virtual-machine installations are not supported.
PostgreSQL	PostgreSQL Relational Database
Redshift	Amazon AWS Redshift Data Warehouse
Spark	Hortonworks or MAPR distributed Spark SQL engine
Snowflake	Snowflake Cloud Data Warehouse
SQL Server	Microsoft SQL Server
Tableau Svr Impr	Tableau Server Impersonation (aka Tableau Server Single Sign-on)

Certified Web Browser

The only Web browser that the AtScale Design Center is certified for is Google Chrome.

Operating System Support

The following Linux operating systems are officially supported with AtScale I2024.1.2:

CentOS 7 ¹
Red Hat Enterprise Linux (RHEL) 7
Red Hat Enterprise Linux (RHEL) 8
Ubuntu 20.04
Ubuntu 22.04

¹ AtScale installation packages (RPM) for CentOS 7 can also be used on Amazon Linux 2. Consider that this operating system is not officially supported.