Data Warehousing in Higher Education

Welcome to the directory of schools using data warehousing.  This page is listed under the Additional Resources heading on the EDUCAUSE Decision Support/Data Warehousing Constituent Group web page.  It started out with data obtained from the web site maintained by Dr. Ronald Allan at Georgetown University.  If your school wishes to participate, please click here to join the directory.  Or you can login to modify your details.  I have written a technical description of the directory database.  Please email me (David Heise <dheise@andrews.edu>) if you have comments or questions about this site.

Directory of Participating Schools

Saint Francis Seminary
Andrews University Stanford University
Arizona State University Syracuse University
Baylor University Texas A&M University System
Boston College Trinity College
Brown University Tufts University
California Community Colleges University of Akron
California State University University of Arizona
California State University at Hayward University of California Los Angeles
California State University, Hayward-S390 Focus Data Warehouse University of California San Diego
Califronia State University, East Bay University of California Santa Cruz
Case Western Reserve University University of Cincinnati
Case Western Reserve University, School of Medicine University of Connecticut
Central Queensland University University of Idaho
Columbia University University of Illinois
Cornell University University of Kansas
Davidson College University of Maryland
DePaul University University of Miami
Desert Research Institute University of Michigan
Duke University University of Minnesota
Emory University University of Nebraska
Fort Hays State University University of Nevada, Reno
George Mason University University of New Mexico
George Mason University University of New Mexico
George Washington University University of New Mexico
Georgetown University University of Notre Dame
Georgia Southern University University of Osnabrueck/Germany
Harvard University University of Rochester
Indiana University University of Tennessee, Knoxville
Indiana University Of Pennsylvania University of Texas at Austin
Ithaca College University of Texas at San Antonio
Jaypee Institute of information technology University of Utah - Health Sciences Center
Kasetsart University University of Virginia
Kasetsart University University of Washington
KCTCS - Kentucky Community & Technical College System University of Washington
Loma Linda University University of Western Ontario
MIT University of Wisconsin - Madison
Nevada System of Higher Education University of Wisconsin - Stout
North Carolina Central University University of Wisconsin, Milwaukee
North Dakota University System US Naval Academy
Northeastern University Utah State University
Ohio University Virginia Commonwealth University
Oklahoma State University Virginia Tech
Oregon State University Virginia Tech
Penn State University Wake Forest University Health Sciences
Pennsylvania State System of Higher Education Washington College
Princeton University Washington State University
Purdue University Williams College
Rensselaer Polytechnic Institute Yale University
Rhode Island College York University
Subject Area Key
 Code   Subject Area
 AC   Academic 
 AD   Alumni/Development 
 EN   Enrolment 
 FA   Financial Aid 
 FI   Finance 
 HR   Human Resources 
 ST   Student 
 OT   Other 
 
Data Warehouse URL: http://ucs.admin.washington.edu/dwp/
Subject Areas: EN: Enrollment; FI: Budgeting, General Ledger; HR: Human Resources, Payroll; ST: Degrees, Majors, Student Demographics, Student Information, Transcripts
Database: Microsoft SQL Server 2000
ETL Tool: Microsoft DTS and SSIS
Data Modeling Tool: ERStudio
MetaData Tool: Under development
Query Tool: Cognos 7 & 8, Query Analyzer, SQL Mgmt Studio, MS Access
Schema Type: Inmon Denormalized Relational
Server OS: Windows 2000
Contacts:
Other Comments:
Date Last Updated: 23-May-2007 6:06:06 PM
Andrews University   http://www.andrews.edu
Data Warehouse URL:
Subject Areas: FI: General Ledger; HR: Payroll
Database: Microsoft SQL Server
ETL Tool: Microsoft SQL Server
Data Modeling Tool: ERWIN
MetaData Tool:
Query Tool:
Schema Type:
Server OS: Windows 2003
Contacts:
David Heise :   ex CIO
  dheise at andrews.edu
Other Comments:
Date Last Updated: 18-Aug-2007 5:31:42 PM
Arizona State University   http://www.asu.edu/
Data Warehouse URL: http://www.asu.edu/data_admin/
Subject Areas: AC: Course - Homegrown System (IDMS), Research - COEUS (MIT); FA: Financial Aid - SIGMA (UDB); FI: Finance - Advantage (DB2); HR: Human Resources - Integral (DB2); ST: Student - Homegrown System (IDMS), Student Fees - Homegrown System (IDMS); OT: Facilities/Property - Homegrown System (Sybase)
Database: Sybase
ETL Tool: Primarily Cobol or Sybase stored procedures. Also using Embarcadero D/T Studio
Data Modeling Tool: PowerDesigner (Data Architect)
MetaData Tool: Homegrown definition tables accessed through BrioQuery remarks.
Query Tool: BrioQuery (desktop client), MS-Access, Various web development tools (ASP, JAVA, ColdFusion, Crystal Reports)
Schema Type: Denormalized E/R and Pseudo Star Schemas Extract Files, or Star Schemas
Server OS: Unix
Contacts:
John Rome :   Director, Data Administration & Data Warehouse
  (480) 965-5959
  John.Rome at asu.edu
