Enterprise Data Warehouse

Enterprise Data Warehouse provides access to a central data repository used for the collection and sharing of university related data. MSU’s enterprise data warehouse is commonly known as the MSUEDW and resides on an Oracle database.  It provides data that can be used to support the reporting, data analysis and general data needs of the university. The MSUEDW collects data from the university’s business systems (HR, Payroll, Finance, Organizational, IPF), student systems (Campus Solutions, D2L), research systems (KCRA, Contract Grants) and various other supporting applications and data sources. 

Anyone associated with MSU can obtain access to the MSUEDW. Any individuals wanting access would need to submit a TDX Access Request and submit the request through use of the Default Form.

Users of the MSUEDW have multiple ways in which they can access the data, allowing for the ability to provide the data in a way that can meet the specific needs of how the data will be used. 

• Connect directly to the MSUEDW using a SQL querying tool and run self-developed ad-hoc queries.
• Connect using various reporting tools, such as Tableau and Cognos.
• Connect using common Microsoft applications, such as Excel and Access.

Data integration tools, such as APIs and file extracts can be created to automate data exports.