We’re excited to announce the release of ExoInsight 7.2!
ExoInsight is now being used in companies large and small all over the world to enable easy access to their OLAP data and metadata. Users can now work with their Essbase/Planning/OAC and Microsoft Analysis Services data just as they would a relational database, providing them the ability to both use their favorite reporting tools to generate beautiful dashboards as well as integrate the data and hierarchies stored in their Essbase and MSAS cubes with data warehouses and transactional systems. With ExoInsight 7.2, you now have even more options to deliver Essbase and MSAS data and hierarchies to everyone across the organization!
- Extended support for database platforms: SQL Server, Oracle, Redshift, Snowflake, BigQuery, MySQL, PostgreSQL, others
- REST API
- Tableau Hyper file extract format
(Note: Future blog posts will go in-depth into the following topics.)
Extended Support for Database Platforms
While ExoInsight allows reporting tools and data warehouses to directly access your Essbase and MSAS cubes, many customers like ExoInsight’s ability to push data and hierarchies to relational tables. This allows complete flexibility on how to present your data to the end users, reduces load on your Essbase or MSAS server, and provides more integration options for any other system that needs to consume Essbase or MSAS data and hierarchies. ExoInsight has always supported pushing Essbase or MSAS data and metadata to a SQL Server database. Now with ExoInsight 7.2 you can push your Essbase and MSAS data and metadata to just about any database platform available. Here is a list of some of the more popular platforms ExoInsight integrates with:
- SQL Server
- Amazon Redshift
- Google BigQuery
- Many more…
If you have a need to integrate Essbase or MSAS with a specific database platform, ExoInsight likely supports it.
ExoInsight 7.2 exposes a complete REST API that allows you to automate your Essbase and MSAS data and hierarchy extracts in multiple formats. REST calls are available for:
- Exporting data and metadata (hierarchies) to relational tables
- Exporting data and metadata (hierarchies) to JSON
- Parsing native ASO Export data extracts to column format.
- Exporting data and metadata (hierarchies) to Tableau Hyper file format
Other calls are currently under development and will be added in subsequent releases.
Tableau Hyper File Extract Format
Our recently announced partnership with Tableau has enabled us to provide even more functionality for connecting Tableau to your Essbase or MSAS data and hierarchies. ExoInsight now supports creating a Tableau Hyper file directly off your Essbase or MSAS data and hierarchies. This allows you to create a blazingly-fast Tableau Hyper file directly from your OLAP sources. Once the data and hierarchies have been pushed to the file, you have the complete power of Tableau available to you. Our POV String technology combined with a Tableau Hyper file makes working with your Essbase or MSAS data a breeze in Tableau!