EDW - Connection Information for the EDW (Oracle) Database
If you have approved access, you can use ODBC connection and connect via the various tool such as TOAD, SQL Developer, or Tableau Desktop. You need to have EDW (Oracle) access. If you don't have access, please contact your USC, and they will guide you on how to gain access.
How do I connect to EDW data access? This is general connection information, specific instruction may vary depending on which tool you use. EDW is hosted on Oracle database.
The IP address or DNS hostname of the server that it needs to connect to is: chirptdb.admin.uillinois.edu
The Database name is: DSPROD01
The Database type (SID or Service name) is: DSPROD01
Access Notes: When I log in, what username and password do I use? If you try to use your AD, NetID, or Enterprise ID password, they will not work, you need to use your Data Warehouse/Oracle account and password. If you are not able to log-in, please try resetting the password using the link on the page link below and make sure the password you are using is as per Oracle -Database password requirements.