Skip to main content

System Status: 

How to Download and Print from the Data Warehouse

Read about how to use a SQL Executer query to download and print data from the Data Warehouse into an Excel formatted file.

The instructions are valid for Internet Explorer 6.0 and above on a PC.

1. Enter your information.

  • Enter your SQL statement.

    SQL statement screen
  • Select the schema.

2. Select the options you want.

  • Under Output Options, click the drop-down box next to Send data on the list of choices.
  • Select the PC file option.
  • Choose the File Type Spreadsheet.

3. Run the query.

  • Click Run Query in the Database Login Parameters section.

4. Save File.

A dialog box will appear, informing you that you are starting to download a file. You can choose one of three buttons appearing in the dialog box.

  • Open will launch Microsoft Office Excel to open with the data you requested.
  • Save  will allow you to save the output to a Microsoft Office Excel worksheet.
  • Cancel will close the dialog box.
  • Click on the Save to save the file.

File download screenshot

5. Enter the file name.

Browse the file location where you want to save the file and enter the file name.

  • When the information is entered, click Save.

Save as screenshot

6. Print the data file.

  • Either use Print Options in the Excel file or click the printer icon at the top of the page.
For more information, contact the ITS Service Desk, (858) 246-4357 or ext. 6-HELP.