What New Data Warehouse Users Need to Know

Last Updated: August 28, 2024 4:28:17 PM PDT

Here's what you need to do to access the central campus data stored in the Data Warehouse.

Using the Data Warehouse

If you use a Link family tool such as TritonLink or FinancialLink, you are accessing the Data Warehouse. If these tools don’t give you what you need, you can use QueryLink, SQL Executer, or a SQL based tool to get the data yourself.

Getting access

All information requires an ID and password for access. More secure information requires security approval from your Departmental Security Administrator (DSA).

You can check on what access you currently have in AccessLink (login). If you have access to central office data, IFIS, ISIS, or PPS, you can be granted access to the same data in the Data Warehouse. This will also give you access to the Link family of products. Check with your DSA for more details.

Retrieving the data

Determine how you’ll access the data. You can use Web-based tools such as QueryLink and SQL Executer, or Microsoft Access, Excel, or WISQL.

Using QueryLink: QueryLink is the preferred way to access data because you don’t need to know a programming language. Just click the Queries button on the left column of EmployeeLink, FinancialLink, or Student/ Class Info tools.
- QueryLink resources:
  Overview
  Beginner's guide
  Tutorial (PPT)
Using SQL: If you know Standard Query Language (SQL) you can request the data in particular formats or more specific ranges. First, you should determine your required data subject area(s). See the Data Models in DataLink.
- SQL resources:
  SQL Executer Help
  SQL Executer

Formatting

FinancialLink, Blink Student/ Class or TritonLink applications, EmployeeLink, and in some cases QueryLink, supply data in printable report formats. When you use SQL Executer, and most times with QueryLink, you’ll need to format retrieved data with a reporting tool such as Excel, Paradox, or Access.

Training

Data Warehouse training centers on SQL basics and subject-oriented classes. QueryLink training classes are also available. You should have a basic understanding of your subject matter before attending a class.