AtScale Intelligence Platform


AtScale Intelligence Platform Making Hadoop Work for Business Intelligence

PUT THE POWER OF HADOOP IN THE HANDS OF BUSINESS USERS. Connect your BI tools directly to Hadoop without compromising scale, performance, or control.

TURN HADOOP INTO A HIGH-PERFORMANCE OLAP SERVER. Turn data in Hadoop into virtual, interactive OLAP cubes – no ETL, no data movement. Describe complex data as simple measures and dimensions that anyone can understand and use.

KEEP CALM. QUERY ON. Let AtScale’s query optimization engine take care of the complexity of creating and maintaining aggregations. Guarantee performance, at scale, for all user-generated queries.

Easy, Intuitive OLAP Cube Design Business users interact directly with data in Hadoop via the AtScale Design Center web application. AtScale Design Center allows data analysts to design virtual OLAP cubes using familiar workflows and intuitive drag-and-drop interactions.

Familiar OLAP Modeling Concepts Define and visualize virtual relational models on top of data in your Hive warehouse using well-known OLAP concepts. Create measures, dimensions, and relationships using easy drag-and-drop interactions.

Rich Multi-Dimensional Support Design hierarchical dimensions for interactive analysis and exploration. Logically model dimensions and relationships regardless of the underlying data format and schema.

Collaborative Cube Design Collaborate on cube projects with other users. Take snapshots at any point in time, and restore to previous versions if needed.

‘No ETL’ Virtual Data Abstraction Layer Overlay a virtual cube schema on the datasets in your Hive Metastore - no need to physically normalize data up front. Create metadata and calculations that BI tools need to query data directly in Hadoop.

AtScale Intelligence Platform

Making Hadoop Work for Business Intelligence

"With AtScale, our Analysts can access Hadoop directly, in realtime, using the visual

Interactive Performance from Your Favorite BI Tool AtScale supports your current business processes by allowing your analysts to use the BI tools they know and love. AtScale’s virtual cubes allow data in Hadoop to be presented to the BI tools in a format they can work with. Users just experience the interactivity and responsiveness they have come to expect.

analysis tools they already know and use

HiveServer2 ODBC / JDBC drivers for SQL queries, and the builtin Microsoft OLE DB drivers for MDX queries.

every day, at 50-100x faster query speeds!"

Standard Database Drivers

Integrated BI Tool Companion Application Run the AtScale Sidecar client application along side your BI tool to browse cubes, download tool-specific data source descriptors, and profile queries sent to AtScale.

- Craig Fryar, Head of Business Intelligence at

Runtime Query Optimization AtScale’s advanced cost-based query planner delivers sub-second response times using smart aggregations technology.

Fast, Scalable Distinct Counts Service multiple distinct count queries simultaneously to populate BI workspace controls, such as filter dialogs with built-in support for exact and estimated distinct counts that scale.

AtScale Intelligence Platform

Making Hadoop Work for Business Intelligence

"AtScale is the hub that connects the many pieces needed to build a practical BI environment on top of Hadoop."

Smart, Self-Adjusting Query Optimization AtScale takes the pain out of OLAP by building and maintaining ondemand aggregate tables. It uses advanced machine-learning algorithms to optimize BI query workloads on-demand, and delivers the performance that users have come to expect from their legacy OLAP systems.

Dynamic Aggregate Creation and Tuning AtScale’s virtual OLAP cube definitions and end-user query patterns are used to dynamically create and tune aggregate tables, maintaining optimal performance without human intervention.

- Raymie Strata, CEO, AltiScale

Easy Aggregate Maintenance Have complete control over aggregate usage and maintenance. View aggregate hit rates, configure the lifespan of an aggregate, or configure update triggers so data never gets stale.

Manual Aggregate Overrides Create aggregates ahead of time when needed - for example, manually define aggregates to support known business-critical dashboards and reports.

Support for SQL and MDX queries Service both SQL and MDX queries sent by your BI client tools. Let AtScale create an optimized query plan to deliver sub-second query response times.


Atscale Intelligence Platform Making Hadoop Work for Business Intelligence

Native On-Cluster Hadoop Solution "With AtScale, Cloudera customers can easily and securely connect their favorite BI tools to their

The AtScale OLAP engine is purpose-built for Hadoop. It leverages the latest advancements in the Hadoop ecosystem to support existing BI workloads, using Hadoop as the sole platform for data storage, discovery, optimization, and processing.

AtScale works out-of-the-box with the leading SQL-on-Hadoop engines, such as Impala, SparkSQL, or Hive, and allows them to function as an OLAP engine.

Enterprise Data Hub. Users leverage the power of Cloudera Impala and

Query the Data Where it Lays Query the data directly in Hadoop - no data movement, no data silos. Use advanced statistics and schema-on-read technologies to optimize queries on the data in its native format.

