my.Harvard Operational Data Store

This entry provides access to the data elements available in the Operational Data Store (ODS) for my.Harvard Student Information System. These data are available through a request process. What are the goals of the Operational Data Store? Provide data in a more real-time environment than the Warehouse (refresh 1x a day) while not putting additional load on the transactional my.harvard system. Provide a single (university-wide) standard set of exports and then web-services for retrieving key Student data. Provide the ability to incrementally load the SIS Data warehouse star schemas, making it possible to refresh certain stars more than once a day. Provide Institutional Research and Registrar power-users the ability to investigate the Student data via direct SQL access. What is the SIS Operational Data Store (SIS ODS)? A database schema on the SIS Datawarehouse that will contain replicated core tables of the my.harvard transactional system along with standardized, simplified and performant views for extracting that data. We intend to make most data available through web services before the end of academic year 2015-2016. However, our first iteration will to be make data available via db views. The refresh schedule for the SIS ODS tables for this first release will be: Academic Class Data - 1x a day between 5:30am and 6:00am. What data will be available in the SIS ODS? ODS - Academic Class v SISODS_1.0.6.xlsx follow link to get to older versions ODS - Bio Demo v SISODS_1.0.5.xlsx follow link to get to older versions ODS - Class Enrollment.xlsx ODS - Student Career Program Plan v SISODS_1.0.6.xlsx ODS - Admissions v. SISODS_1.0.7 Document coming Snapshots - non-FAS. For FAS Snapshots, please contact Harvard College Institutional Research. How can I request access to the SIS ODS? Send an email to [e-mail] to request access Please indicate what data you want to access through the ODS: School & Component Available components: Academic Class (course descriptors). Biographic - Demographic Class Enrollment Student Career Program Plan Please indicate whether the request is for a personal account or for an application integration account. For personal accounts, please provide the HUIDs of the individuals to be set up. How do I connect to the SIS ODS? SIS ODS connections are currently limited to ODBC/JDBC connections to a database. The attached instructions explain how to install SQL Developer and configure a connection.