Provides end-to-end ETL/ELT data processing, ensuring data ingestion, transformation, storage, and availability for analytics and reporting. Pipelines support structured and semi-structured  data formats across multiple technologies and data sources. Specific services supported are dependent on the individual pipeline, but may include automated scheduling, monitoring, error handling, and/or validation to maintain data integrity and reliability. 

Available To: Campus customers.
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Automated ETL/ELT Pipelines: Extracts, transforms, and loads (ETL/ELT) data from various sources into the Data Hub. 
• Support for Multiple Data Formats; Data formats to be agreed upon by customer and D2I.
• Data Validation and Quality Checks: Ensures data integrity, consistency, and compliance with governance policies. 
• Pipeline Monitoring and Alerts: Automated monitoring and notifications for pipeline failures.
• Metadata Documentation: Data lineage and transformation logic are documented in Alation. 

• Timely and Accurate Data Refreshes: Pipelines adhere to predefined refresh schedules to ensure up-to-date data availability.   
• Incident Resolution: Issues affecting data availability are addressed based on business impact and an estimated time to resolution will be provided to customers within normal business hours.
• Uptime and Reliability: During business hours, pipeline downtime will be addressed promptly. Any after-hours downtime of pipelines will be addressed the next business day, with a goal of proactive monitoring to minimize downtime.

Ensures secure, scheduled replication of structured mainframe data, enabling downstream analytics and institutional reporting. 

Available To: Campus partners requiring access to Mainframe data in the cloud.
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Scheduled replication of Mainframe data.  
• Data validation and monitoring to ensure accuracy.
• Seamless access via SQL and analytics platforms.
• Metadata changes and reloads of the data.

• Data is refreshed on a regular cadence and made available based on predefined schedules.  

Allows campus users to upload and process CSV data into the Data Hub. The service ensures schema enforcement, governance compliance, and seamless data integration while supporting structured data ingestion from flat files.

Available To: Campus analytics users who rely on CSV-formatted flat files for data integration; Departments requiring scheduled data loads into the Data Hub.
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Automated ingestion of CSV files into the Data Hub. 
• Supports SFTP.

• 24/7 availability for CSV ingestion. 
• Incidents are reviewed and addressed at the start of the next business day. 
• Data stewards impacted by service outages are notified proactively.  

Provides schema-based access control, allowing campus teams to securely store, tranform, and manage database objects within their own workspace in the Operational Data Store (ODS) within the Data Hub. The service facilitates role-based access management, schema provisioning, and governance enforcement to support self-service data transformation and analysis. Additionally, it ensures that access is compliant with security and governance standards, maintaining auditability and controlled data integration with other sources.

Available To: Campus analytics teams requiring dedicated database development environments for structured data transformations and reporting; Faculty and staff working with analytics and reporting on institutional data.
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Schema setup and access control. 
• Data management and integration support. 
• Compliance with security and governance standards.
• Provisioning of dedicated schemas within the Data Hub’s Operational Data Store (ODS). 
• Role-based access management to ensure security and compliance. 
• Integration support to enable seamless data analysis across institutional data sources.
• Schema maintenance and updates to ensure data integrity and compliance with evolving data governance policies. 
• Monitoring and auditing for access and usage to align with university data governance policies. 

• Operates 24/7 to support analytics and reporting needs.
• Provisioning Timeline: Schema requests are processed within one business day, pending governance approval.
• Access Management: Requests for access changes are completed within one business day, with immediate revocation for security risks.
• Incident Response: Issues during business hours are addressed the same business day when possible; Issues outside of business hours will be evaluated the next business day.

Involves setup, configuration, and ongoing maintenance of cloud infrastructure to support business and technical needs. It ensures high availability, scalability, and security while integrating with existing cloud and on-premises systems. The service covers provisioning of compute, storage, networking resources, as well as continuous monitoring, patching, and performance optimization.

Available To: Business units requiring new cloud infrastructure associated with the Data Hub; Third-party vendors integrating Data Hub services.
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Provisioning of new cloud resources (compute, storage, networking).
• Architecture, design, and setup based on specific business requirements.
• Integration with monitoring tools and cloud security practices.
• Documentation of infrastructure setup and configuration.
• Weekday monitoring of cloud infrastructure.
• Performance optimization and troubleshooting.
• Security patch management and vulnerability assessments.
• Infrastructure health checks and alerts.
• Backup and disaster recovery support. 

• Provisioning: Requests are addressed on a case-by-case basis based on infrastructure complexity.
• Uptime and Reliability: Proactive monitoring to minimize downtime.
• Incident Response: High-priority issues addressed within two hours; Standard incidents resolved within one to three business days.
• Security and Compliance: Monthly security patches and vulnerability assessments to ensure compliance.
• Provisioning Requests: Email request with detailed infrastructure needs (compute, storage, networking) and configuration requirements.
• Incident Reporting: Include timestamps, error logs, and system impact for expedited resolution.
• Change Management: All changes follow the D2I Change Management Process with stakeholders notified of planned maintenance. 

Provisions and maintains user access to the UT Data Hub, ensuring compliance with security policies and governance principles. It includes support and troubleshooting for Database User Management. The service ensures that users have the appropriate permissions while following the Principle of Least Privilege to maintain security and minimize risk.

Available To: Business units that require access to the Data Hub or Legacy databases; D2I users involved with data management services.
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Provisioning and Maintenance: Managing user access and permissions to the Data Hub.
• Database User Management: Supporting and maintaining the Database User Management for password resets and access governance.
• User Support and Troubleshooting: Addressing permission issues, onboarding new users, and assisting with security policies.
• Security and Governance: Ensuring compliance with governance policies and managing role-based access control.  

• Provisioning Requests: Completed within two business days, assuming all approvals are in place.
• Support Requests: Responded to within one business day for troubleshooting and issue resolution; Complex requests may take longer than two business days.
• Security and Compliance: All access requests are reviewed under governance policies to maintain security and ensure minimal risk. 

Provides the setup, provisioning, and maintenance of cloud infrastructure to support the hosting of the Tableau Server cluster for D2I customers. It ensures integration with existing cloud or on-premises systems, providing high availability, security, and scalability for business intelligence workloads. This includes version upgrades, monitoring, troubleshooting, and security management. 

Available To: Business units requiring Tableau analytics.
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Provisioning and configuration of Tableau Server cluster on AWS.
• Version upgrades to maintain supported versions and security patches.
• Integration support with AWS services (e.g., RDS) and on-prem systems (e.g., Exadata).
• Implementation of monitoring tools and security measures for stability and compliance.
• Documentation of infrastructure setup, including configuration and best practices.

• Availability: Proactive monitoring to minimize downtime.
• Incident Management: Critical failures are reviewed within 24 hours.
• Change Management: All production changes go through the formal Change Management process to ensure compliance and stability. 

Provides enterprise-level Tableau visualization hosting to support campus-wide analytics and reporting. Facilitates access, authorization, and developer support for CSU analytics teams.

Available To: Faculty and Staff
Cost: This service is provided as a common good for a limited number of licenses; Other licenses may be purchased for a fee by the CSU.
Support Contact: d2i-support@utexas.edu

• Enterprise Tableau hosting services are available to CSU analytics developers. 
• Creator licenses allow CSUs to build, deploy, and maintain Tableau dashboards and visualizations.

• Tableau platform availability supports institutional reporting and analytics needs. 
• Creator licenses are issued and managed based on CSU needs and licensing agreements. 
• Automated alerts are generated 24/7 for any detected system exceptions. 
• Incidents are reviewed and addressed at the start of the next business day. 
• Downstream consumers are promptly notified of any service outages.

The Insights Service can be found at insights.utexas.edu. D2I provides troubleshooting for any issues users may experience with reports in Insights or with the Insights service itself. D2I also accepts requests to add existing campus reporting and analytics resources to the Insights Service.

Available To: Faculty and Staff
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: insights@utexas.edu

• Insights is an online tool that provides one location for faculty and staff to search for and discover shared and trusted campus information. 
• This tool is managed by the D2I team who use it to aggregate resources from colleges, schools, and units, as well as D2I-created reports and analytics.
• Resources published by D2I are intended to be used to assist CSUs and university leadership in answering common campus-wide questions. 

• Routine troubleshooting requests will be addressed within one business day. 
• Requests to add existing resources will be addressed within three business days.

D2I provides guidance and connections related to general campus-wide data and analytics questions. D2I cannot always fulfill the requests, however, advice and direction to existing resources  can be provided.

Available To: Faculty and Staff
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: insights@utexas.edu

• Email-based inquiry system to receive general questions from campus related to data and analytics. 
• Review, response, or referral by university data management and analytics experts.

• Questions submitted to insights@utexas.edu will receive a response within three business days.

Tailored customer support for using shared analytical objects and data models within the UT Data Hub. Includes guidance and consultation on analytical best practices for Data Spoke users.

Available To: Faculty and Staff
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: insights@utexas.edu; D2I Data Spoke Community Team + private CSU support channels.

• Email-based inquiry system to receive general questions from campus related to shared analytical objects and data models.
• Review, response, and guidance by university data management and analytics experts.
• General D2I Data Spoke Community Team and CSU-specific Teams channels to facilitate issue visibility and support for data spoke users.
• Training program and resources to educate campus analysts on accessing data in the UT Data Hub.

