Introduction

The purpose of this document is to provide information on how a customer may connect and access This is a technical guide for the Regent Award Data Extract Views and query Views. This guide provides information about the type of data views available, view versioning policies, conventions and information on how to connect to the database where the data views to obtain informationreside. 

How to Access the Views

Summary

This section of the training is provided to assist customers in accessing the data views which can be used to obtain data that cannot be currently obtained via the Regent Award application or to obtain large amounts of data which if accessed via Regent Award may have a negative impact on application performance. For the purposes of this training SQL Server Management Studio is used The Regent Award Data Views are made accessible via a reporting database (RPT) that is configured specifically for this purpose. This database is a copy of QA or Prod, depending on which instance you are accessing. The database name will follow the pattern <clientname>_rem_<instance>_rpt. For example, the reporting database for "Frederick College" Regent Award QA2 instance would be something similar to frederickcollege_rem_qa2_rpt. These specific details of database name and IP will be provided to you by the Regent Education Operations team at the time data views are configured for your instance. 

The reporting database is a MIcrosoft SQL Server 2008 (or later) database. Any application that offers an integration/connection method to Microsoft SQL Server (MSSQL)  can be used to connect to the data views reporting database. Below you will find instructions on how to use SQL Server Management Studio to access where the data views are stored. SQL Server Management Studio Express can be obtained free from Microsoft via this link httphttps://wwwdocs.microsoft.com/en-us/download/details.aspx?id=7593/sql/ssms/download-sql-server-management-studio-ssms.

Connect to VPN and SQL Server Management Studio

...

The views offer access to nearly all data surfaced by the Regent Award interface as well as some data that is not available in the user interface. Some of these views have been deprecated and replaced by newer versions. The view versioning policy is explained below. 

Data Extract View Groups and Conventions

...