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
| Tool | Connection Type | Client Driver |
|---|---|---|
| Tableau Desktop 2022.41 | Thrift SQL | * See Vendor Drivers |
| Tableau Desktop and Server 2022.3 | Thrift SQL | * See Vendor Drivers |
| Tableau Desktop 2022.2 | Thrift SQL | * See Vendor Drivers |
| Tableau Desktop and Server 2022.1 | Thrift SQL | * See Vendor Drivers |
| Tableau Desktop and Server 2021.4 | Thrift SQL | * See Vendor Drivers |
1 Beta support
Excel / Power BI
| Tool | Connection Type | Client Driver |
|---|---|---|
| Excel 2019 | XMLA | Embedded SQL Server Analysis Services |
| Excel 2021 | XMLA | Embedded SQL Server Analysis Services |
| Excel 365 | XMLA | Embedded SQL Server Analysis Services |
| Power BI Desktop, December 2022 Update | 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 22.20 | Thrift SQL | Embedded 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
| Platform | Interactive Engines | Agg Build Engines | HLL/Portable | NTILE/Portable | TLS | KRB | PWD | Imp | Custom Auth | Part |
|---|---|---|---|---|---|---|---|---|---|---|
| HDP 2.6.51 | Spark 2.3 | Hive 1.2.1, Spark 2.3 | x | x | x | x | x | x | ||
| CDP 7.1.x11 | Impala 3.4.011, Livy | Hive, Impala 3.4.0 | x | x | x | x | x | x | x | |
| HPE Ezmeral Data Fabric 6.25 (MAPR), EEP 8.0, 8.18 (MEP) | Spark 2.4 | Hive 2.3, Spark 2.3 (Customer-Managed UDAF Required)5 | x | x | x | x | x | x6 | x | |
| GBQ | GBQ | GBQ | x10 | x10 | x | x | x | x | ||
| PostgreSQL 147 | Postgres | Postgres | x | x | x | |||||
| Redshift | Redshift | Redshift | x10 | x10 | x | x | x | |||
| Snowflake | Snowflake | Snowflake | x10 | x10 | 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 | |
| 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 | ||||
| IBM Db2 11.1 R2, 11.5 | Db2 | Db2 | x | x | x | x | ||||
| Databricks Spark 9.1 | Databricks | Databricks | x | x | x | x | x | |||
| Databricks SQL | Databricks | Databricks | x10 | x10 | x | x | x | |||
| InterSystems IRIS 2021.2 | InterSystems IRIS | InterSystems IRIS | x | x | x | |||||
| Starburst 360-e12 | Starburst | Starburst |
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 |
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 Term | Description |
|---|---|
| ADLS | Azure Data Lake Storage (Gen 1) |
| 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:
- 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.