AMS System Outage – April 5

Date: March 27, 2025
To: AMS Users
From: Enterprise Applications & Solutions Integration
Re: AMS System Outage – April 5

 

Dear AMS Users,

Please note the systems below will be unavailable on Saturday, April 5 from 5 to 8 a.m. due to required timely maintenance:

  • Academic Administrative Appointments (AAA)
  • AMS SAP GUI
  • Capital Projects Portal
  • Employee Self-Service (ESS)/Manager Self-Service (MSS)
  • EvoSuite Applications (EvoOrder, EvoPlan, EvoNotify)
  • Expense Reimbursement Direct Deposit (ERDD)
  • Fiori Launchpad Reporting
  • Invoice Workflow
  • My Customer Account
  • My Research (MR/Portal)
  • SAP Asset Manager Mobile (sync will not work)
  • uSOURCE

See our System Availability page for a list of ongoing information on system status.

Sincerely,
Enterprise Applications & Solutions Integration (EASI)

Migration from Azure Data Studio to Visual Studio Code

Join Connect+Learn for as session with the Reporting & Analytics Technology Team to learn about the upcoming migration from Azure Data Studio to Visual Studio Code. Microsoft announced that it will be consolidating its SQL development tools to provide a more robust and feature-rich environment, and will be retiring Azure Data Studio on February 28, 2026. To ensure continued support, security and access to a feature-rich environment, we recommend that current Azure Data Studio users transition to Visual Studio Code by October 14, 2025.

In this session, we will discuss:

  • An overview of the migration to Visual Studio Code.
  • What’s changing, including key similarities and differences to Azure Data Studio.
  • A demo of how to download and connect to Visual Studio Code.
  • An overview of support resources on the Power BI site.

 

 

Resources

Important Update: Migration from Azure Data Studio to Visual Studio Code

Date:  March 11, 2025
To:   Azure Data Studio Users
From:  Enterprise Applications & Solutions Integration
Re: Important Update: Migration from Azure Data Studio to Visual Studio Code

 

Dear Azure Data Studio Users,

We are writing to inform you that Microsoft will be consolidating its SQL development tools to provide a more robust and feature-rich environment, and will be retiring Azure Data Studio on February 28, 2026. To ensure continued support, security and access to this environment, we recommend that current Azure Data Studio users transition to Visual Studio Code by October 14, 2025. We also recommend that new users follow these instructions to onboard to Visual Studio Code and visit the Power BI Toolbox for more support.

What do you need to know?

  • Visual Studio Code is very similar to Azure Data Studio, offering a similar interface, functionality and support for the same on-premises and cloud data platforms on Windows, macOS and Linux.
  • There will be no changes to your SQL queries and all existing queries will continue to connect to the same databases. This transition represents minimal change impact, unlike the previous shift from Rocket Shuttle to Azure Data Studio.
  • Current Azure Data Studio users may contact their divisional IT administrators for help with installing the tool by October 14, 2025.
  • New users may contact their divisional IT administrators for help with installing this tool.

What’s changing?

  • Current and new users will need to install an extension and then set up the connection to Visual Studio Code.
  • There are some minor changes to the interface, that can be tailored to individual preferences, which will not affect functionality of the tool.
  • Watch this video to learn more about the upcoming transition and key similarities and differences between Azure Data Studio and Visual Studio Code.

What’s Next?

  • Join us for a Connect+Learn session on March 25, 2025, at 11 a.m., where you can gain a deeper understanding of the upcoming change.

If you have any questions, please visit the Power BI Toolbox and submit a support ticket.

Sincerely,
Reporting and Analytics Technology Team
Enterprise Applications & Solutions Integration

AMS System Outage – March 22

Date: March 3, 2025
To: AMS Users
From: Enterprise Applications & Solutions Integration
Re: AMS System Outage – March 22

 

Dear AMS Users,

Please note that the systems below will be unavailable on Saturday, March 22 from 5 to 11 a.m. due to system maintenance:

  • Academic Administrative Appointments (AAA)
  • AMS SAP GUI
  • Capital Projects Portal
  • Employee Self-Service (ESS)/Manager Self-Service (MSS)
  • EvoSuite Applications (EvoOrder, EvoPlan, EvoNotify)
  • Expense Reimbursement Direct Deposit (ERDD)
  • Fiori Launchpad Reporting
  • Invoice Workflow
  • My Customer Account
  • My Research (MR/Portal)
  • SAP Asset Manager Mobile (sync will not work)
  • uSOURCE

See our System Availability page for a list of ongoing information on system status.

Sincerely,
Enterprise Applications & Solutions Integration (EASI)

Reporting Tools and Downloads from ROSI and ROSI Express

