/
Excel - Adhoc Data Source

Excel - Adhoc Data Source

May 04, 2009

Create a new plugin for Excel that allows users to retrieve data from the Pentaho platform using metadata based queries.

The plugin needs to:

  • Allow the user to connect and login to a Pentaho BI server 

  • Retrieve the list of metadata models available to the user and let them pick one

  • Retrieve the details of the selected metadata model

  • Allow the user to select columns of data that they want to see

  • Submit the metadata-based query to the server and populate the sheet with the results

  • Save the connection and query information with the Calc sheet

  • Allow the user to refresh the data when a saved document is loaded