Instaview is a client-based analysis tool for single-user, agile development and analysis. Pentaho Analyzer is the OLAP analysis component embedded inside of Instaview. Analyzer works and performs well on MongoDB data because of Instaview's in-memory data cache mechanism. However, this local cache is not accessible to the BA server, so to enable web-based OLAP analysis on MongoDB data, we need to load the appropriate MongoDB data into a JDBC-compliant relational or analytical database.
If you remember, in Chapter 3, Using Pentaho Instaview, and Chapter 4, Modifying and Enhancing Instaview Transformations, Instaview automatically generated a data integration transformation, and we enhanced it to blend geographic data with MongoDB clickstream data. We want to leverage this valuable data integration work to avoid creating a new transformation from scratch. This section shows how Instaview can enable an agile development and analysis environment for...