For lack of better description (and sorry for the jargon), TriplePoynt Analytic Server is an MSAS or SSAS or AAS clone, running under the Windows operating system, supporting Microsoft's industry standard OLAP protocol ODBO and accessed from Microsoft Excel using Microsoft's Pivot Table services (or other ODBO clients).
MSAS has a kryptonite...pre-aggregation or use of physical data cubes. To provide a reasonable level of performance, MSAS needs to extract, move, transformation and re-load data into an MSAS proprietary data structure or cube. Microsoft (and other OLAP vendors) chose to use data cubes to overcome performance limitations of the databases available in the 1990s (yes, I said 1990s)!
Pre-aggregating data solved the performance problems while introducing complexity and cost, most concerning pre-aggregation introduced a crippling rigidity to data and therefore to the analysis. The predetermined physical structure of the cube controlled the analysis, not the data (a big claim)!
Why build a clone of a popular, successful, older Microsoft product?
Well, the marketplace didn't sit still and recently a new breed of parallel, cloud-based databases have emerged, including Snowflake. These products offer incredible performance and scalability. The rational for pre-aggregation and cubes is no longer supportable! MSAS' kryptonite is exposed!
Want to see TriplePoynt slice and dice billion row fact table on Snowflake? Here you go!
Unlimited Domain License
90 days duration
Unlimited Domain License
Email/Community Support
TriplePoynt Cube Administrator
Unlimited Domain License
Support Multiple Fact Tables
Materialized Views (Suggest, Build, Optimize)
Import MSAS Cubes
Telephone/Email/Community Support
TriplePoynt Cube Administrator
Download a FREE evaluation version of TriplePoynt for Snowflake right now!
Click 'Sign in' above, then select 'Register'. Add your work email (sorry no personal emails) and a password. Wait a moment or two, then you will receive an Activation email. Follow the Activation instructions, then sign in. Your email now should appear on the right side of our home page along with a drop down menu. From the drop down menu, select 'Download' to be taken to the Download page. Download the latest Evaluation version of TriplePoynt Analytic Server!
NOTE: The evaluation version of TriplePoynt is synced to an evaluation instance of Snowflake and an evaluation virtual cube. You will need to download an ODBC driver for Snowflake, so you may need a Snowflake account. Let us know if you need a specific download link.
TriplePoynt is part of the Geppetto's Workshop LLC family. Geppetto's Workshop is a big data/analytics pioneer, having developed industry-leading solutions for more than 25 years. Customer include Teradata (TDC), AT&T (T), NCR (NCR), Hallmark Cards, Parametric Technologies (PTC), Abbott Laboratories (ABT), Stryker (SYK), Johnson & Johnson (JNJ), Medtronics (MDT), Department of Energy (DOE) and Center for Medicare and Medicaid (CMS).
Detroit, MI success@triplepoynt.com