Don't Let Data Bottlenecks Slow Down Your ERP Transformation

Consumer goods and retail companies can drive innovation with automated compliant data delivery for ERP modernization. Here’s how.

Sharon Bell

Feb 02, 2021

Enterprise resource planning (ERP) systems are often the most expensive IT investment for retail and consumer goods organizations. These applications form the digital backbone of those organizations and impact all aspects of business from automating and managing day-to-day activities to integrating core systems with customer-facing processes.

But many companies today still struggle with an inflexible ERP system that is not optimized for their business. ERP systems can provide a huge payoff and benefit when enterprises have the ability to convert complex data streams into actionable information in order to optimize business operations and drive better product innovation. Companies must adopt a data management practice that enables a modern and flexible ERP system that rapidly responds to customer needs and new market opportunities.

Drive Data Into Pipelines for Mission Critical Apps Through Automation

One of the biggest roadblocks to expanding and updating ERP systems is often the manual process of refreshing the mass amounts of data residing within the ERP system and connected front-end technologies, such as point-of-sale systems and ecommerce apps. Manually refreshing those databases for development and end-to-end transaction testing is so onerous that most enterprises only schedule one or two refreshes a year.

Consequently, development teams are then constrained to one or two ERP updates a year, or they test with old or fake data sets to increase the frequency of releases, potentially leading to release quality issues and data-related defects.

That’s where an automated approach to data delivery and compliance can help to enable fast access to production-quality data and accelerate the frequency and accuracy of ERP updates. Through the combination of data virtualization, API controls, and automated masking of sensitive information, the Delphix Data Platform reduces the time to refresh data from months to days and provides on-demand access to production-quality data for development and testing.

Take a consumer packaged goods titan, as an example. DevOps teams experienced delays in getting full sets of fresh, secure data, which made it difficult to keep up with SAP enhancements and new features. Testers frequently used stale data, which impacted the QA team’s ability to accurately test transactions across SAP and front-end systems, such as its ecommerce platform.

This consumer packaged goods company adopted a data platform that allowed them to virtualize the company’s data infrastructure, reducing the time to get data for testing SAP updates and new features from 45 days to just hours. They were ultimately able to accelerate release cycles, enabling IT to react quicker to customer demands and make swift operational adjustments.

Similarly, German toy retailer myToys wanted to move from quarterly to daily release updates on Oracle EBS, which ran everything from purchasing, finance, and accounting to inventory management, customer service, and logistics. The ERP team was sharing only two data environments to support the 70+ Oracle projects per quarter, constraining the development process and stifling innovation.

They automated the provisioning of virtual database copies, refreshing data in hours instead of days, and generating data environments with the right data and application stack for development and testing teams. As a result, both teams worked in parallel to achieve their goal of daily release updates.

Automate Data Compliance and Reduce Privacy Risk

Another obstacle to keeping ERP systems current with the latest innovations is the concern for data privacy. Development and testing teams need massive amounts of data to accurately test software updates and new features, but privacy policies oftentimes prohibit sensitive data from residing in dev/test environments.

Without an automated way of masking sensitive information, i.e., credit card numbers, IT teams spend a huge amount of time manually obfuscating data, or developers are forced to create fake data sets.

Both activities not only delay development and testing but also negatively impact the quality of software releases.

A data platform that includes automated compliance can reduce the time it takes to secure data from weeks to hours. Automated compliance ensures that sensitive information is turned into realistic, but fictitious data that can be used for development and testing purposes. Secure data can be provisioned and refreshed much faster, thus reducing wait times for engineering teams, compressing testing cycles, and empowering developers to deliver ERP application releases faster and with far greater predictability.

masked data delphix platform

Accelerating ERP Innovation with Fast, Compliant Data

IT and development teams must work together to ensure that data does not become the bottleneck to modernizing the ERP systems. This involves both process and people transformation as well as an API-first data platform that provides data delivery and compliance automation to remove roadblocks to legacy ERP modernization.

See how Delphix's API-first data platform can help jumpstart your ERP projects and rapidly deliver mission critical capabilities that your business depends on.