Enterprise Data Warehouse

What Is the Service?

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. 

Who Is Eligible to Use It?

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.

How Do I Use It?

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.

 
Request Assistance

Related Articles (2)

This article details how to fix an issue where data pulled from EDW Database does not display properly in MS Access.
This article details a change to ODBC Driver settings that should prevent this error.