Sakai/OSPortfolio

ID #1034

How to enable the OSP data warehouse

The OSP reporting tool is designed to work from the data warehouse, instead of the live data -- so you'll need to make sure your data warehouse has something useful to report on, eh?

First of all, what is the OSPortfolio Data Warehouse?

It's the data in the dw_* tables in your Sakai database. Really! For example, dw_scaffolding is the data-warehouse version of osp_scaffolding, as dw_site_users is for site_users. Nothing to it!

mysql> show tables like 'dw_%';
+--------------------------------+
| Tables_in_sakai_2_4_x (dw_%) |
+--------------------------------+
| dw_assignment_status |
| dw_content_resource_lock |
| dw_guidance |
| dw_guidance_item |
| dw_guidance_item_file |
| dw_matrix |
| dw_matrix_cell |
| dw_metaobj_form_def |
| dw_pres_itemdef_mimetype |
| dw_presentation |
| dw_presentation_comment |
| dw_presentation_item |
| dw_presentation_item_def |
| dw_presentation_item_property |
| dw_presentation_layout |
| dw_presentation_log |
| dw_presentation_page |
| dw_presentation_page_item |
| dw_presentation_page_region |
| dw_presentation_template |
| dw_resource |
| dw_resource_collection |
| dw_review_items |
| dw_scaffolding |
| dw_scaffolding_cell |
| dw_scaffolding_cell_evaluators |
| dw_scaffolding_criteria |
| dw_scaffolding_levels |
| dw_session |
| dw_site_users |
| dw_sites |
| dw_template_file_ref |
| dw_users |
| dw_wizard |
| dw_wizard_category |
| dw_wizard_completed |
| dw_wizard_completed_category |
| dw_wizard_completed_page |
| dw_wizard_page |
| dw_wizard_page_attachments |
| dw_wizard_page_def |
| dw_wizard_page_def_add_forms |
| dw_wizard_page_forms |
| dw_wizard_page_sequence |
| dw_wizard_style |
| dw_wizard_support_item |
| dw_workflow_parent |
+--------------------------------+
47 rows in set (0.00 sec)

Ever wonder why you had all those empty tables? These wind up as denormalized versions of many other standard tables from the Sakai database. These are easier to report from (but as they data warehouse is a snapshot, it's likely to be a bit out-of-date frequently).

Even so, if there's absolutely nothing in these data-warehouse tables at all, they won't be very useful to you. So here's how you "turn on the data warehouse" inside OSPortfolio:

  1. Enable the "sakai.scheduler" tool in an administrator's worksite somewhere (that is, the tool isn't worksite-specific -- it operates database-wide, so adding it to your "History 241B" course worksite wouldn't make much sense). While you're adding the tool, it'll look something like this (in the ADMIN workspace) where it's called "sakai.scheduler":

  2. Now, visit your new QUARTZ SCHEDULER (sakai.scheduler) tool

    quartz_scheduler.png

    Yours may look a tad different, of course...

  3. Click "NEW JOB"
  4. Give it a name ("warehouse refresh" might do, that's what we used, above)
  5. Use TYPE "DATA WAREHOUSE UPDATE"

No, really, it's that easy. Finding the documentation that shows HOW? Well, that's a bit of a chore, actually -- but doing it, heck, that's easy.

Now, you can "run" this "job" any time by clicking on the "Triggers" link, and then clicking "RUN JOB NOW" for example. Simple!


Verified for Sakai/OSPortfolio version 2.4.x -- may also apply to other versions.

OSP is an open-source electronic portfolio built into Sakai, which is an open-source collaboration and learning environment.

Categories for this entry

Last update: 2007-10-12 11:48
Author: will trillich
Revision: 1.3

Print this record Print this record
Send to a friend Send to a friend
Show this as PDF file Show this as PDF file
Export as XML-File Export as XML-File

Please rate this entry:

Average rating: 4.13 out of 5 (32 Votes )

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry