Working within the SAP data model for the Oil & Gas industry can be complex, and creating secure data for non-production environments calls for a different approach. Why is test data important? The average organisation loses $8.2 million annually on poor data quality. For most Oil and Gas companies, their SAP system is integral to their business, and any significant outage of a particular business process, or worse – the entire SAP production system – has a potential multi-million dollar impact. This is why effective testing in non-production environments is so important. And of course, testing can only be truly effective if the test cases and the data match the situation that will occur later in Production.
For Downstream, the integrated nature of the business processes makes it difficult to isolate individual data sets to provision. Data Sync Manager™ (DSM) allows the copying of data on demand to update specific data types which may now be different in the test system, such as Material masters or Pricing Conditions, but in many cases customers decide to refresh the test systems more frequently by harnessing the power of Client Sync™ to bring back just a time-sliced subset of transactional history from production. The reduction in data volume, and simplified activities compared to a full system copy, mean much more frequent refreshes can be undertaken.
In Upstream, there are specific challenges with subsetting data, and in particular for organisations using Production and Revenue Accounting (PRA). For those systems, Data Sync Manager provides data on demand to copy isolated objects with related data types to help with support issue. A good example is ownership changes which can be tough to replicate and resolve under pressure to be ready for month end. Similar to Downstream though, the main benefit is being able to create a representative client with a fraction of the volume. This can enable real transactional data in a development system for the first time – lessening the time from design to production for new reports and code changes.
Lean subsetted clients with all master data and customising but only the last few months of transactions. The testing client provides a production like environment to support and develop with. When it comes to resetting the process is quicker and less manual effort. Data Sync Manager for IS-Oil can be used to slice the data according to a specific scenario. The team can help you to set that up, for example only copy one Measuring Point with its related data and so reducing the target. You get consistent data for a complete scenario.
To reduce the non-production environment and have real up-to-date, scrambled data you can slice the non-production environment again with a time slice of the data. This capability has brought massive disk savings and process benefits to some of the world’s largest Oil and Gas companies. Data-on-demand can also be used for specific datasets which change quickly, such as Material masters and Pricing Conditions.