Parameter Driven Data Integration
Using SAS
®
Stored Processes
Evangeline Collado, Sr. Database Analyst/Programmer
UNIVERSITY OF CENTRA L FL ORIDA
Paper # 102-2009
2
Agenda
Who We Are
Introduction
Data Integration Development
Stored Process Execution
Conclusion
Paper # 102-2009
3
Who We Are
University of Central Florida (UCF)
•
Metropolitan Research University
•
Fifth Largest University in US
•
Fall 2008 Enrollment Exceeded 50,200
•
12 Colleges Including New College of Medicine
•
12 Convenient Campus Locations
Institutional Research (IR)
•
Mission
Paper # 102-2009
4
Introduction
Student Credit Hour (SCH) Profile
Convert and Enhance Functionality
SAS
®
Enterprise Business Intelligence Server
SCH_FACT Table
•
Initial build
Paper # 102-2009
5
Data Integration Development
Identify Required Reporting Fields
Classify Source Tables and Fields
Create Data Model / Field Mapping Diagram
Paper # 102-2009
6
Data Integration Development
Right-click in blank
area of Process
Editor for Menu
Paper # 102-2009
7
Data Integration Development
Paper # 102-2009
8
Paper # 102-2009
9
Paper # 102-2009
10
Paper # 102-2009
11
Paper # 102-2009
12
Stored Process Execution
SAS
®
Add-In for Microsoft Office
SAS
®
Enterprise Guide
SAS
®
Information Delivery Portal
SAS
®
Information Map Studio
Paper # 102-2009
13
Paper # 102-2009
14
Paper # 102-2009
15
Paper # 102-2009
16
Paper # 102-2009
17
Paper # 102-2009
18
Paper # 102-2009
19
Conclusion
Robust DI Process
Parameters in SAS
®
Data Integration Studio
Prompts in SAS
®
Enterprise Guide
Data Integration Challenge Solved
Paper # 102-2009
20
Contact Information
Office of Institutional Research
•
Email: [email protected]
•
Web:
http://www.iroffice.ucf.edu
•
Address: P.O. Box 160021, Orlando, FL 32816-0021
•
Phone: (407) 823-5061 Fax: (407) 823-4769
Paper # 102-2009
21
UNIVERSITY OF CENTRA L FLORIDA