Other Comments:
Date Last Updated: 15-Sep-2003 3:07:02 PM
Baylor University   http://www.baylor.edu/
Data Warehouse URL: https://bearhaus.baylor.edu
Subject Areas: AD: Alumni/Development; EN: Admissions - Graduate, Admissions - Undergraduate, Enrollment, Recruiting; FA: Financial Aid; FI: Finance; HR: Human Resources; ST: Degrees, Graduation, Majors, Student Demographics, Test Scores; OT: Benchmarks
Database: SAS
ETL Tool: Custom SAS code/SAS Data Warehouse Administrator
Data Modeling Tool: Pencil & Paper
MetaData Tool: SAS Data Warehouse Administrator
Query Tool: SAS MDDB Report Viewer; custom applications written in SAS
Schema Type: Extract Files
Server OS: Windows 2000 Terminal Server
Contacts:
Sue Herring :   Senior Research Analyst
  (254) 710-8836
  Sue_Herring at Baylor.edu
Tom Bohannon :   Assistant Vice-President for Information Management and Testing Services
  (254) 710-2061
  Tom_Bohannon at Baylor.edu
Phil Rhodes :   Senior Research Analyst
  (254) 710-8860
  Phillip_Rhodes at Baylor.edu
Other Comments:
Date Last Updated: 16-Sep-2003 6:24:33 PM
Boston College   http://www.bc.edu/
Data Warehouse URL: Not yet public
Subject Areas: AD: Alumni/Development; EN: Admissions, Admissions - Graduate; FI: Budgeting, General Ledger, Purchasing; HR: Human Resources; ST: Student Accounts, Student Registration; OT: Facilities/Property
Database: Migrating from VMS/Ingres/Sqlassist environment to AIX/Oracle/SQR environment
ETL Tool: N/A
Data Modeling Tool: N/A
MetaData Tool: N/A
Query Tool: N/A
Schema Type: N/A
Server OS:
Contacts:
Jack Spang :   spang at bc.edu
Lance Tucker :   lance.tucker at bc.edu
Other Comments:
Date Last Updated: 16-Sep-2003 4:49:57 PM
Brown University   http://www.brown.edu
Data Warehouse URL:
Subject Areas: AC: Awards, Faculty Loads, Sponsored Programs; EN: Admissions, Admissions - Graduate, Admissions - Undergraduate, Enrollment, Recruiting; FA: Financial Aid; FI: General Ledger; HR: Human Resources, Labor Distribution; ST: Majors, Student Records
Database: Oracle and Microsoft Sql Server
ETL Tool: Oracle Warehouse Builder
Data Modeling Tool:
MetaData Tool:
Query Tool: Cognos ReportNet, Cognos Powerplay, and Speedware's Esperant
Schema Type:
Server OS: AIX and Win2K
Contacts:
John Styer :   Director
  401-863-7378
  John_Styer at brown.edu
Terri-Lynn Thayer :   Assistant Vice President, Computing & Information Services
  401-863-7355
  Terri-Lynn_Thayer at brown.edu
Linnea Wolfe :   Director
  401-863-7377
  Linnea_Wolfe at brown.edu
Other Comments: Legacy warehouses are in SQL server and Esperant is the primary query tool. We are also implementing SCT's Operational Data Store where we are attempting to use Cognos ReportNet as the query tool
Date Last Updated: 7-Jun-2005 1:58:48 PM
California Community Colleges   http://www.cccco.edu/
Data Warehouse URL: http://www.cccco.edu/divisions/tris/mis/reports.htm
Subject Areas: AC: Awards, Course, Curriculum, Faculty Loads; EN: Enrollment; FA: Financial Aid; FI: Fee Waiver Analysis; HR: Human Resources, Labor Distribution; ST: Assessment, Student Demographics
Database: Microsoft SQL Server 7.0/Teradata
ETL Tool: Microsoft DTS
Data Modeling Tool: N/A
MetaData Tool: N/A
Query Tool: BrioQuery 6
Schema Type: ASCII Extract files
Server OS: Win 2000 (SQL) / Unix (Teradata)
Contacts:
Patrick Perry :   Vice Chancellor of Technology, Research & Info Systems
  (916) 327-5912
  pperry at cccco.edu
Other Comments: Teradata is used as master; SQL Server is used to create summaries and for web development back end.
Date Last Updated: 14-Sep-2003 3:57:10 PM
California State University
Data Warehouse URL: None
Subject Areas:
Database: Oracle 7.3.4.4 and Oracle
ETL Tool: None - we just flatten the files and ftp them
Data Modeling Tool: None
MetaData Tool: None
Query Tool: BrioQuery v.6
Schema Type: Extract File
Server OS:
Contacts:
Donna Furon :   (562) 951-4319
  donna at calstate.edu