This session will explore how staff in academic units and Registrars’ Offices can generate class lists, reports, and downloads of academic information from ROSI and ROSI Express. The initial focus of this session will be on the class list report which is generated from ROSI Express using Power BI. Attendees will be shown a basic feature set and how to navigate the refreshed interface. Following that, we will demonstrate the entire ROSI Download process, from setting up parameters, to importing text file output for use in Excel. The session will conclude with a discussion of the new output format in ROSI’s Diagnostic Reporting screens (e.g., sessional count) and how to convert output file formats.

Topics addressed:

    • Refresher of the PowerBI class lists reports available through ROSI Express
    • Review of ROSI report downloads (downloads available, formatting output, and new output header files)
    • Converting ROSI “list” reports (e.g., Registration diagnostics) to Excel
    • How to differentiate and convert between file types used in ROSI (e.g., *.TXT vs. *.PRN vs *.CSV)

 

Resources

EASI Go Prod SIS Updates – Dec. 1, 2024 to Feb. 28, 2025

Date:  March 3, 2025
To: ROSI Users; ROSI Express Users
From:  Enterprise Applications & Solutions Integration
Re:  EASI Go Prod SIS Updates – Dec. 1, 2024 to Feb. 28, 2025

 

Hi everyone,

Enterprise Applications & Solutions Integration (EASI) would like to update you on the latest major production releases and updates for Student Information Systems. The following are major changes from December 1, 2024 to February 28, 2025:

Accommodated Testing Services (ATS) 
Accommodated Testing Services coordinates on-campus assessment accommodations for students with disabilities who are enrolled in in-class courses offered on the St. George Campus. ATS has released the following enhancements:

  • Updated the Course Information System (CIS) Submission details page to track and display submission changes post-ATS review, ensuring timely and accurate accommodation test arrangements.
  • Implemented an Activity Log to track key events by ATS staff and instructors in CIS, improving service delivery and operational efficiency
  • Migrated the NO-SQL database to MongoDB Atlas, enhancing scalability, reliability and performance for future business needs.
  • Introduced the ability to update the time and date of ATS test definitions and have these updates sync between integrated systems, saving ATS staff from switching context to make updates.
  • Added ATS Review and CIS Submission Workflow Statuses to the test definition dashboard to speed up ATS staff workflows.

Course Information System (CIS)
The Course Information System streamlines syllabi and exams processes for instructors and administrators. The following improvements have been introduced: 

  • The initial release of the Reporting Hub module creates a centralized data access point, empowering faculty and staff with critical insights into student and course data. This release includes reports that help inform the streamlining of operations for divisional administrative staff.
  • Generated and provisioned Syllabus Builder and Final Exam documents for the Faculty of Applied Science & Engineering to streamline the Canadian Engineering Accreditation Board audit process, ensuring compliance and enhancing operational efficiency.

Curriculum Publisher (CP)
The Curriculum Publisher is an online application that allows divisions and departments to publish course and program offerings. Between December 1, 2024, and February 28, 2025, a divisional calendar was published for the Faculty of Applied Science & Engineering.

Student Information Systems (SIS) Core Systems 
The administrative and student core systems, including ROSI, ROSI Express, OASIS, ACORN, and Degree Explorer completed the following major releases:

  • Completed annual updates to the School of Graduate Studies correspondence letters to support the upcoming admissions cycle.
  • Completed and submitted T4A and T2202 tax records to comply with Canada Revenue Agency standards.
  • Completed SIN changes in ROSI and ROSI Batch to comply with Level 4 data classification.
  • Created a batch load for Advanced Standing courses and subjects, improving administrative efficiencies by allowing staff to update records in batch instead of individually.
  • Completed additional extracts to support U of T Mississauga’s use of Symplicity products.
  • Completed updates to support the Faculty of Applied Science & Engineering’s Primary Plan functionality, a process where students outline their course plans for the upcoming academic year, on Degree Explorer in preparation for the upcoming term.
  • Completed and released the first two milestones for the ACORN Profile and Settings project that includes a redesigned and more efficient address, phone number, SIN, and email maintenance areas.

Student Advising Service
The Student Advising Service team completed the 1.6 release, as well as the Salesforce winter 2025 and spring 2025 updates. Key highlights include user interface changes that ensured data accuracy when students change their preferred name, user experience and process improvements, changes to the search results display, and improvements to the note-taking interface.

Timetable Builder (TTB)
The Timetable Builder application allows students to easily create and optimize their course schedules with a convenient, user-friendly and accessible user experience. Between December 1, 2024, and February 28, 2025, EASI worked with U of T Scarborough to decommission their local time tabling tool, which was used as a source for the course notes on Timetable Builder. The work included decommissioning the integration with the local application in favour of using OASIS with other divisions to increase efficiencies.

