UPDATED 09:17 EDT / JUNE 06 2019

BIG DATA

AtScale ups data warehouse support and adds development kit for platform integration

AtScale Inc., developer of a business intelligence abstraction platform that reduces or eliminates the the need for data extract/transform/load procedures, Wednesday updated its core software.

The update includes the addition of native multidimensional support for Microsoft Corp.’s Power BI, improved integration with Teradata Corp. and PostgreSQL data warehouses, a software development kit for data platform integration and improved query and security capabilities.

AtScale 2019.1 continues the company’s evolution beyond its original purpose of harmonizing business intelligence software with Hadoop, a popular software framework for processing large amounts of data. Recently, the company has been adding support for other types of data sources with the goal of enabling BI queries to run against a combination of them without extensive data preparation.

“We now have a very deep analytical integration via SQL into native data warehouse platform capabilities in both the performance and security planes,” said Scott Howser, chief product officer at AtScale. “The introduction of the SDK opens up support to more platforms faster,” through the use application program interfaces as well as SQL support.

Native Power BI and Excel support covers both Microsoft’s MDX online analytical processing query language and multidimensional tables through an updated live connection to Microsoft Power BI. That enables users to access Power BI’s time-intelligence functionality without continually having to re-define business logic.

Live connectivity is also provided for data stored in Snowflake Computing Inc. and Google LLC BigQuery data warehouses without the need to move, extract or copy data. Support for PowerBI’s multidimensional features “unlocks a tremendous amount of business analysis capabilities,” Howser said.

Improved security and governed access for Excel enables organizations to share data with external partners interactively while maintaining visibility into what’s being shared and how it’s being used. “This means a much faster cycle time for analysis,” Howser said. “What may previously have taken weeks or months is now available in real time.”

The new SDK enables users to more easily add support for new data platforms and extend coverage for native platform capabilities. AtScale 2019.1 also introduces what the company said is greatly improved query performance and model administration for large-scale data sets, including enhanced time-series analysis with wide table planning and enhanced support for decimal and numeric data types. “For user-defined precision, this is a configuration option when using a double data type, which is essential for handling monetary values,” Howser said.

Security has been improved with support for version 2.0 of the or Security Assertion Markup Language protocol, which is used by web browsers to enable single sign-on through secure tokens.

Photo: Unsplash

A message from John Furrier, co-founder of SiliconANGLE:

Your vote of support is important to us and it helps us keep the content FREE.

One click below supports our mission to provide free, deep, and relevant content.  

Join our community on YouTube

Join the community that includes more than 15,000 #CubeAlumni experts, including Amazon.com CEO Andy Jassy, Dell Technologies founder and CEO Michael Dell, Intel CEO Pat Gelsinger, and many more luminaries and experts.

“TheCUBE is an important partner to the industry. You guys really are a part of our events and we really appreciate you coming and I know people appreciate the content you create as well” – Andy Jassy

THANK YOU