Other Comments:
Date Last Updated:  
California State University at Hayward   http://www.csuhayward.edu/
Data Warehouse URL: http://warehouse2.csuhayward.edu
Subject Areas:
Database: SQL Server Oracle8i
ETL Tool: Focus extracts from DB2, ftp, MsSql, stored procedures
Data Modeling Tool: None
MetaData Tool: None
Query Tool: Brio Query, Excel
Schema Type: Extract files
Server OS: NT4
Contacts:
Cornelius Taylor :   ntaylor at csuhayward.edu
Other Comments:
Date Last Updated: 16-Nov-2000 12:00:00 AM
California State University, Hayward-S390 Focus Data Warehouse
Data Warehouse URL: http://www.csuhayward.edu/FOCUS
Subject Areas: AC: Course, Curriculum, Faculty Loads, Other, Scheduling; EN: Admissions, Admissions - Graduate, Admissions - Undergraduate, Student Profiles; FA: Financial Aid; ST: Degrees, Graduation, Majors, Student, Student Information
Database: S390 Focus v7.1.1
ETL Tool: S390 Focus
Data Modeling Tool: S390 Focus
MetaData Tool: S390 Focus
Query Tool: S390 Focus 4GL Report Writer
Schema Type: Relational
Server OS: IBM S390
Contacts:
Robert Hughes :   Operating Systems Analyst-Expert Level
  510.885.3073
  rhughes at csuhayward.edu
Other Comments: Data Mart uses Time Span Partitions
Date Last Updated: 31-Mar-2004 7:55:59 PM
Califronia State University, East Bay   http://www.csueastbay.edu/
Data Warehouse URL: http://warehouse2.csueastbay.edu/
Subject Areas:
Database: SQL Server and Oracle
ETL Tool: Oracle Warehouse Builder and Focus Extracts
Data Modeling Tool: n/a
MetaData Tool: n/a
Query Tool: BrioQuery, Excel, ColdFusion
Schema Type: non-warehouse
Server OS: App: Windows DB: Solaris
Contacts:
Dan LeGate :   Analyst/Programmer
  dlegate at yahoo.com
Other Comments: This should replace your link that goes to http://warehouse2.csuhayward.edu/ We changed our name from Cal State Hayward to Cal State East Bay
Date Last Updated: 18-Jan-2007 12:08:56 PM
Case Western Reserve University  
Data Warehouse URL:
Subject Areas: AC: Awards, Course, Curriculum, Student Credit Hours; EN: Admissions, Admissions - Undergraduate
Database: Oracle 9i
ETL Tool: IBM Datastage 7.1
Data Modeling Tool: Embarcadero ER Studio
MetaData Tool: IBM Metastage
Query Tool: Business Objects 6.5
Schema Type: ODS, Data Warehouse and Data Marts
Server OS: Solaris 2.9
Contacts:
Fayaz Ahmed :   Manager, Peoplesoft EPM and Data Warehouse Group
  216-368-6722
  fxa33 at case.edu
Other Comments:
Date Last Updated: 5-Dec-2006 8:19:27 PM
Case Western Reserve University, School of Medicine   http://www.cwru.edu/
Data Warehouse URL: Not yet public
Subject Areas: AC: Medical Education - (Exam performance); EN: Admissions; ST: Student Registration
Database: Microsoft SQL Server 7.0
ETL Tool: Microsoft DTS
Data Modeling Tool: To be determined
MetaData Tool: To be determined
Query Tool: Excel
Schema Type: To be determined
Server OS: NT 4.0
Contacts:
Irene Medvedev :   (216) 368-6209
  iba at po.cwru.edu
Other Comments:
Date Last Updated: 6-Dec-2000 12:00:00 AM
Central Queensland University   http://www.cqu.edu.au
Data Warehouse URL:
Subject Areas:
Database: Oracle 9i
ETL Tool: Awaiting confirmation of recommentdation
Data Modeling Tool: as above
MetaData Tool: none
Query Tool: COGNOS Impromptu, Impromptu Web Reports and PowerPlay
Schema Type: Planned to use Star Schema
Server OS: Solaris
Contacts:
Other Comments: Currently using COGNOS tools to report agains live operational data. Moving reporting particularly against ERP for speed and access efficiency - and more importantly - simplicity
Date Last Updated: 5-Apr-2004 8:51:26 PM
Columbia University   http://www.columbia.edu
Data Warehouse URL: www.columbia.edu/cu/sis
Subject Areas:
Database: Sybase
ETL Tool:
Data Modeling Tool:
MetaData Tool: Homegrown
Query Tool: InfoMaker, Brio, WebFOCUS
Schema Type:
Server OS: AIX
Contacts:
Susan St. John-Parsons :   ss53 at columbia.edu
Bernie Kluger :   Associate Director, Student Information Systems
  212 854-1361
  bkluger at columbia.edu
Isabella Lupinski :   Assistant Director, Student Information Systems
  212 854-3085
  il80 at columbia.edu
Other Comments:
Date Last Updated: 24-Sep-2003 9:47:08 AM
Cornell University   http://www.cornell.edu/
Data Warehouse URL: Internal Only
Subject Areas: AC: Sponsored Programs; AD: Alumni; FI: Accounts Payable, General Ledger; HR: Human Resources, Labor Distribution, Payroll; ST: Student Accounts, Student Records - Bursar, Grad Student Records and 1-2 HR areas by July 2001.
Database: Oracle 8i, Informix 7.3 (Phasing out)
ETL Tool: Home grown custom code. Mostly written in Natural to extract from ADABAS, SQL and PL/SQL for warehouse-side transformations
Data Modeling Tool: Erwin
MetaData Tool: Erwin
Query Tool: Brio Insight accessed through the Brio Portal (for security and scalability), Actuate, Excel, Andyne GQL (Phasing out in favor of web access)
Schema Type: Star Schemas
Server OS: Unix, specifically AIX
Contacts:
Jim Singleton :   Data Warehouse Architect
  js537 at cornell.edu
