ORACLE SQL DEVELOPER - installation
note:
- IE browser will prompt options: Run, Save or Cancel options. Select: Run
- Firefox browser will prompt options: Save or Cancel. Select: Save then click on the downloaded file to run Ora SQL Developer.

- click on this link  to launch Oracle SQL Developer 2.1.1

- click Run


- click Run

- Oracle splash screen

- Select SQL Source (.sq;)


- click on the
+ icon



- A pop-up  screen will appear

 Populate the New Database Connection  (e.g. for WWIS)
1. enter Database Connection  Name * you can name it as to your preference e.g. WWIS Production
 2. enter your user name
3.  enter your password
- Save Password:  *remember if you save your password, it  will expire every 120 days
 4. enter Host Name:  uisdb.admsec.wwu.edu
 5. Select Service Name button
 6. enter Service Name WWIS
 7. click on Test button to test the database connection
 8.  Click on the Save button to save the parms
* see notes: configuring other database connections


- Click on WWIS icon


   - sign in if you have not saved your password


- results displayed




Configuring other database connections

Perform the above steps to set up other databases below (if required). The only data fields that you will be required to change are step changes will be for steps 1, 4 and 6.  Also step 3 if passwords are different .

For PPRD
Connection Name: PPRD  or other preferred name
Hostname: tisdb.admsec.wwu.edu
Service name pprd

For WISP
Connection Name: WISP Test  or other preferred name
Hostname: tisdb.admsec.wwu.edu
Service name: wisp

For WDEV
Connection Name: WDEV  Test Data warehouse
Hostname: wdevdb.admsec.wwu.edu
Service name wdev

For Dataw
Connection Name: Dataw  or other preferred name
Hostname: datadb.admsec.wwu.edu
Service name: dataw

 

 Upon completion of the  databases connections you had set up,  you will be presented with the choices of databases that you can connect to: e.g. PPRD
- click on PPRD
 

- enter your user name and password

note: passwords can be saved when initially setting up a db connection, however passwords need to be changed every 120 days