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 email@example.com 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.
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.
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.