Other Comments:
Date Last Updated: 30-Jun-2005 8:02:34 AM
Davidson College   http://www.davidson.edu/
Data Warehouse URL:
Subject Areas: AD: Alumni/Development; EN: Admissions, Recruiting; HR: Human Resources, Payroll - Time Sheets, Deduction Reports; ST: Student Information, Student Records, Student Registration; OT: Athletics, Campus Directory, Telephone Billing
Database: Oracle
ETL Tool: PL/SQL, SQL
Data Modeling Tool:
MetaData Tool:
Query Tool: Access
Schema Type:
Server OS: Unix
Contacts:
Ruth Bratton :   Director of Administrative Computing
  704 894-2405
  rubratton at davidson.edu
Kevin Cauble :   Senior Programmer
  704 894-2787
  kecauble at davidson.edu
Other Comments:
Date Last Updated: 15-Sep-2003 4:59:23 PM
DePaul University   http://www.depaul.edu
Data Warehouse URL: http://www.depaul.edu/~datamart
Subject Areas:
Database:
ETL Tool:
Data Modeling Tool:
MetaData Tool:
Query Tool: Access - this mart is for "meat and potatos" students lists, detailed reports on subpopulations, and for exception reporting, not intended for summarization or EIS work. Campus stats are separately developed and published by our Enrollment Management Division and long-term longitudinal stats are developed and published by the separate Office of Institutional Planning and Research.
Schema Type:
Server OS:
Contacts:
Jim Janossy :   Senior Data Warehouse Analyst
  (312) 362-8233
  jjanossy at depaul.edu
Other Comments: The DePaul student datamart distills PeopleSoft SA information on 40,000 currently active students so that our eight college offices can make adhoc inquiries using Access with ODBC connection to the Oracle tables housing the mart. The mart supports about 80% of the typical adhoc queries previously processed by the Information Services Division, and we currently have approximately 60 authorized users.
Date Last Updated:  
Desert Research Institute   http://www.dri.edu/
Data Warehouse URL: Only accessible within DRI
Subject Areas: FI: Finance; HR: Human Resources - To be done.
Database: Oracle 8.1.6
ETL Tool: Extraction is done on the mainframe using Focus and LFSeek. Oracle SQL Loader is used to load the data into the intermediary database tables. SQL scripts are used to populate the data warehouse tables. Minimal transformation is done (e.g. nulls to spaces) some in Focus, some in SQL Loader
Data Modeling Tool: Oracle Designer
MetaData Tool: Oracle Designer
Query Tool: Web-based interface using Oracle WebDB. Various types of reports are available. We currently have no ad-hoc query capabilities
Schema Type: The underlying tables are in star schemas; the user reports are drawn from denormalized fact tables
Server OS: Unix (Solaris 2.7)
Contacts:
Kathy Smith-Miller :   (775) 673-7338
  kathy at dri.edu
Other Comments:
Date Last Updated: 16-Sep-2003 4:59:53 PM
Duke University   http://www.duke.edu/
Data Warehouse URL: Internal Only
Subject Areas: FI: Finance
Database: Oracle
ETL Tool: SAS
Data Modeling Tool: ERWin
MetaData Tool: ERWin
Query Tool: Brio, Essbase, Access, Discover
Schema Type: Star Scheme
Server OS: AIX
Contacts:
Howard Shang :   Director IT
  (919) 419-5725
  howard.shang at duke.edu
Other Comments:
Date Last Updated: 17-Nov-2000 12:00:00 AM
Emory University   http://www.emory.edu/
Data Warehouse URL:
Subject Areas: AC: Other - Faculty Demographics; AD: Development/Advancement; FI: Accounts Payable, General Ledger, Purchasing - planned; HR: Human Resources, Labor Distribution, Payroll; OT: Campus Directory, Security
Database: Moving from Sybase to Oracle
ETL Tool: DataStage
Data Modeling Tool: ERwin
MetaData Tool:
Query Tool: BusinessObjects is the ITD supported offering, but any tool is permitted.
Schema Type: Denormalized, Relational
Server OS: AIX Unix
Contacts:
Barbara Anderson :   IT Technical Lead
  404-727-7826
  isbgg at emory.edu
Other Comments:
Date Last Updated: 24-Sep-2003 11:02:38 AM
Fort Hays State University   http://www.fhsu.edu/
Data Warehouse URL:
Subject Areas: AC: Course; EN: Recruiting; FI: Finance; HR: Payroll; ST: Assessment, Degrees, Student, Test Scores, Transcripts - (Contains current and all available historic data).
Database: MS/SQL Server
ETL Tool: None....COBOL and Ms/SQL Server stored procedures
Data Modeling Tool: None
MetaData Tool: None
Query Tool: Cognos’ Impromptu and MS/Access
Schema Type: Simple Index Method, Impromptu Catalogs
Server OS:
Contacts:
Al Leiker :   (785) 628-5543
  alleiker at fhsu.edu