AtScale to maximize the value of Hadoop data in real-time and with

Support for Leading SQL-on-Hadoop Engines

Built-in Support for Complex Data Types The AtScale solution is designed for modern data - such as sensors, network logs, and mobile apps - with built-in support for complex data types such as maps and arrays.

optimal speed"

- Amr Awadallah, Founder and CTO, Cloudera

Single Gateway Node Drop-in Deployment AtScale deploys on a single gateway node in your Hadoop environment - no additional cluster to maintain, no software footprint on your Hadoop nodes.

Enterprise-Level Access Control, Monitoring and Management AtScale works with Enterprise Hadoop deployments to offer data governance and security for the data residing in Hadoop. Administrators have complete control over who can access which data across all Hadoop clusters in the Enterprise.

Role-Based Access Control Manage users across departments and organizations using rolebased access control. Use AtScale cubes as a metadata layer to control which data in Hadoop is available to BI users.


AtScale Intelligence Platform

Making Hadoop Work for Business Intelligence

Connect AtScale to secure Hadoop services using Kerberos, Username/Password, or LDAP authentication.

"AtScale’s no-ETL and no-data movement

game-changer. This

required for anyone who wants to do BI on

Query Audit Trails Track cube access and query metrics for every query executed by AtScale. Know who is accessing what data, and the data size and response times of all results.

approach is simply a

application should be

Pluggable SASL Authentication

Multi-Cluster Support Create separate AtScale execution environments to connect to data from different physical or virtual Hadoop clusters. Easily move published cubes from one Hadoop environment to another.


- Kevin Johnson, CEO, eBates

The AtScale Architecture AtScale is installed on a single node, called a gateway node. The AtScale gateway node sits between your BI client applications and Hadoop. AtScale is comprised of a number of services that run on the AtScale gateway node. These services interact with BI client tools using standard interfaces such as ODBC, JDBC or OLE DB. AtScale also uses various Hadoop services to optimize and execute BI queries directly on the Hadoop cluster.

4 3


AtScale Gateway Node Requirements


AtScale is deployed on a dedicated gateway (or edge) node in the same data center as your Hadoop cluster.

• • • • •

Tableau Microsoft Excel Qlik Spotfire MicroStrategy



RHEL 6.x, CentOS 6.x, Ubuntu 12.x


4 cores minimum, 8+ recommended


32 GB minimum, 48+ recommended



Contact Hadoop Distributions • • •

Cloudera HortonWorks MapR

SQL-on-Hadoop Engines • • •

Impala SparkSQL Hive / Tez

Data Storage Formats • • • • • •

Parquet RC Files ORC Files Sequence Files Text Hive SerDe

Web Browsers • • •

Chrome Firefox Internet Explorer (10+)

AtScale, Inc. 400 So. El Camino Real, Suite 250 San Mateo, CA 94402 Phone 650-204-4959 Web [email protected]


AtScale Intelligence Platform

AtScale Intelligence Platform Making Hadoop Work for Business Intelligence PUT THE POWER OF HADOOP IN THE HANDS OF BUSINESS USERS. Connect your BI to...

1MB Sizes 6 Downloads 9 Views

Recommend Documents

Business Intelligence Platform Administrator Guide - Crystal Reports
Jan 9, 2015 - Example - Thick client and database tier separated from BI platform servers by a firewall. . . . . . . . .

Diver Platform Business Intelligence | Dimensional Insight
No SQL queries or scripting required to explore and analyze your data; Multiple clients: Web-based, standalone, and MS E

ProClarity Analytics Platform Business Intelligence (BI)
Sep 5, 2003 - ProClarity Desktop Professional is a customizable analytic client designed for analysts and power users th

Business Intelligence Platform Installation Guide for Windows -
Mar 25, 2014 - Web Intelligence Rich Client. .... This guide does not describe how to set up a supported host operating

Business Intelligence Platform Installation Guide for Windows -
Jul 20, 2015 - Web Intelligence Rich Client. .... This guide does not describe how to set up a supported host operating

SAS 9.1.3 Intelligence Platform: System Administration - SAS Support
terms established by the vendor at the time you acquire this publication. U.S. Government Restricted Rights .... Chapter

Unlock an Internal Account :: SAS(R) 9.3 Intelligence Platform
This topic explains how to unlock the account immediately, so that you don't have to wait until the account lockout peri

SAS 9.2 Intelligence Platform: Web Application - SAS Support
SAS® 9.2 Intelligence Platform: Web Application Administration Guide, Fourth Edition. Cary, NC: SAS Institute ... For a

SAS 9.2 Intelligence Platform: Installation and Configuration Guide
e-books, e-learning products, CDs, and hard-copy books, visit the SAS Publishing Web site .... Step 2: Create Operating

NetBeans Platform: Platform content: trunkscreenshots.html
In addition, MICE will be available to create, if required, console applications for other air defence related systems.