Provides support for the OHS crosswalk tables that consolidate financial (unit code), non-financial (Department System department code) and academic compliance reporting (IRRIS department code) organizational hierarchies.

Available To: Faculty and Staff
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Load, process, documentation, and customer support.

• Support and general questions will receive a response within one business day.

Provides oversight, education, training, and support for use of the University’s metadata management tool. Alation is an online metadata management tool and data catalog providing documentation for D2I data sources, data models, and analytics deliverables.

Available To: Faculty and Staff
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: alation-help@austin.utexas.edu

• Support of the tool including upgrades and testing.
• Metadata content curation.
• Onboarding, training, and support of users.

• Support and general questions will receive a response within one business day.

Provides daily propagation of UT Mainframe data to the legacy data warehouse to support reporting and other applications. 

Available To: Existing customers only.
Cost: This service is provided as a common good to campus with no cost associated; Currently in sustainment mode.
Support Contact: d2i-support@utexas.edu

• Provides the bulk of UT mainframe data contained in the on-prem data warehouse. 
• Applies to any Adabas source file on the UT mainframe in compliance with data governance policies.
• Maintenance only for existing files; no materialization of new files.

• Data is loaded on varying set schedules as agreed upon and is available in the data warehouse  at a time communicated to customers
• Ad hoc refreshes for time-sensitive reporting are available on request. 
• Changes to source schema are reflected pending coordination with D2I and requires two weeks lead time.

Provides secure access to institutional data in the legacy data warehouse through curated REST API endpoints, enabling operational and analytical applications to retrieve structured data efficiently. 

Available To: Existing customers only.
Cost: This service is provided as a common good to campus with no cost associated; Currently in sustainment mode; No new API endpoints will be developed.
Support Contact: d2i-support@utexas.edu; Questions about source data may be escalated to departmental SMEs for resolution.

• Data is sourced from the legacy data warehouse. 
• Curated data feeds are designed to address common customer use cases. 
• Customer access requires approval from designated data stewards before use.    

• API services operate 24/7 to ensure uninterrupted access. 
• Source data is refreshed once daily, with updates available by 6:00 AM.

Provides maintenance and support for legacy dimensional data models that provide structured, analytical-ready data from key institutional business domains to facilitate internal reporting and analytical development. Current legacy subject areas include Instruction, Finance, and Enrollment. These models serve as foundational data structures for internal and select campus reporting needs.

Available To: Existing customers only.
Cost: This service is provided as a common good to campus with no cost associated; Currently in sustainment mode with sunset pending.
Support Contact: d2i-support@utexas.edu; Questions about source data may be escalated to departmental SMEs for resolution.

• Data sources vary by model and are only sourced from the legacy data warehouse.    

• Model data is available 24/7 to ensure accessibility for reporting and analytics. 
• Models are refreshed daily or intraday depending on business requirements, with data available by the start of the business day.
• Any issues in the scheduled midnight and mid-day refreshes are addressed immediately to minimize disruption to critical enrollment management processes.

Supports daily processing of data from legacy data warehouse into the custom target tables that enable downstream academic applications and reporting for customers in the Executive Vice President and Provost (EVPP) portfolio.

Available To: Executive Vice President and Provost (EVPP)
Cost: This service is provided as a common good to campus with no cost associated; Currently in sustainment mode.
Support Contact: d2i-support@utexas.edu

• Data is sourced from the legacy data warehouse. 
• Custom ETL processes transform and load data into the target tables. 
• Downstream applications consuming these tables are developed and maintained by the Enterprise Technology Enterprise Platforms team.   

• Processes run daily to ensure timely data availability for downstream applications and reporting. 
• After hours incidents are reviewed and addressed at the start of the next business day. 

Provides on-demand, ad hoc refreshes (as well as special nightly refreshes) of accounting data to support the development and validation of the UT System Annual Financial Report (AFR). Close coordination is maintained with the Accounting and Financial Management (AFM) team throughout to ensure timely and accurate data availability.

Available To: Accounting and Financial Management (AFM)
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: Designated AFM coordinators request refreshes via dedicated e-mail list or Teams channel.

• Critical accounting tables are refreshed from the UT Mainframe to the legacy data warehouse outside the standard daily processing window, ensuring up-to-date financial data is available for AFR preparation. 
• On-demand refreshes occur throughout the AFR reporting cycle, which peaks in September and October. 

• On-demand data refreshes are completed as soon as possible, subject to mainframe processing, source, and target availability. 
• Support is available during business hours throughout September and October, with extended coverage on weekends and evenings during peak AFR development periods. 
• Any refresh failures or issues are resolved as soon as possible to minimize disruption to the AFR preparation process. 
• Requests received outside of business hours will be completed by the start of the next business day.

