Enterprise Data Warehouse - EDW - Access - Instructions/Procedures
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. 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.
Access to the Enterprise Data Warehouse (EDW) must be 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 information on setting up your password, training, and information about EDW.
After receiving notification that your access is set up, you will need to set up a password at the Change Your Business Objects Password link. Or you may also access the password management application via the EDDIE portal website.The website for USC's to request access is Get Data Warehouse Access. Data Warehouse Access Requests can only be accepted using the DS Unit Security Contact (USC) Application.
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.
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.