Other Comments:
Date Last Updated:  
George Mason University   http://www.gmu.edu
Data Warehouse URL:
Subject Areas: EN: Admissions - Graduate, Admissions - Undergraduate, Enrollment; FI: Accounts Payable - In progress, Finance; HR: Human Resources
Database: Oracle 9i
ETL Tool: Oracle Warehouse Builder
Data Modeling Tool: Embarcadero's ER/Studio
MetaData Tool: Embarcadero's ER/Studio
Query Tool: Discoverer, Cognos
Schema Type: Star Schema
Server OS: Sun Solaris 9
Contacts:
Tom Leventhal :   Manager, Data Mart Support
  703.993.3544
  tleventh at gmu.edu
Carrie Gillotte :   Director, Database Application Services
  703.993.3733
  cgillott at gmu.edu
Other Comments:
Date Last Updated: 28-Feb-2005 10:47:28 AM
George Mason University   http://www.gmu.edu
Data Warehouse URL:
Subject Areas:
Database: Oracle RDBMS
ETL Tool: Oracle Warehouse Builder, Home
Data Modeling Tool: Embarcadero's ER/Studio
MetaData Tool:
Query Tool: Discoverer, Cognos
Schema Type: Dimensional Modeling
Server OS: Sun Solaris
Contacts:
Jingxiao Feng :   Manager, Data Mart Support
  703-993-3544
  jfeng1 at gmu.edu
Other Comments:
Date Last Updated: 29-Sep-2006 4:59:31 PM
George Washington University   http://www.gwu.edu/
Data Warehouse URL: http://www.gwu.edu/~aapp/sdm
Subject Areas: EN: Admissions - Graduate, Admissions - Undergraduate, Enrollment, Recruiting
Database: Oracle 8.x
ETL Tool: Informatica PowerMart
Data Modeling Tool: ERWin
MetaData Tool: ERWin
Query Tool: Cognos Impromptu, IWR, PowerPlay, Query
Schema Type: Star Schema
Server OS: Unix, NT
Contacts:
Peter Barton :   Manager of Data Administration
  (202) 994-3413
  pabarton at gwu.edu
Cynthia Gener :   Sr. Data Administration Analyst
  (202) 994-8470
  cgener at gwu.edu
Kerry Washburn :   (202) 994-9714
  kjw at gwu.edu
Mike Wolf :   Sr. Data Administration Analyst
  (202) 994-7241
  mxwolf at gwu.edu
Other Comments: Data model is dimensional with 14 fact tables and 30 dimensions. Their model utilizes synthetic keys to accommodate slowly changing dimensions. Data is refreshed incrementally every night. GW uses Cognos Series 7 Business Intelligence Suite (Impromptu, PowerPlay, Query and Upfront) -- both desktop and web versions. For data transformation, they use Informatica's PowerMart Suite.
Date Last Updated: 23-Sep-2003 4:34:32 PM
Georgetown University   http://www.georgetown.edu
Data Warehouse URL: http://georgetown.edu/uis/ia/dw
Subject Areas: AC: Awards - In progress, Course; FI: Budgeting - Actuals vs Budgets, General Ledger - PeopleSoft; HR: Labor Distribution, Payroll - Genesys; ST: Student Records - SCT/IA
Database: Oracle
ETL Tool: Informatica
Data Modeling Tool: Erwin
MetaData Tool: Home grown Oracle tables
Query Tool: Cognos Suite, Series 7
Schema Type: Star Schemas
Server OS: Unix
Contacts:
Mark Drauszewski :   Data Warehouse Lead, EIS
  (202) 687-5552
  drauszem at georgetown.edu
Kim Bitto :   Data Warehouse Lead, EIS
  (202) 687-7257
  bitto at georgetown.edu
Other Comments:
Date Last Updated: 23-Sep-2003 1:02:16 PM
Georgia Southern University   http://www.gasou.edu
Data Warehouse URL: http://www2.gasou.edu/data_warehouse/index.html
Subject Areas:
Database:
ETL Tool:
Data Modeling Tool:
MetaData Tool:
Query Tool:
Schema Type:
Server OS:
Contacts:
Larry Wester :   Assistant Director, Student Information Systems
  (912) 681-0082
  LWESTER at GASOU.EDU
Other Comments:
Date Last Updated:  
Harvard University   http://www.harvard.edu/
Data Warehouse URL: No non-intranet available yet
Subject Areas: AD: Development/Advancement - (coming); FI: Accounts Payable - OracleApps, Budgeting - OracleApps, General Ledger - OracleApps, Purchasing - OracleApps; HR: Human Resources - PeopleSoft, Payroll - PeopleSoft; ST: Student Information; OT: Catering Services - (coming), Grant Management
Database: Oracle 8.1.6, 9.2.0.2
ETL Tool: Informatica, BCV of OraApps 10.7 NCA OLTP, some custom ksh scripts w/either imp/exp or SQL*Loader for legacy, and limited denormalization PL/SQL scripts
Data Modeling Tool: Oracle Designer
MetaData Tool: Oracle Designer
Query Tool: Standard: Oracle Reports, Brio Query + custom web front end. Ad Hoc: Brio Query, Powerbuilder/InfoMaker 6.0 & 7.0, some Access, Paradox, other Oracle8 native.
Schema Type: Financials ODS (actually OLTP clone via BCV), HR ODS, Financials star schema
Server OS: Solaris
Contacts:
Bill Brickman :   HDW Data Administrator
  (617) 496-8471
  bill_brickman at harvard.edu