Supports the ad hoc refresh of accounting data on the fifth business day of each month, following the monthly close process, to ensure financial reports are updated and available the following morning. The Monthly Close Coordination email list informs D2I upon close process completion. A D2I support analyst acknowledges and confirms the data refresh is complete via the same email list.  

Available To: Accounting and Financial Management (AFM)
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Critical accounting tables are refreshed outside the standard daily processing window to reflect month-end financial data.  

• Refresh is initiated after Accounting and Enterprise Technology Enterprise Platforms team analysts confirm the monthly close process is complete, typically performed after business hours on the fifth business day of the month. 
• Dependent Cognos reports are refreshed overnight and made available by the start of the following business day. 
• Any issues or failures identified are resolved promptly to ensure data and reports are available by the following morning. 

Supports ad hoc refreshes of Registrar’s Office data to facilitate census reporting during Spring and Fall semesters and to support annual President’s Memo in the fall. Data refreshes are coordinated closely with the institutional Research, Reporting, Information, and Surveys (IRRIS) team’s validation process to ensure accurate and timely updates for institutional reporting and executive-level communications.

Available To: Institutional Research, Reporting, Information, and Surveys (IRRIS)
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Refresh of five IRRIS data sources and corresponding IQDirect tables from the legacy data warehouse. 
• Verification of successful updates in dependent Cognos reports after data refresh.  

• On-call support on completion of IRRIS validation process on mornings following 4th, 8th, 12th, and 20th class days to initiate data refreshes.  
• Issues are resolved in coordination with IRRIS to ensure successful refresh completion.   
• Consumers are notified if delays or failures occur.

Supports ad hoc data processing and data refreshes to ensure the timely submission of procurement data for monthly and biannual statutory reporting requirements.  

Available To: Accounting and Financial Management (AFM) and Procurement Office
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Automated process requiring minimal intervention. 
• Verification checks ensure successful completion. 

• Manual data refresh and Cognos cube build performed on demand to support reporting deadlines. 

• Automated data refresh; Reporting deliverables are updated and refreshed on demand at the customer's request.  
• Bi-annual TPASS refreshes are completed the same day as the customer request, provided the request is received within business hours.   
• Alerts are generated 24/7 for process failures or exceptions. 
• After hours incidents are reviewed and addressed at the start of the next business day.  
• Impacted consumers are promptly notified in case of failures or disruptions.
• Reporting updates are provided to the customer for data validation before being published to the production environment.

Provides daily synchronization of legacy data warehouse tables into an Oracle Exadata schema, enabling customers to access institutional data directly via SQL for operational processing and application development. This service ensures timely and consistent data replication to support legacy reporting and data integration needs.

Available To: Existing customers within CSUs utilizing IQDirect for operational reporting and application data access.
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Automated daily synchronization of designated tables from the legacy data warehouse.
• Provides separate environments for development and validation.
• Ensures data consistency for downstream operational processing and integrations.
• Supports SQL-based access to institutional data for analytics and reporting.

• Daily data refresh is completed by 5:00 AM to ensure up-to-date information availability.  
• Monitoring and incident response to maintain service reliability.  
• Database administration and troubleshooting to ensure stability.  
• Customers are notified promptly of any refresh failures or service outages.

This service provides a centralized Cognos server and authoring environment for campus analytics developers to create reports and data cubes from institutional data. The service maintains institutional reports and cubes for common use across campus and supports access control, authorization, and developer assistance. As a sustainment service, new development in Cognos is discouraged where alternative solutions exist. Users with author permissions can still develop reports for their production needs.

Available To: Faculty and staff requiring access to institutional reports, cubes, and reporting tools.
Cost: This service is provided as a common good to campus with no cost associated.
Support Contact: d2i-support@utexas.edu

• Secure hosting of Cognos reporting and analytics tools.
• Maintenance of institutional reports and data cubes for widespread campus use.
• Pre-packaged datasets providing structured access to legacy data warehouse information.
• Governance-based access control requiring CSU approval.
• Developer support for report authoring and troubleshooting.
• Multi-dimensional cube modeling.

• Platform Availability: Ensures Cognos platform aligns with campus reporting needs and maintains high uptime. 
• Incident Response: D2I actively monitors Cognos operations, responds to incidents, and resolves data package inquiries.
• Data Updates and Support: Institutional reports and cubes are maintained and updated as required.  
• Incident Management: Issues are reviewed and addressed at the start of the next business day.
• Outage Notification: Downstream consumers are promptly notified of service disruptions.