eprintid: 228
rev_number: 10
eprint_status: archive
userid: 4
dir: disk0/00/00/02/28
datestamp: 2009-12-30 14:35:24
lastmod: 2016-05-27 21:03:46
status_changed: 2009-12-30 14:35:24
type: conference_item
metadata_visibility: show
item_issues_count: 0
creators_name: Malott, Robin
title: Creating a Customized Reporting Solution for Aleph
ispublished: pub
subjects: aleph
divisions: eluna_conf
abstract:  Robin Malott, Technical Consultant, University of Notre Dame;
Pamela Scofield, Project Application/Developer, University of Notre Dame.

The session will be a case history of how we created a custom data warehousing/data mart reporting solution from Aleph data at Notre Dame using open source software. We will include an overview of the architecture, design and coding considerations as well as the data analysis and cleanup involved. We will also include an overview of the open source software utilized: Talend Open Studio (an open source ETL tool), SQuirreL (an open-source Java SQL Client program for any JDBC compliant database) for in-depth data analysis and Perl CGI as the reporting web front-end.
date: 2009-05-08
date_type: published
full_text_status: restricted
pres_type: speech
event_title: ELUNA 2009
event_location: Richmond, Va.
event_dates: 6-8 May 2009
event_type: conference
refereed: FALSE
citation:   Malott, Robin  (2009) Creating a Customized Reporting Solution for Aleph.  In: ELUNA 2009, 6-8 May 2009, Richmond, Va..     
document_url: https://documents.el-una.org/id/eprint/228/1/ELUNA_2009_A15a_b_SecondTalk.pdf