ROSI Database Quarterly Maintenance – Friday, June 9
Date: May 9, 2023
To: ROSI Users; Registrar’s Offices
From: Enterprise Applications & Solutions Integration
Re: ROSI Database Quarterly Maintenance – Friday, June 9
To: ROSI Users; Registrar’s Offices
From: Enterprise Applications & Solutions Integration
Re: ROSI Database Quarterly Maintenance – Friday, June 9
Dear ROSI users,
Please note that we will need to take ROSI and most associated student information systems offline on Friday, June 9 from 5 p.m. to 9 p.m. to perform quarterly maintenance on the database. We will return the systems to service sooner if the work is completed earlier than 9 p.m.
In addition, while ROSI-REPLICA on MI will remain accessible during the maintenance, data will not be synced with ROSI starting at 5 p.m. It will be synced again at 9 p.m. when maintenance is complete.
The following systems will be affected:
- Accommodated Testing Services (Student and Admin)
- ACORN
- Course Information System
- Degree Explorer (Student and Admin)
- EASI Institutional File Transfer
- Elections
- eMarks
- Exam Photo Invigilation
- Online Administrative Student Information System (OASIS)
- ROSI
- ROSI Express
- ROSI Files
- Safety Abroad Student Registry
- Varsity Blues Registration System
- Web services/APIs
A notice will be posted on the ACORN launchpad and on social media so that students are aware of the outage.
Thank you for your patience as we make these improvements.
This email has been sent from a service account and does not accept replies. Please direct any follow up questions to the Enterprise Service Centre http://www.uoft.me/esc
Sincerely,
Student Information Systems
System Outage – May 14 from 6:00 am to 10:00 am
Date: May 3, 2023
To: AMS Users
From: Enterprise Applications & Solutions Integration
Re: System Outage – May 14 from 6:00 am to 10:00 am
To: AMS Users
From: Enterprise Applications & Solutions Integration
Re: System Outage – May 14 from 6:00 am to 10:00 am
Dear AMS Users,
Please note that the systems below will be unavailable on Sunday, May 14 from 6:00 am to 10:00 am due to system maintenance:
- Academic Administrative Appointments (AAA)
- AMS SAP GUI
- Capital Project Portal
- Employee Self-Service (ESS)/Manager Self-Service (MSS)
- Employees@UofT
- 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)
Getting Started with Power BI
Join Connect+Learn for a session on getting started with Power BI. The session will include the following:
- Use cases for demo
- Power BI demo
- Connect to data sources from Power BI
- Build Power BI report using visualization
- Publish report to a workspace in the cloud and share with users
- Schedule dataset refreshes in the cloud
- Subscribe to reports using user emails
- Connect to Power BI Shared Dataset
- Create an App with a package of reports and permission settings
- Resources: Power BI Toolbox and Training Videos Report
The following prerequisites for this sessions are:
- Downloaded Power BI Desktop Clients
- Connected to Cisco AnyConnect AdminVPN
- Granted access to UofT’s premium workspace (requested through ESC ticket)
- Have access to ROSI-REPLICA database (requested through ESC ticket)
Resources
Update: Azure Data Studio and Power BI Resources
Date: April 18, 2023
To: Azure Data Studio and Power BI Users
From: Reporting and Analytics Technology Team, EASI
Re: Update: Azure Data Studio and Power BI Resources
To: Azure Data Studio and Power BI Users
From: Reporting and Analytics Technology Team, EASI
Re: Update: Azure Data Studio and Power BI Resources
Hi everyone,
The Reporting and Analytics Technology Team at Enterprise Applications & Solutions Integration would like to provide you with an update on the latest resources for Azure Data Studio and Power BI.
Connect+Learn Presentation: Getting Started with Power BI
When: Wednesday, April 26 at 11 a.m.
Where: Join Microsoft Teams Meeting and Add to Calendar
The session will include the following:
- Use cases for demo
- Power BI demo
- Connect to data sources from Power BI
- Build Power BI report using visualization
- Publish report to a workspace in the cloud and share with users
- Schedule dataset refreshes in the cloud
- Subscribe to reports using user emails
- Connect to Power BI Shared Dataset
- Create an App with a package of reports and permission settings
- Resources: Power BI Toolbox and Training Videos Report
Training Videos
We have also published the following Azure Data Studio training videos:
- Getting Started with T-SQL in Azure Data Studio: Subqueries
- Getting Started with T-SQL in Azure Data Studio: Temporary Tables
- Getting Started with T-SQL in Azure Data Studio: Variables
You can view all introductory videos on our Training Resources page, and we will also be developing intermediate and advanced training videos shortly.
Finally, you can find all resources in the Power BI Toolbox.
If you have any questions, please contact Katie Babcock at katie.babcock@utoronto.ca
Sincerely,
Reporting and Analytics Technology Team
Enterprise Applications & Solutions Integration
Introduction to Power Automate
Join Connect+Learn for a session on Microsoft Power Automate (formerly Microsoft Flow). A service that helps you create automated workflows for repetitive business processes. Power Automate can send reminders on past due tasks, move business data between systems on a schedule, talk to many data sources. We will discuss:
- What Power Automate is
- Its building blocks
- Types of flows and what it can be used for
- Create a simple automatic workflow together
Resources
Reminder: AMS FI Fiscal Year-End Closure 2023
Date: April 18, 2023
To: AMS Users
From: Enterprise Applications & Solutions Integration
Re: Reminder: AMS FI Fiscal Year-End Closure 2023
To: AMS Users
From: Enterprise Applications & Solutions Integration
Re: Reminder: AMS FI Fiscal Year-End Closure 2023
Hi everyone,
As a reminder, this year AMS will close for FI year-end processing on Thursday, April 27, 2023 at 7pm and will re-open on Monday, May 1, 2023 at 7am.
ERDD and the Capital Projects Portal and Invoice Workflow will resume regular functionality on Monday, May 1, 2023 at 7am, and uSOURCE will resume operation at 9am.
The following summarizes the AMS system availability during the week prior to year-end closing:
| Date | Status |
| Tuesday, April 18 | System closes for bi-weekly payroll at 6pm |
| Wednesday, April 19 | System re-opens at 7am |
| Thursday, April 20 | System open regular hours |
| Friday, April 21 | System closes for monthly payroll phase 1 and for “Copy Plan to Budget” at 6pm |
| Saturday, April 22 | System re-opens at 7am |
| Sunday, April 23 | System open regular hours |
| Monday, April 24 | System closes for monthly payroll phase 2 at 5pm |
| Tuesday April 25 | System re-opens at 7am |
| Wednesday April 26 | System open regular hours |
| Thursday, April 27 | System closed to all users at 7pm |
| Friday, April 28 | System closed to all users |
| Saturday, April 29 and Sunday, April 30 | System closed to all users |
| Monday, May 1 | System re-opens at 7am except uSOURCE opens at 9am |
Please check our System Availability page for information on all systems.
For information on the impact of the year-end closing dates on reporting and processing, refer to the Financial Services website.
Please note that the Fiori Launchpad Reporting will be available.
Sincerely,
Enterprise Applications & Solutions Integration (EASI)
AMS Password Reset Available in the Enterprise Service Centre
Date: April 17, 2023
To: AMS SAP GUI Users
From: Enterprise Applications & Solutions Integration
Re: AMS Password Reset Available in the Enterprise Service Centre
To: AMS SAP GUI Users
From: Enterprise Applications & Solutions Integration
Re: AMS Password Reset Available in the Enterprise Service Centre
Dear AMS SAP GUI Users,
As you may be aware, in an effort to streamline processes, increase security and provide an improved user experience, Enterprise Applications & Solutions Integration (EASI) is working to update the current AMS Password Reset process.
Starting today, you can quickly and conveniently reset your AMS SAP GUI password in the Enterprise Service Centre. This new form will provide an automated email that will guide you through the process.
The current form on the EASI website will remain active until June 1, 2023, after which time it will redirect to the Enterprise Service Centre.
If you have questions about the password reset process, please review these FAQs.
Sincerely,
Enterprise Applications & Solutions Integration
Update on Microsoft Teams
Join Connect+Learn for an overview of some recent changes. Updates discussed will include:
- Delete Chats from your chat list
- Even more reactions at your fingertips
- Send your messages later
- Add people to chat with @mention
Resources
Rocket Shuttle Migration Update and Resources
Date: April 11, 2023
To: Rocket Shuttle Users
From: Enterprise Applications & Solutions Integration
Re: Rocket Shuttle Migration Update and Resources
To: Rocket Shuttle Users
From: Enterprise Applications & Solutions Integration
Re: Rocket Shuttle Migration Update and Resources
Dear past and present Rocket Shuttle users,
Thank you to those who offboarded from Rocket Shuttle on April 6 in advance of the expiry of the application’s license on May 17, 2023. We will be following up this week with select users who remain to be offboarded.
As mentioned in previous communications, we are offering many resources to support you in the transition to Azure Data Studio and Power BI:
- Watch training videos for Azure Data Studio and Power BI. We are currently working on intermediate and advanced-level videos and recently released the following:
- Drop in for online support on Wednesday, April 12 between 2:00 and 3:00 p.m. Find details on the Rocket Shuttle Migration project page.
- Participate in the Power BI & Azure Data Studio Community Channel.
- For community query users, we are currently testing these queries and will send separate, targeted communications in April when they have been fully validated.
- Visit the Power BI Toolbox and Rocket Shuttle Migration project page for more resources, including a 30-minute presentation, guides, FAQs, links to troubleshooting and more.
Thank you again for your help with this project and ensuring U of T is prepared for the end of the Rocket Shuttle license.
If you have any questions, please contact Katie Babcock at katie.babcock@utoronto.ca.