SQL Developer can be used to create queries that can be used to retrieve data from the Data Warehouse. If the Software Center application is installed on the Windows computer, it can be used to install SQL Developer. The benefit of installing from Software Center is that SQL Developer is preconfigured to work with the Data Warehouse.
If Software Center is not available on the computer, SQL Developer can be manually installed and configured.
SQL Developer requires the Java Development Kit (JDK) version 8 or version 11, also known as JDK 1.8 or JDK 1.11
Verify Proper version of JDK is installed
- Click in the search box in the Windows task bar
- Start typing Command Prompt
- Select Command Prompt application
- Type java -version
- Press Enter
- If JDK is installed, the version will be displayed
- The version will be the first line. It should be either 1.8 or 1.11
- Note: there are various distributions of Java: OpenJDK, Oracle, Amazon Corretto, etc. They all will work with SQL Developer.
- If JDK is installed, the version will be displayed
If the computer has JDK version 1.8 or 1.11, continue on to the install SQL Developer section below.
Install Amazon Corretto Java 1.8
For Windows computers managed by University of Minnesota IT
- Open Software Center
- Please refer to the knowledge article on how to Install and Uninstall Available Software using Software Center
- Install Amazon Corretto Java 1.8
For other Windows computers
If you have an administrator account on the computer, you can install Amazon Corretto from the product page. Select Amazon Corretto 8
If you do not have an administrator account on the computer or access to Make Me Admin for temporary admin privileges, please contact your local IT support or Technology Help.
Install Oracle Client
For Windows Computers managed by University of Minnesota IT
- Open Software Center
- Please refer to the knowledge article on how to Install and Uninstall Available Software using Software Center
- Locate Oracle SQL Developer 19.2 in the list of available applications
- If you do not see the application, please contact Technology Help and request it be added to your Software Center
- Click the Install button. The application will download and install
- Restart the computer when installation completes
- Click the Windows Start menu
- Expand the OIT-Oracle 12 Client folder
- Select UpdateTNSNames
- It will first check if the file is already on the computer. If not, it will download from the University's files server.
- Open SQL Developer 4.0
- Select the Tools menu
- Select Preferences. The preferences window is displayed.
- Expand the Database category in the left navigation
- Select Advanced
- Check the box for Use Oracle Client
- Click the Configure button. The Configure Oracle Client window is displayed.
- Select Instant Client from the Client Type drop-down selector.
- Click the Browse button. The Choose Directory dialog window is displayed.
- Scroll to the top, and then expand the OIT-Oracle folder
- Select instantclient_12_1
- Click the Select button
- Click the OK button to close the Configure Oracle Client
- Click the Configure button. The Configure Oracle Client window is displayed.
- Check the box for Use OCI/Thick Driver
- Click Browse next to the Tnsnames Directory field. The Choose Directory window is displayed.
- Scroll to the top
- Select the OIT-Oracle folder
- Click the Select button
- Check the box for Use Oracle Client
- Click OK to close the Preferences window
- You may receive a message stating: "The client home C:\OIT-Oracle\instantclient_12_1 is not the first entry on the PATH. The OCI client may not work correctly." Select either the Yes or No button
- The application will then restart
- Select Preferences. The preferences window is displayed.
For other Windows Computers
Please contact your local IT support, or Technology Help
Create a Connection to Data Warehouse using SQL Developer
If you are using a Wireless connection on campus, or you are off campus, VPN is required. Download the Secure Client VPN for Windows client from the Technology Help website.
- Open SQL Developer from the Applications folder on the computer.
- Click the green + symbol in the upper left to create a new connection. The connection settings window is displayed.
- Type a name for the connection in the Connection Name field
- Type your University of Minnesota Internet ID in the Username field
- Type your password in the Password field
- Click the Connection Type drop-down selector
- Select TNS
- Click the Network Alias drop-down selector
- Select DWEPRD.WORLD
- Click the TEST button
- If your account uses DUO, you will need to confirm the request
- If the Status displays Success, everything works
- Click Save
- Click Connect
Troubleshoot Failed Connections
When configuring the connection to the Data Warehouse, the test might return an error similar to "Invalid username/password; logon denied". There are many reasons for this error. The most common:
- Re-type your Internet ID and password in the username and password fields
- Not connected to VPN when using wireless or from off-campus
If none of these options resolve the problem, please contact Technology Help.