SaskPower's DB Size Reduction with Data Archiving
The almost century-old company faced several pain points related to its growing SAP database. Without a data volume management strategy and lack of compliance rules in place, the company published an RFP and Auritas was chosen to implement a data management solution. Auritas implemented the top 20 objects in SAP ECC and CRM, resulting in a 40% reduction in the database, ongoing growth control, and legal and regulatory compliance.
-
40% DB Size Reduction
Archiving for DB reduction through SAP ECC and CRM, with ongoing growth control.
-
HANA readiness
HANA readiness: database controlled in time or HANA migration with major cost savings.
-
Risk avoidance
Positioned for legal and regulatory compliance with retention management plan.
Thanks to Auritas, our database and retention management is better then it ever has been. Choosing to work with Auritas was the best decision we could have made.
About SaskPower
Saskatchewan Power Corporation, operating as SaskPower, is the principal electric utility in Saskatchewan, Canada. Established in 1929 by the provincial government, it serves more than 538,000 customers and manages over $11.8 billion in assets.
SaskPower is a major employer in the province with over 3,100 permanent full-time staff located in approximately 70 communities.
About SaskPower
Saskatchewan Power Corporation, operating as SaskPower, is the principal electric utility in Saskatchewan, Canada. Established in 1929 by the provincial government, it serves more than 538,000 customers and manages over $11.8 billion in assets.
SaskPower is a major employer in the province with over 3,100 permanent full-time staff located in approximately 70 communities.
The Challenge
As the almost century-old SaskPower continued to grow with time, it faced several pain points related to its SAP database. Primarily, the lack of data volume management strategies in place emerged as a growing challenge as the company was facing increasing storage and hardware costs. SaskPower's team also struggled to find a way to keep their data accessible while archiving it with ease.
In addition, the lack of retention compliance was bringing legal risks.To address these issues, SaskPower recognized the need for a scalable, compliant data management solution that could reduce costs, ensure accessibility, and mitigate legal exposure.
Pain Points:
• Uncontrolled SAP database size and growth
• No SAP data strategy in place
• Lack of archiving capabilities internally
• No retention compliant in SAP and has legal risk
The Solution
After publishing an RFP, Auritas was selected to implement a comprehensive data management solution for SaskPower. Working closely with company leadership, Auritas developed a strategic plan that addressed key objectives while aligning with SaskPower’s long-term goals. The action plan included several core components: assessment, strategy workshops, data archiving, retention management, and knowledge transfer.
Key activities included an in-depth assessment of requirements and available solution paths, workshops to establish a tailored Data Volume Management (DVM) strategy, archiving of the 20 most impactful SAP objects, positioning the organization for effective retention management, and post go-live support through AuriCare—Auritas’ Application Management Services (AMS) program.
The project was executed in two phases. The first phase focused on preparation and strategic planning, while the second phase centered on the implementation of these strategies across the organization to ensure long-term success:
PHASE 1: ARCHIVING BLUEPRINT
• Database analysis
• Workshop to create roadmap for success
• Create assessment blueprint
• Finalize overall DVM strategy
• Benefits and reasoning behind choices: Milestones and timelines, integration requirements, retention and destruction requirements and knowledge transfer plan
PHASE 2: IMPLEMENTATION
• Implemented top 20 objectives in SAP ECC and CRM
- IS-U
- FI/CO
- Bases
• Set-up ongoing archive automation
• Positioned for future retention management in SAP
Results & Benefits
The project took seven months. The results of the project included a list of benefits to SaskPower: