How do I get access to the Enterprise Data Warehouse? I am a USC. 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 person (USC), then you will need to go to that person with your access request. Find my USC If you are an OBFS employee, please email AITS Service Desk at firstname.lastname@example.org or call them at (217) 333-3102 or (312) 996-4806 and they will send a ticket to OBFS Finance Security for you.
to the Enterprise Data Warehouse (EDW) is requested by your USC at
the Decision Support website via the DS Unit Security Contact (USC)
Application. Once the access has been requested, AITS/DS Security will
process the request within two (2) business days. A notification will
then be received by the user. The email contains instructions on how to register for training and additional resources to help you get started. Getting Started
For help determining what access to request, please view the Data Warehouse Access Plan.
It is highly recommended that new customers attend an instructor-led tool training course or a practice lab session 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.
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.