Transfer Credit Equivalencies (TCED)
Transfer Credit Equivalencies Database (TCED) helps undergraduate and prospective students discover how courses will transfer for degree credit at U of T. Between December 1, 2024, and February 28, 2025, four new divisions were onboarded to TCED. These divisions are the Faculty of Applied Science & Engineering, the Faculty of Kinesiology & Physical Education, the Faculty of Music, and the John H. Daniels Faculty of Architecture, Landscape, and Design.

EASI Go Prod AMS & Enterprise Shared Services Updates – Dec. 1, 2024 to Feb. 28, 2025

Date: March 3, 2025
To:  AMS and Enterprise Shared Services Users
From:  Enterprise Applications & Solutions Integration
Re:  EASI Go Prod AMS & Enterprise Shared Services Updates – Dec. 1, 2024 to Feb. 28, 2025

 

Hi everyone,

Enterprise Applications & Solutions Integration (EASI) would like to update you on the latest major production releases and updates for U of T’s Administrative Management Systems (AMS) and Enterprise Shared Services.

The following are major changes from December 1, 2024 to February 28, 2025:

Financial Information System (FIS)

Serrala FS2AP Upgrade (February 10)
On February 10, EASI upgraded the Serrala technology to the most recent version to ensure the continued efficient processing of over 30,000 yearly invoices. The Serrala system provides users with an automated “invoice to pay” workflow. Using optical character recognition technology, invoices are automatically created in SAP which then kicks off the workflow routing the invoice for required review and approvals and then on to final payment.

Human Resources Information System (HRIS)

Vacation Payout Calculation (December)
In December 2024, the HRIS team implemented the necessary system changes to improve the accuracy of lump sum vacation payment calculation. Vacation entitlement reporting will be updated to reflect enhanced calculations, providing administrators with improved visibility into liabilities and risk.

Employee Central Project Phase 2A Completed (December)
In December 2024, EASI and the Division of People Strategy, Equity & Culture completed Phase 2A of SAP’s SuccessFactors Employee Central and Onboarding project, an initiative that will modernize HRIS processing from hire-to-retire, enhance data accuracy and improve employee self-service. Phase 2A included workshops to address business pain points and gather insights for future decisions on employee services, data migration and custom HRIS infotypes. This phase also highlighted additional design requirements. The team is now synthesizing gathered information and is planning the upcoming phase – detail design and implementation.

Enterprise Shared Services

Recent Graduates Email Offboarding (February)
From February 1 to 10, 2025, Enterprise Shared Services offboarded 18,093 email accounts for the 2024 graduating class, resulting in storage savings and improvements to security.

IT Change Management (February 19)
On February 19, Information Technology Services (ITS) launched a new IT change management process designed to increase visibility, efficiency, consistency and communication related to changes applied to ITS-managed systems and solutions. The EASI team implemented the new process in the Enterprise Service Centre/ServiceNow and provided training open to all ITS staff in support of the launch.

Research Information System (RIS)

New Outgoing Sub-awards Request Form Launch (February 18)
On February 18, EASI and the Division of the Vice-President Research & Innovation (VPRI) launched a new web-based form in the My Research portal that allows researchers to request the transfer of funding from their research award to a co-investigator at another organization. The information in the form flows to the VPRI Research Officer and allows them to establish or amend a sub-award agreement with the collaborating organization, making it easier and faster for researchers and VPRI staff to manage funding for hundreds of collaborative research projects. For more information, visit the My Research Funds (MRF): MROL and FReD Renewal Initiative page.

New ITS-wide change management process will streamline information-sharing

Illustration of a team directing an arrow on a chart upwards to demonstrate progress

Information Technology Services (ITS) is launching an IT change management process to increase transparency and awareness when specific IT changes are forthcoming, as well as to streamline the process by making it consistent across ITS teams and to help other IT@UofT staff gain greater visibility into ITS changes and their impacts.

The Enterprise Applications & Solutions Integration (EASI) team is leading this rollout, which will see ITS staff entering proposed IT changes into the Enterprise Service Centre (ESC) as a central hub for tracking, evaluation and approval as needed.

Want to learn more? Read the full story here.

 

Monthly SIS Training Resources & Support Session

Join us on the first Thursday of each month for an informative Connect+Learn session on SIS Training Resources & Support, tailored primarily for new ROSI users. The Student Information Systems (SIS) group manages enterprise student and curriculum applications, and processes for the University.

SIS provides reporting tools, enhancement and production request forms, and support for the SIS applications. In the session, we will discuss:

    • Student Information Systems (SIS): What we do
    • SIS Training Materials & Resources
    • How to Get Help
    • SIS: What We Support and What We Don’t
    • Using ESC Effectively: When to use ESC, how to write a ticket, and best practices for utilizing ESC services

 

Resources