Pentaho

 View Only
  • 1.  Optional Data source for Pentaho Analyzer (Drag & Drop solution)

    Posted 12-07-2021 04:46
    Hello,

    We use Pentaho Analyser reports, which use cubes defined in Mondrian schema connected to Ignite DB.
    I'd like to know, what other kind of data source options we have for Analyser Reports.
    Can we use for example Cassandra or Rest Endpoint directly?

    PS: Should this question be here or do I need to move it to Pentaho Community?

    Thank you and regards.

    Marek

    ------------------------------
    Marek Tomko
    Systems Engineer
    Accenture CAS GmbH
    ------------------------------


  • 2.  RE: Optional Data source for Pentaho Analyzer (Drag & Drop solution)

    Posted 12-07-2021 17:28

    Mondrian will generally support anything you can connect to via JDBC and that supports SQL (it issues SQL commands to get data before building the cube).

    Mondrian Documentation
    Pentaho remove preview
    Mondrian Documentation
    This package is for Mondrian developers and power users. If you are interested solely in Mondrian's analysis capabilities from a user standpoint, download the Pentaho Business Intelligence Server instead.
    View this on Pentaho >

    Mondrian Documentation

    Pentaho remove preview
    Mondrian Documentation
    This package is for Mondrian developers and power users. If you are interested solely in Mondrian's analysis capabilities from a user standpoint, download the Pentaho Business Intelligence Server instead.
    View this on Pentaho >

      


    ------------------------------
    Andrew Cave
    Systems Engineer
    BizCubed Pty Ltd
    Australia
    ------------------------------



  • 3.  RE: Optional Data source for Pentaho Analyzer (Drag & Drop solution)

    Posted 12-08-2021 09:36
    So it looks that we need to use for example PDI to tranfer data from Cassandra or Rest Endpoint and store them to Analyzer supported JDBC solution.

    ------------------------------
    Marek Tomko
    Systems Engineer
    Accenture CAS GmbH
    ------------------------------



  • 4.  RE: Optional Data source for Pentaho Analyzer (Drag & Drop solution)

    Posted 02-10-2022 18:35
    That's right and you'll get the best query performance when you use Analyzer+Mondrian on top of a relational database with an existing SQL dialect such as Snowflake or Google BigQuery.  Here are all the available dialects:

    https://github.com/pentaho/mondrian/tree/master/mondrian/src/main/java/mondrian/spi/impl

    If one doesn't exist such as a Dremio dialect, you can always add your own to Mondrian.

    ------------------------------
    Benny Chow
    Pentaho Analyzer Architect
    Hitachi Vantara
    ------------------------------