OpenOffice Calc - Adhoc Data Source

Create a new plugin for OpenOffice calc 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