AtScale Supported Tools and Platforms
Container Orchestration
- Kubernetes (requires Helm 3+)
Certified Web Browser
- Google Chrome
External User Management
Identity providers:
- Microsoft Entra ID
- Okta
LDAP vendors:
- Microsoft Active Directory (Supports Kerberos authentication protocol.)
Data Catalogs
- Alation 2023.3.3
- Collibra 2023.09
Data Warehouse Support Matrix
| Platform | Interactive Engines | Agg Build Engines | HLL/Portable | NTILE/Portable | TLS | KRB | PWD | Imp | Custom Auth | Part |
|---|---|---|---|---|---|---|---|---|---|---|
| Databricks SQL | Databricks | Databricks | x1 | x1 | x | x | x | x | ||
| GBQ | GBQ | GBQ | x1 | x1 | x | x | x | x | ||
| Snowflake | Snowflake | Snowflake | x1 | x1 | x | x | x | |||
| InterSystems IRIS 2024.1 | InterSystems IRIS | InterSystems IRIS | x | x | x | |||||
| PostgreSQL 142 | Postgres | Postgres | x | x | x |
1 This platform takes advantage of native functions for HLL and NTILE.
2 PostgreSQL NUMERIC Data Type: AtScale does not support the NUMERIC(p,s), aka DECIMAL(p,s), data type on the PostgreSQL database.
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.
Additional Data Warehouse Support Matrix Terms
| Term | Description |
|---|---|
| Databricks | Databricks |
| GBQ | Google BigQuery |
| Snowflake | Snowflake Cloud Data Warehouse |
Git Vendors
AtScale supports connections to the following Git vendors:
- GitHub
- GitLab
Supported Business Intelligence Tools
Microsoft Excel and Power BI contain the required drivers. SQL tools such as Tableau must use one of the supported PostgreSQL drivers listed below. AtScale requires a PostgreSQL driver because it emulates the PostgreSQL interface.
For more information, see Connecting to AtScale from Business Intelligence Software.
Tableau
| Tool | Connection Type | Client Driver |
|---|---|---|
| Tableau Desktop 2024.1 | Thrift SQL | * See Vendor Drivers below |
| Tableau Server 2023.3 | Thrift SQL | * See Vendor Drivers below |
Excel / Power BI
| Tool | Connection Type | Client Driver |
|---|---|---|
| Excel 2021 | XMLA | Embedded SQL Server Analysis Services |
| Excel 365 | XMLA | Embedded SQL Server Analysis Services |
| Power BI Desktop, May 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 PostgreSQL Driver |
Vendor Drivers
-
PostgreSQL JDBC Driver:
- Tableau 2023.x, tested with PostgreSQL JDBC Driver 8 42.7.3
The PostgreSQL driver requires Tableau 2023.1 or higher.
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.
- 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.