Data access granted to UGA Elements can be either Reporting access or Systems Integration access; both are defined below. OFA assumes that requestors have access to the technical expertise to take advantage of the type of access granted.
Reporting Access
Reporting access is read-only access to the UGA Elements Reporting Database, hosted by Symplectic on AWS
Technical Knowledge Required
- Expert-level SQL query and report writing skills
- Experience with either SQL Server Management Studios, SQL Server Reporting Services, or other SQL Compliant Reporting Tools (Crystal Reports, etc.)
Deliverables
- SQL Connection String
- SQL Credentials
Tools Suggested
PC: SQL Server Management Studio
Mac Alternative: SQL Pro for MSSQL
–OR–
PC: Microsoft® SQL Server® 2016 Report Builder
–OR–
PC: Visual Studio
Mac Alternative: Visual Studio Code
Systems Integration Access
Systems Integration access is provided through the Elements API.
Technical Knowledge Required
- Working knowledge and experience with XML Parsing using XPath methodology
- Proficiency in some programming language
Deliverables
- API URL
- API Credentials
- API Description
Tools Suggested
There are no special tools required for API access. It is up to the developer what tool is used to write code to interact with the API within the specified terms of use with regards to limit utilization to off hours.