Data Archival Solution for SAP ECC, S/4HANA, BW and Hybris

Client Overview

Leading Canadian telecom company and they leveraging the power of world-class wireless and fiber networks. They deliver a wide range of service innovations to consumers, businesses, and government customers across Canada.

Key Facts:
Founded in 1880.
Operates in Canada.
Providing service for Home and Commercial purposes for Fixed-line and mobile telephony, LTE Advanced, Fiber Internet and TV, Wireless Home Internet, cloud and data hosting, IP voice and collaboration, Connected Cars, Smart Cities and Internet of Things.
Revenue: C$23 B.

Project Scope

Client wants to identify and archive the SAP ECC and S/4HANA system historical data to increase the system performance. And also the business team required the enquiry screens to access the archived data. The enquiry screens should have the ability to apply search criteria, data export and PDF print features similar to the existing system.

The following Objects are considered for Archival and Purge:

Finance: Finance Accounting Documents, Bank Master, Asset Master and transactions, Cash Journal Documents, G/L Master and Transactions

‍Sales and Distribution: Sales Documents, Billing Documents, Sales Pricing Conditions records, Agreements/Conditions, Sales Activities

‍Purchasing: Material/Article Master, Purchasing Info Records, Purchase Requisitions, Material Documents, Purchasing Documents, Invoice Documents, Physical Inventory Documents

‍Manufacturing: Routings, Work centers, Bill of Materials, Process Orders, Production Orders and Master Recipe, Confirmations, Backflush Documents, Confirmations, Equipment, Functional location, Serial Number History

Controlling: Cost centers, Settlement Documents, Material Ledger Documents and indexes, CO Line Items, Orders with Transactions data, Material cost estimate data

Business Situation

The business data was over 12 TB, and based on the assessment over 50% of the data qualified for data archive and purge. This leads to USD 1.6 Million dollars savings. The other expectations from the business is to improve the customer experience by improved performance, also they wanted to decrease the time taken for backups, upgrade and cloning processes. The business also wants to have access to the archived data from the SAP application.

Technical Situation

Client wants to identify and archive the historical data and move the archived data into a separate storage system to improve the system performance and free up valuable primary storage space. They planned to use Hadoop as a storage area. Hadoop has the greatest redundancy and speed the client expected. Also ChainSys offering of SAP look alike screens on top of the Hadoop Archived data was a big differentiator. These standard screens configured using Smart App Builder are available out of the box for SAP clients.

Solutions

Chainsys Data Archival Platform was used for the SAP Data Archival process.

Identification:

ChainSys Archiving Platform offers the Profiling engine to identify the current state of all schema and tables which are used in SAP and other Applications. Data Insights are provided to support creating the Archive Retention Policies. $ Savings can be determined.

Remediation:

ChainSys Archiving Platform offers the Archival, Approval, Review Screens, and Purge engine. This supports SAP and other Applications. Robust and flexible workflow for achieving the Archive and Purge needs. Low code to No code Platform for Screen Provisioning on top of the Hadoop Data which is the target data mart for archived data.

Governance:

ChainSys Archiving Platform offers the Governance solution to the Archived data to ensure the data is protected and there is no data breach.

The data access is governed by role based security. Also the Sensitive data is masked. Metadata of all the archived entities and attributes are

registered and made available for the data requesters. This supports both SAP and Non SAP Applications.

Benefits

Reduced Costs: Data is typically stored on low performance, high capacity with lower associated maintenance and operation costs.
Reduce Backups Windows: With continuous data growth, backup times are now stretching more hours. With a copy of your files in the archive, you can control your backup times as there is no need to backup old historical data.
Improved Efficiency: Most organizations are using their primary storage systems to store inactive data. As your system accumulates more and more data, it puts a strain on your system.

Archiving allows you to move infrequently needed data from your system, freeing up valuable primary storage space by off-loading unused data. With an effective archive strategy, organizations would be able to easily search for and access old data that continues to add value to the business over time and they can restore the same data whenever they need

Data Availability: Legally, your business must retain certain documents for a set period. Regulatory compliance in several industries - like finance, healthcare, and Services - will continue to drive changes in data retention.
Data security: Data held in archive must be protected from loss, corruption, theft, and compromise. Archived data may need to be accessed by a wide variety of users. Data archiving solutions can simplify access requirements with role-based/User permissions that allow users to easily search and retrieve without intervention by IT teams. archiving Process limiting the chance of cyberattack or malware infection

Prevention of data loss: Archiving reduces the ability to modify data, preventing data loss