Successful Archival of JD Edwards System in less than 8 Weeks

Industry:
Pharmaceuticals

Client Overview

Leading cancer diagnostics company, powered by trusted brands, Company has a wide breadth of solutions that will continue to transform the anatomical pathology market. Today, It is a global company working to improve patient outcomes by providing groundbreaking technologies. Every product developed has been impacted by generations of employees who are committed to improving lives by enabling pathologists through enhancing precision in cancer diagnostics

Industries:  Biotechnology

Location:  Michigan

Company size:  1001-5000 employees

Specialties: Cancer Diagnostics, Tissue Processes, Cassette Printing, Tissue Processing, Embedding, Section Management, Sectioning, Cryotomy, Microtomy, Microscope Slides, Staining, Cover slipping, Diagnosis and Archiving, Digital Pathology, Archiving, Storage, Standalone Consumables, Histology, Anatomical Pathology, Cytology, IHC, Immunohistochemistry, Pathology, and Histopathology


Project Scope

  1. Historical data Archive from JDE(US Location1), JDE(US Location2) Azure Data Lake. 
  2. 1000+ Objects to be Identified from JD Edwards from 2 Locations
  3. 15 Enhanced Inquiry Screens configured to see data in Archive
  4. 150+ Data Archival Dashboard in Visualization
  5. Lift & Shift Methodology

Business Situation

Business is planning to retire the existing system (JD Edwards) and Moving to S4/Hana Application.  They are migrating all the Existing Open Transaction Data from legacy into S4 Hana.  For Auditing/Reuse and regulatory compliance Purpose Business has planned to migrate all the Historical Data into Azure Cloud using Appconnect application before retiring the existing JD Edwards application.

Business required the below activities to done before the retirement of the JDE application

  1. Need to Archive all the Tables which has data available in JD Edwards.
  2. Need JDE application screen to view the Historical Data from Azure cloud.
  3. Need Historical Table View Dashboard for the Most used Tables.
  4. Need PDF reports for the important documents like invoice, Sales order and Purchase order etc.

Technical Situation

Customer Planned to retire the JD Edwards application after they migrated to SAP S/4 Hana application.   All the historical Data from JD Edwards need to be moved to Azure Data Mart using DataZap. There are a number of reasons businesses like archiving data. Some need to retire the existing system and moving to other Application, some need to meet regulatory compliance, Others do it because it helps their business systems run more efficiently. Many companies are finding ways to repurpose or reuse existing data or Auditing, whatever your reasons, archiving your data can save resources like time, storage space, money and Customer Data.  

  1. Data Archival for all the Tables having data in the Source JD Edwards
  2. Enabled connectivity between DataZap application with JDE and Azure Cloud Data Mart.
  3. 1000+ Objects to be Identified from the 3 applications
  4. 15 Enhanced application Inquiry view Screens configured to see data Archive 
  5. 150+ Data Archival Simple Dashboard using DataZap application for the Table view.
  6. Provide PDF reports for Documents like invoice print, Sales order print, credit memo print and Purchase order print from the archive data.
  7. Planned to execute the data migration in parallel processing method.
  8. Provide Reconciliation Dashboard and Object Dictionary for the Archive Data and objects

Solutions

“Archiving the right data can not only save your business money, but also add value to your business.”  A data archive is a place to store data that is important but that doesn’t need to be accessed or modified frequently.  Archived data is typically information that is important to the customer for legal reasons or for compliance with regulatory frameworks.

The solution proposed was dataZense (a cloud-based Data Archival solution) that runs on the ChainSys Smart Data Platform.  dataZense comes with prebuilt templates for all ERP applications, thereby reducing the effort and time involved in Data Loading. DataZense is based on Web-service based architecture and is fully configurable to suit the business needs.  

  • dataZense is used to provide the Dashboards to view the historical Data
  • dataZense is used to provide the Application screens same as the JDE screens
  • dataZense - Archive all the Historical Data (850 million records) in 8 Weeks
  • DataZense - Provide 200+Dashboard to Business to view historical data from the Azure cloud
  • DataZense - Provide 15+ Application Inquiry screens to view the historical data same as the JDE View screens.
  • Successfully connect to JD Edwards and Microsoft Azure Cloud application through dataZense application

Illustrations

Benefits

The implementation of Data Archiving was done in 8 weeks. Agile execution is enabled by the use of templates and a configurable and no programming approach to the solution process. Businesses that invest in proper data archiving strategies will not only achieve regulatory compliance, lower costs, and mitigate risks, but will also meet operational goals and achieve long-term viability.

Business Can able to download more than a million records in a single export

Business Can able to view the 2 JDE source data in a single appbuilder form from archive data.

Reduced Costs:  Data is typically stored on low performance, high capacity with lower associated maintenance and operation costs and Resource Cost.

Reduce Backups Windows: With continuous data growth, backup times are now stretching more  hours. With a copy of your Data in the archive, you can control your backup times as there is no need to backup old historical data.

Application Retirement:  Application retirement allows the application and the supporting hardware and software stack to be decommissioned. This eliminates recurring costs such as licensing, maintenance, and application administration costs, representing potential significant savings. Also noteworthy are the space savings and reduction of power consumption in the data center when applications are retired.

Improved Efficiency:  Most of 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, Business person 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.  Business can use the existing queries to pull the data from the Archive location.

Data Availability:  Legally, your business has to retain certain Data for a set period of time.  Regulatory compliance in 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

Products and Services Used

dataZap - Pre-Configured Templates & Migration Engine to Extract, Transform, Pre-Validate, Load, Reconcile & Report.

dataZense - To Visualize, Analyze, Catalog and Scramble Data for Effective Decision Making & Security.

Reference


No items found.