Our customer is a rapidly growing engineering and manufacturing organization located in the Midwest, with a turnover of over $4 billion. They provide state-of-the-art digital continuity products & services from Critical Power Management to Server Rack Systems. The organization is engaged in designing, building, and servicing infrastructure for datacentres, communication towers and commercial/industrial facilities.
The organization has over twenty thousand employees worldwide, twenty-five manufacturing and assembly facilities, and an established local presence across six countries.
The scope of the project was to
There were more than forty legacy and cloud applications.
The Business embarked on a major digital transformation program, moving from legacy and SAP ECC on premise to Oracle Cloud applications. This was executed in multiple waves over a three-year horizon. Businesses wanted all their current analytical reporting to continue without any hindrance and invest in a technology that will cater to their future needs.
The legacy and cloud systems were located across five different time zones and had more than thousand discrete data models and over five hundred discrete object sets.
Hadoop Impala was chosen for the EDM to store hundreds of TB data. The data lake was used for data analytics and data science projects.
The data stored in enterprise data models were the most valuable data asset for the organization. It offered a consolidated repository for data from legacy and new Oracle cloud systems.
Some of the major challenges were:
The partial list of benefits:
dataZap - Pre-Configured Templates & Migration Engine to Extract, Transform, Pre-Validate, Load, Reconcile & Report.
dataZen - To 'Get Clean' and 'Stay Clean', and Introduce Master Data Governance.
dataZense - To Visualize, Analyze, Catalog and Scramble Data for Effective Decision Making & Security.