Problems connecting to the Data Warehouse at IU

At Indiana University, if you are unable to connect to the Data Warehouse (also known as ESDBD and DSS1PRD), but your Oracle login previously worked, try the following:

• Double-check your login and password. Make sure you are entering them in the correct case and without any leading or following spaces.
• If you are connecting with a desktop database application (for example, Access), close it completely, open it again, and try accessing a table again. You do not have to reboot your computer.
• Reset your password; see Change your DSS1PRD password in the IUIE.
• If you still can't connect, call the UITS Support Center at 812-855-6789 or 317-274-4357, option 2, and tell the consultants that you can't connect to the IU Data Warehouse. Let them know which specific server you are attempting to log into. The Support Center consultants will inform the Enterprise Decision Support Services group, who will investigate and get back in touch with you.

You can also verify your connection setup to the Enterprise Decision Support server. For more, see Oracle client configuration for the IU Data Warehouse.