Ian Wall :   HDW Practice Manager
  (617) 495-1061
  ian_wall at harvard.edu
Other Comments: Future initiatives to be based primarily on Informatica as ETL, Brio as Query Tool, 9i as RDBMS.
Date Last Updated: 17-Sep-2003 9:21:07 AM
Indiana University   http://www.indiana.edu/
Data Warehouse URL: http://www.indiana.edu/~dss/
Subject Areas: AC: Course - in progress, Library, Student Credit Hours - in progress; EN: Admissions, Enrollment - in progress, Recruiting - in progress, Student Profiles - in progress; FA: Financial Aid - in progress; FI: Finance; HR: Human Resources, Payroll; ST: Student - in progress
Database: Oracle 9.2.03
ETL Tool: Informatica
Data Modeling Tool: Combination of tools
MetaData Tool: Combination of tools
Query Tool: We have developed a web based enterprise reporting application known as Indiana University’s Information Environment (IUIE). This application allows for viewing of frozen formatted reports, selecting sections of frozen reports for viewing, extraction of raw data from the underlying Data Warehouse, execution of parameter driven queries written in SQR.
Schema Type: Denormalized data structures & beginning to develop dimensional models
Server OS: Unix running on an IBM SP Frame
Contacts:
Rebecca Gribble :   Acting Manager, Decision Support Services
  (812) 855-7288
  rgribble at indiana.edu
Other Comments:
Date Last Updated: 9-Aug-2005 4:48:39 PM
Indiana University Of Pennsylvania
Data Warehouse URL:
Subject Areas: AC: Course, Scheduling, Student Credit Hours; EN: Enrollment; FI: General Ledger; HR: Human Resources, Payroll; ST: Student Demographics, Student Registration; OT: Facilities/Property, Space Utilization
Database: Oracle
ETL Tool:
Data Modeling Tool:
MetaData Tool:
Query Tool: MS-Access; Cognos
Schema Type:
Server OS: Solaris
Contacts:
Bill Balint :   Technology Services Coordinator
  724-357-7864
  wsbalint at iup.edu
Dan Kuta :   Senior Database Administrator
  724-357-2887
  djkuta at iup.edu
Other Comments:
Date Last Updated: 1-Nov-2004 7:42:54 AM
Ithaca College   http://www.ithaca.edu
Data Warehouse URL: http://vail.ithaca.edu/argus
Subject Areas: AD: Alumni - We are using our BI portal primarily to post PDF docs., Alumni/Development, Development/Advancement; FI: Accounts Payable, Budgeting, General Ledger, Purchasing; HR: Human Resources
Database: Oracle 8i
ETL Tool: Oracle Warehouse Builder
Data Modeling Tool: Oracle Designer
MetaData Tool:
Query Tool: Oracle Discoverer SQL Navigator Oracle Reports
Schema Type:
Server OS: Win NT/2000
Contacts:
Marco Cestaro :   Data Warehouse Administrator
  (607) 274-1000
  mcestaro at ithaca.edu
Other Comments:
Date Last Updated: 15-Dec-2004 5:02:28 PM
Jaypee Institute of information technology   http://jiit.ac.in
Data Warehouse URL:
Subject Areas: AC: Research
Database:
ETL Tool:
Data Modeling Tool:
MetaData Tool:
Query Tool:
Schema Type:
Server OS:
Contacts:
Monika Garg Garg :   Lecturer
  0120-2400986
  monika.garg at jiit.ac.in
Other Comments:
Date Last Updated: 5-Sep-2005 4:09:31 AM
Kasetsart University   www.ku.ac.th
Data Warehouse URL:
Subject Areas:
Database:
ETL Tool:
Data Modeling Tool:
MetaData Tool:
Query Tool:
Schema Type:
Server OS:
Contacts:
Kalayaphat Udomsin :   kalayaphat at gmail.com
Other Comments:
Date Last Updated: 26-Oct-2007 12:52:37 AM
Kasetsart University   www.ku.ac.th
Data Warehouse URL:
Subject Areas:
Database:
ETL Tool:
Data Modeling Tool:
MetaData Tool:
Query Tool:
Schema Type:
Server OS:
Contacts:
Other Comments:
Date Last Updated: 26-Oct-2007 12:53:11 AM
KCTCS - Kentucky Community & Technical College System   http://www.kctcs.edu/
Data Warehouse URL: N/A
Subject Areas:
Database: Oracle 10g and Oracle 11g
ETL Tool: Cognos Decision Stream - Microsoft SQL Server 2000 (RDM) (Websphere) Ascential DataStage - Oracle 10g (EPM)
Data Modeling Tool: Sybase - PowerDesigner, Microsoft Visio, Pencil & Paper
MetaData Tool: Sybase - PowerDesigner, Ascential MetaStage
Query Tool: OBIEE suite: BI Answers, BI Interactive Dashboards, BI Publisher and BI Briefing Books, Oracle Discoverer, PS Query, Crystal, nVision, SQR, MS-Access, Quest-Toad for Oracle, SAS, SPSS, Oracle SQL Developer & Oracle SQL-Plus. Not necessary in this order. Focus is using OBIEE for all reporting with DSS implementation and remove reporting from the OLTP systems.
Schema Type: Denormalized tables, Dimensional and Star-Schema
Server OS: Solaris and Windows Server 2003
Contacts:
Thomas Burgess :   Lead Administrative Systems Engineer
  859-256-3228
  Thomas.Burgess at kctcs.edu
