Data Catalog

Owned by Steven Richardson
Last updated: Dec 11, 2024 by Brandi Belleau
2 min read

Upcoming Changes to Data Infrastructure

Pitt IT Analytics is actively building a modern data lake and lakehouse (i.e. data warehouse) hosted in AWS, which should impact only users with a database account.

Currently, data from the Student, Employee, and GL marts is served to the campus community from our on-premise Oracle data warehouse. Users with a database account and an appropriate VPN role can connect directly to the data warehouse to retrieve data with SQL.

For more information, please visit the Analytics Modernization page.

Data Available for All

Through the University’s Federated Authorization process, the following data sources are available for connection via Tableau data sources and dashboards, Cognos reports and query packages, and via direct SQL access.

Where to Begin with Access Requests

First, read through the “Getting Started” article in Pitt IT’s Knowledge Base. Then, speak to your Federated Authorization contact so they can understand your needs and be prepared to review your request.

Click on one of the links below to identify the appropriate Federated Authorization contact.

Specialized Data

The following data sources are currently available as part of an existing dashboard, or via special request/use case. For more information on these data sources, please contact the Pitt IT Helpdesk.

  • PERIS

  • Concur

  • Insite

  • RMS

  • Suitable/Outside the Classroom Curriculum

  • Salesforce

  • Faculty Information System

Access to Analytics and Reporting Tools

  • Tableau Desktop and Tableau Server - please visit Tableau page for information on acquiring Tableau

  • Cognos - Users who have requested and been granted access to the Student Mart, Employee Mart, or GL Mart listed above automatically have access to existing reports and ad hoc report creation capability in Cognos.

  • Oracle Analytics Cloud - please visit https://prism.pitt.edu/oracle-analytics-cloud-oac/ for information on access to OAC.

 

Need help? Contact the Pitt IT Helpdesk