Skip to main content
Version: I2023.1.0

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.

Tableau

ToolConnection TypeClient Driver
Tableau Desktop 2022.41Thrift SQL* See Vendor Drivers
Tableau Desktop and Server 2022.3Thrift SQL* See Vendor Drivers
Tableau Desktop 2022.2Thrift SQL* See Vendor Drivers
Tableau Desktop and Server 2022.1Thrift SQL* See Vendor Drivers
Tableau Desktop and Server 2021.4Thrift SQL* See Vendor Drivers

1 Beta support

Excel / Power BI

ToolConnection TypeClient Driver
Excel 2019XMLAEmbedded SQL Server Analysis Services
Excel 2021XMLAEmbedded SQL Server Analysis Services
Excel 365XMLAEmbedded SQL Server Analysis Services
Power BI Desktop, December 2022 UpdateXMLA, DAX, Live ConnectionSQL Server Analysis Services database
Power BI ServiceXMLA, DAX, Live ConnectionSQL Server Analysis Services database

Looker

ToolConnection TypeClient Driver
Looker 22.20Thrift SQLEmbedded Hive Driver

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: Microstrategy, 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.

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

PlatformInteractive EnginesAgg Build EnginesHLL/PortableNTILE/PortableTLSKRBPWDImpCustom AuthPart
HDP 2.6.51Spark 2.3Hive 1.2.1, Spark 2.3xxxxxx
CDP 7.1.x11Impala 3.4.011, LivyHive, Impala 3.4.0xxxxxxx
HPE Ezmeral Data Fabric 6.25 (MAPR), EEP 8.0, 8.18 (MEP)Spark 2.4Hive 2.3, Spark 2.3 (Customer-Managed UDAF Required)5xxxxxx6x
GBQGBQGBQx10x10xxxx
PostgreSQL 147PostgresPostgresxxx
RedshiftRedshiftRedshiftx10x10xxx
SnowflakeSnowflakeSnowflakex10x10xxx
SQL Server 2016 (and above)Engine Compatibility in Version 130 (and above)Engine Compatibility in Version 130 (and above)xxxxxxx
Azure SQL ServerEngine Compatibility in Version 130 (and above)Engine Compatibility in Version 130 (and above)xxxxxxx
Azure SynapseEngine Compatibility in Version 130 (and above)Engine Compatibility in Version 130 (and above)xxxx
IBM Db2 11.1 R2, 11.5Db2Db2xxxx
Databricks Spark 9.1DatabricksDatabricksxxxxx
Databricks SQLDatabricksDatabricksx10x10xxx
InterSystems IRIS 2021.2InterSystems IRISInterSystems IRISxxx
Starburst 360-e12StarburstStarburst

For more information, see Adding Data Warehouses.

Data Warehouse Support Matrix Column Key

ColumnDescription
HLLHyperLogLog - Support for Estimated Count Distinct
NTILESupport for Quantiles
TLSTransport Layer Security
KRBKerberos Authentication Protocol
PWDUsername and Password based authentication
ImpImpersonation - Proxy user query execution on behalf of another user
Custom AuthCustom authentication mechanism, platform specific
PartPartitioned Aggregate Table support
note

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

Notes

1 HDP Cloud Connectors: HDP Cloud Connectors provide HDP access to cloud file systems such as ADLS, WASB, S3, GCS. These cloud connectors are supported for reading fact and dimension data. The following AtScale features require the HDP cluster to also have an HDFS file system: Aggregate table creation, Aggregate drop file polling, AtScale-managed UDAF .jar installation, Data loader uploads.

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

6 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.

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

8 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.

9 Local aggregates cannot be built on this platform.

10 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.

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

12 AtScale offers Beta support for the Starburst data warehouse. Official support is planned for a next release. If interested in beta testing, please contact your Customer Success Manager.

Additional Data Warehouse Support Matrix Terms

Data Warehouse Support Matrix TermDescription
ADLSAzure Data Lake Storage (Gen 1)
AzureMicrosoft Azure compute cloud
CDPCloudera Data Platform
DatabricksDatabricks
GBQGoogle BigQuery
GSuiteGoogle GSuite directory service
HDPHortonworks Data Platform Distribution
HiveVendor distributed Hive sql engine
ImpalaCloudera distributed Impala sql engine
IBM Db2International Business Machines DB2 RDBMS
MapRMapR Converged Data Platform
On-premOn-premise, dedicated hardware installation. On-premise virtual-machine installations are not supported.
PostgreSQLPostgreSQL Relational Database
RedshiftAmazon AWS Redshift Data Warehouse
SparkHortonworks or MAPR distributed Spark sql engine
SnowflakeSnowflake Cloud Data Warehouse
SQL ServerMicrosoft SQL Server
Tableau Svr ImprTableau 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:

  • CentOS 7 1
  • Red Hat Enterprise Linux (RHEL) 7
  • Red Hat Enterprise Linux (RHEL) 8
  • Ubuntu 18.04
  • Ubuntu 20.04

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