EDW - Connection Information for the EDW (Oracle) Database

How do I connect to EDW data access? This is general connection information, specific instruction may vary depending on which tool you use. EDW hosted on Oracle database.

If you have approved access you can use ODBC connection and connect via 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.  

Connection Information: (This is general connection information, specific instruction may vary depending on tool you use)

  • The IP address or DNS hostname of the server that it needs to connect to is chirptdb.admin.uillinois.edu
  • Port  2721
  • 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.




Keywords:AITS, ODBC, EDW, Tableau Desktop, DSPROD, SQL Developer, Tableau, Oracle   Doc ID:47327
Owner:Jayesh P.Group:University of Illinois System
Created:2015-02-17 17:09 CDTUpdated:2017-08-07 20:09 CDT
Sites:University of Illinois System
Feedback:  6   0