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 Advisor
(DSA).
You can check on what access you currently have
in AccessLink. 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 Blink Student/ Class Info.
- 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.
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.
| 
At Your Service Online