Jim Phillips :   System Director, Information Management
  859-256-3337
  jim.phillips at kctcs.edu
Other Comments: o-- Current reporting solution -- PeopleSoft RDM using SQL Server 2000 RDBMS (Windows2003), Cognos Decision Stream (ETL), Impromptu and Impromptu Web Reports (IWR), de-supported target July 1, 2008, with RDM structures migrated into PeopleSoft EPM until EPM Campus Solutions matures over time. New reports for RDM using OBIEE suite of tools. . o-- New Decision Support System (DSS) & Data Warehouse using Oracle 10g&11g, OBIEE, Fusion Intelligence and PeopleSoft EPM as the data warehouse, and SAS & SPSS for statistical reporting. Phase one implementation target January 2008. Ascential DataStage (ETL). . o-- KCTCS includes 28 colleges with 60 campuses that operate in 16 seamless districts. KCTCS enrolls 94,000 students in credit courses and touches 300,000 people a year through credit and non-credit education and training options. KCTCS colleges change lives by providing accessible and affordable education and training through academic and technical associate degrees; diploma and certificate programs in occupational fields; pre-baccalaureate education; adult, continuing and developmental education; customized training for business and industry; and distance learning.
Date Last Updated: 22-Oct-2007 11:08:36 AM
Loma Linda University   http://www.llu.edu
Data Warehouse URL:
Subject Areas: EN: Admissions, Enrollment, Recruiting, Student Profiles; FA: Financial Aid
Database: SQL Server
ETL Tool: Enterprise Manager
Data Modeling Tool:
MetaData Tool:
Query Tool: MS Reporting Services
Schema Type:
Server OS: Windows
Contacts:
DP Harris :   Vice Chancellor for IS and CIO
  dpharris at llu.edu
Mike Scofield :   nmscofield at llu.edu
Other Comments:
Date Last Updated: 30-Aug-2004 7:44:32 PM
MIT   http://www.mit.edu
Data Warehouse URL: http://web.mit.edu/warehouse
Subject Areas: AC: Awards; FI: Finance, Purchasing; HR: Human Resources - (no payroll yet); ST: Student Information - basic; OT: Keys, Space Utilization, Web Usage
Database: Oracle 7.3.4
ETL Tool: Our own process
Data Modeling Tool:
MetaData Tool:
Query Tool: Brio
Schema Type: Star Schemas as much as possible
Server OS:
Contacts:
Scott Thorne :   Data Warehouse Administrator
  (617) 253-2978
  thorne at mit.edu
Other Comments:
Date Last Updated:  
Nevada System of Higher Education   http://system.nevada.edu/
Data Warehouse URL:
Subject Areas: FI: Finance; HR: Human Resources; ST: Student Information; OT: Campus Directory
Database: Oracle 10g
ETL Tool: cobol, pl/sql
Data Modeling Tool: Designer, pencil and paper
MetaData Tool:
Query Tool: Custom interface, Oracle Discoverer
Schema Type: Student - star schema, Human Resources - star schema, Financial - denormalized ODS
Server OS: Unix
Contacts:
Ginger Holladay-Houston :   Director, Information and Application Services
  Ginger at nshe.nevada.edu
Other Comments:
Date Last Updated: 23-May-2007 2:34:12 PM
North Carolina Central University   http://web.nccu.edu/index.htm
Data Warehouse URL: http://web.nccu.edu/index.htm
Subject Areas: AC: Course - In progress, Curriculum, Faculty Loads - In progess, Other, Student Credit Hours; AD: Alumni/Development - in progress; EN: Admissions, Admissions - Graduate, Admissions - Undergraduate, Enrollment, Other, Student Profiles; FA: Financial Aid - in progress, Other - in progress; FI: Budgeting - Phase III, Other - Phase III; HR: Human Resources - Phase II, Other - Phase II; ST: Degrees, Graduation, Majors, Other, Student, Student Demographics, Student Information; OT: Facilities/Property - Phase IV, Other, Space Utilization - Phase IV
Database: SAS and Oracle
ETL Tool: Custom SAS code/SAS Warehouse Administrator
Data Modeling Tool:
MetaData Tool: SAS Data Warehouse Administrator
Query Tool: SAS MDDB Report Viewer; custom applications written SAS
Schema Type: Extract files
Server OS: Windows 2000
Contacts:
Della Nicholson :   Data Warehouse Manager
  530-7538
  dnicholson at wpo.nccu.edu
Other Comments:
Date Last Updated: 7-Apr-2004 3:07:01 PM
North Dakota University System   http://www.nodak.edu/
Data Warehouse URL: None available yet
Subject Areas: FI: Finance, General Ledger, Purchasing; HR: Human Resources, Payroll; ST: Student
Database: Oracle 8i
ETL Tool: Flat file extracts from ADABAS using Natural and COBOL - Transformation and load using Oracle Data Mart Suite
Data Modeling Tool: Designer component of Oracle Data Mart Suite
MetaData Tool: Designer component of Oracle Data Mart Suite
Query Tool: Oracle Express and SQL code
Schema Type: Star schema, Oracle tables and fact tables
Server OS:
Contacts:
Mike Pytlik :   (701) 231-8119
  Mick_Pytlik at ndus.nodak.edu
