SQL Developer: Use AppsToGo to Run SQL Developer

AppsToGo is an online service that can be used to run SQL Developer. With AppsToGo, no installation of SQL Developer is required.

Before accessing SQL Developer, you will need to:

  1. Request access to SQL Developer via AppsToGo. Email [email protected] and request that SQL Developer be added to your AppsToGo
  2. Install Citrix Workspace on your computer
  3. Use Kumo to link your Google Drive account (if you want to export query results)

For more information about using AppsToGo, please refer to the AppsToGo self-help guide.

Access SQL Developer

  1. Open a web browser and visit https://apps.umn.edu
  2. Log in with your University of Minnesota Internet ID and Password
  3. Click SQL Developer 19
    1. If you do not see SQL Developer 19, please email [email protected] and request it be added to your AppsToGo environment
    2. If you are using Chrome, a small file will download. Look in the downloads folder and open the file that ends with ".ica". Please refer to the knowledge article AppsToGo: Use Chrome Web Browser
      • SQL Developer will open

Log in to the Data Warehouse using SQL Developer

  1. Double-Click DWEPRD.WORLD in the Connections palette in the left sidebar of SQL Developer.
  2. When prompted, enter your University of Minnesota Internet ID and password.
    1. The maximum length of a password for Oracle databases is 25 characters. If your University password is more than 25 characters, you will need to change it so that it is 25 characters or fewer.
    2. If your account is using DUO, the default authentication will be used.
      1. The first time you try to log in, the default authentication might not be triggered. If you are not receiving the DUO authentication, use the append mode listed in the DUO Guide to Two-Factor Authentication to force it.
      2. If you are still unable to log in, please contact Technology Help for assistance.

Override Your Default DUO Authentication Method

You can override your default authentication by using append mode. For example, you can have DUO call your desk phone instead of sending a push to your mobile device.

Run or Create a Query in SQL Developer

  1. A new tab will appear in the workspace where you can enter the query. Type in a new query, or paste in a query.
  2. Click the green run button in the Query Builder toolbar to execute the query.
  3. The query results will be displayed at the bottom in the Query Results panel.
    1. You can copy and paste the results into another application

Browse the Tables and Views in the Data Warehouse

  1. Right-Click DWEPRD.WORLD in the Connections palette in the left sidebar of SQL Developer
  2. Select Schema Browser. The schema browser will be displayed, and your name will be selected.
  3. Click the arrow to the right of the name selector
    1. Select Filter Schemas. The filter schema dialog is displayed.
      the options filter schemas and clear schemas filter. the filter schemas option is highlighted.
  4. In the filter box, type DWSYSADM
    1. Click OK. The DWSYSADM schema is displayed.
  5. All tables that you have access to are displayed.
    1. Double-click a table to view information about the table.
  6. Click the drop-down beneath DWSYSADM to view other objects -- for example, Views.
    the objects selector showing Tables, Views, Indexes, Packages, etc.

Copy Query Results

If there isn't too much data in the results, you can copy/paste the query results into Excel.

  1. Click any item in the query results panel
  2. Press CTRL+A (windows) or COMMAND+A (mac) to select all of the data
  3. Press CTRL+SHIFT+C (windows) or COMMAND+SHIFT+C (mac) to copy all of the data including the headers
    1. Note: using CTRL+C or COMMAND+C will copy ONLY the data (not the headers)
  4. Open an Excel Workbook, or a Google Sheet
  5. Click in the spreadsheet
    1. Press CTRL+V (windows) or COMMAND+V (mac) to paste the data

 

Export Query Results

To export the query results, you will need to have configured Kumo to link to your Google Drive account. You only need to do this once.

  1. Right-Click (mac: CTRL-Click) on any item in the query results area. A contextual menu is displayed.
  2. Select Export. The Export Wizard is displayed.
  3. Choose a format for the exported data.
    1. Note: when the drop-down list opens, it will be in the middle of the alphabetical list of export formats. Scroll up to find CSV or Excel format
    2. Depending on the format selected, a set of options will be displayed. They can all be left with the default selections.
  4. Click the Browse button next to the file location. The Save dialog is displayed.
    1. Click the Location selector at the top.
      1. Select Google Drive (I:)
      2. Browse to the location where you want the file saved within your Google Drive account.
    2. Enter a File Name
    3. Click Save. The save dialog is closed, and the Export Wizard is displayed.
  5. Click Next. The Export Summary is displayed.
  6. Click Finish. The file will be saved to your Google Drive in the location that was specifed in step 4 above.
TDX ID
3778