Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open a web browser window and go to the Virtual DBeaver URL -

    https://rdweb.wvd.microsoft.com/arm/webclient/index.html

  2. Choose "Virtual DBeaver"

  3. At the "Access local resources" prompt, click Allow
  4. At the "Enter your credentials" prompt, enter your full Cornell email address in the Username field and your email password in the Password field, then click Submit.
  5. Click the DBeaver shortcut on the desktop to open DBeaver. If this is your first time connecting, please follow the instructions to "Configure Your Connection to the Reporting Database in Virtual DBeaver." 
  6. From the SQL Editor menu, choose New SQL script

...

To select the report query you would like to run, go to the FOLIO Canned Reports Directory.

  1. Click the query code link (e.g., CR100)
  2. Click the sql file to open it
  3. Click Raw in the top right corner of the window
  4. Click Ctrl+A then Ctrl+C to select and copy all the text of the query
  5. Return to your Virtual DBeaver window
  6. Click Ctrl+V to paste the text of the query into the New SQL script window
  7. From the File menu, select Save to save this query in DBeaver with a filename and the ".sql" file extension
  8. From the SQL Editor menu, choose Execute SQL Script to run your query
  9. Review your results in the bottom half of your window

...