Other Comments:
Date Last Updated:  
Northeastern University   http://www.northeastern.edu/
Data Warehouse URL: N/A
Subject Areas: EN: Enrollment; HR: Human Resources - some
Database: PeopleSoft >DB2/UDB & various legacy
ETL Tool: SQR code
Data Modeling Tool: SQR code
MetaData Tool:
Query Tool: BrioQuery 6
Schema Type: It depends
Server OS:
Contacts:
Dennis Noonan :   (617) 373-4158
  noonan at acs.neu.edu
Other Comments:
Date Last Updated:  
Ohio University   http://www.ohiou.edu/
Data Warehouse URL: www.ohiou.edu/datawarehouse
Subject Areas: EN: Admissions; FA: Financial Aid; ST: Student Accounts, Student Records
Database: Oracle 8.1.7.4.50
ETL Tool: Cobol/SQL Loader
Data Modeling Tool: none
MetaData Tool: none
Query Tool: SQL, Access, BrioQuery, Crystal Reports
Schema Type: Extract files and some Star schemas
Server OS: IBM/390 MVS
Contacts:
Laura Dalton :   Data Warehouse and Data Base Administrator
  (740) 597-1881
  daltonl at ohiou.edu
Other Comments:
Date Last Updated: 15-Sep-2003 3:05:16 PM
Oklahoma State University   http://www.okstate.edu/
Data Warehouse URL: Internal use only
Subject Areas: FI: Finance; HR: Human Resources; ST: Student Information
Database: DB2 MVS/NT
ETL Tool: Cobol, Focus and DPROPR
Data Modeling Tool: Homegrown
MetaData Tool: Homegrown
Query Tool: Web Focus, MS Access, Excel and other ODBC enabled tools
Schema Type: Extract Files and some Star
Server OS: MVS and NT
Contacts:
Mike Kerntke :   (405) 744-9314
  asdxmhk at okstate.edu
Other Comments:
Date Last Updated: 20-Nov-2000 12:00:00 AM
Oregon State University   http://www.orst.edu/
Data Warehouse URL: http://www.orst.edu/dept/computing/warehouse/
Subject Areas: AD: Public Relations; FA: Financial Aid; FI: Accounts Payable, Finance; HR: Human Resources; ST: Student
Database: Oracle 9
ETL Tool: Home grown processes
Data Modeling Tool: Paper & Pencil and Hummingbird BI/Admin
MetaData Tool:
Query Tool: Hummingbird BI/Query
Schema Type: Quasi-Relational & Stars/Snowflakes Extract Files, or Star Schemas
Server OS: Compaq Open VMS
Contacts:
Catherine Williams :   Central Computing Director
  (541) 737-2718
  Catherine.Williams at oregonstate.edu
Other Comments:
Date Last Updated: 15-Sep-2003 1:03:19 PM
Penn State University   http://www.psu.edu/
Data Warehouse URL: https://ais.its.psu.edu/DATAWARE/index.html
Subject Areas: EN: Admissions; FI: Finance; HR: Human Resources; ST: Student, Transcripts
Database: MS SQL 2000
ETL Tool: Mainframe data is extracted using Natural programs which contain the business logic. These files are then FTPed to the Data Warehouse.
Data Modeling Tool:
MetaData Tool:
Query Tool: MS Access, Excel, Impromptu, SAS, FileMaker Pro
Schema Type: Denormalized, Relational
Server OS: Windows 2000
Contacts:
Karen Schultz :   Director, Information Technical Services
  (814) 863-5424
  kls2 at psu.edu
Pete Dawson :   Manager, Information Services
  (814) 863-3637
  pdawson at psu.edu
Yvonne Riley :   Data Warehouse Consultant
  (814) 777-0964
  YRiley at psu.edu
Other Comments:
Date Last Updated: 19-Sep-2003 8:08:38 AM
Pennsylvania State System of Higher Education   http://www.sytecpa.org/
Data Warehouse URL: TBA
Subject Areas: AD: Alumni/Development; EN: Admissions, Enrollment; FA: Financial Aid; FI: Finance; HR: Human Resources; ST: Student - (Banner, People Soft, SAP, SCT IA, Legacy Mainframes)
Database: MS SQL 2000
ETL Tool: MS DTS
Data Modeling Tool: SQL Server
MetaData Tool:
Query Tool: Cognos Suite
Schema Type:
Server OS: Windows 2000 Advanced Server
Contacts:
Lisa Castellino :   lcastellino at sytecpa.org
Sonya Bennett :   sbennett at sytecpa.org
Rich Laychock :   rlaychock at sytecpa.org
Other Comments:
Date Last Updated: 23-Sep-2003 4:55:40 PM
Princeton University   http://www.princeton.edu/main/
Data Warehouse URL: http://web.princeton.edu/sites/datamall/
Subject Areas: EN: Admissions - Graduate, Admissions - Undergraduate, Recruiting; FA: Financial Aid; FI: Accounts Payable, Finance, General Ledger, Revenue; HR: Human Resources, Labor Distribution, Other - Faculty; ST: Graduation, Majors, Student, Student Demographics, Student Information, Student Registration, Test Scores; OT: Campus Directory, Facilities/Prop