Enterprise Data Warehouse - EDW - Access - Instructions/Procedures

How do I get access to the Enterprise Data Warehouse? I am a USC, and I need some instruction on how to complete an access request or modify an existing one in the DS Unit Security Contact (USC) Application. How do I make an ODBC connection for access?

If you are not a Unit Security Contact (USC), you will need to go to that person with your access request. If you are unsure who your unit's USC is, use the Find my USC webpage. If you are an OBFS employee, please email AITS Service Desk at servicedeskaits@uillinois.edu or call them at (217) 333-3102 or (312) 996-4806 and they will send a ticket to OBFS Finance Security on your behalf. 

Access to the Enterprise Data Warehouse (EDW) is requested by your USC at the Decision Support website via the DS USC Application. Once the access has been requested, AITS DS Security will process the request within two (2) business days. An email containing instructions on how to register for training and additional resources to help get started will be sent to the user. This information is also available on the Getting Started webpage.

The Get Data Warehouse Access webpage is a great starting point for USCs. EDW access requests can only be accepted using the DS USC App.

For help determining what access to request, please view the DS Access Plan.

It is highly recommended that new customers attend an instructor-led tool training course in-person or via webcast. Classes are offered on how to create specific types of reports, or how to use the Business Objects reporting tool in general.

Training Options

Register for Training

ODBC - if you plan on utilizing your internal application and database with an ODBC connection to the Enterprise Data Warehouse (EDW), instructions are made available at the AITS - Decision Support ODBC website.

Keywords:AITS, access EDW, complete access request or modify one, ODBC connection, DS Unit Security Contact (USC) Application, USC, ODBC   Doc ID:75281
Owner:Alex H.Group:University of Illinois System
Created:2017-08-03 16:31 CDTUpdated:2022-09-22 12:02 CDT
Sites:University of Illinois System
Feedback:  0   0