SAP for Utilities Blogs
Discover insights and practical tips to optimize operations, reduce costs, and deliver reliable energy with SAP technology. Contribute your own blog post!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Rapid Data Migration for Utilities - SAP Webcast Notes

TammyPowlas
Active Contributor
‎08-27-2014 2:59 PM
0 Kudos

This was an SAP webcast by SAP yesterday.  The notes are somewhat light (by my standards) because there were several demos.

Figure 1: Source: SAP

I think we have all experienced what is said in Figure 1.  Data migrations can be a challenge.

Figure 2: Source: SAP

The SAP speaker said they wanted to “Make it easier to move data into SAP”, to move source to target

This solution uses Data Services to leverage experience

Figure 3: Source: SAP

Documentation is free to help you deploy solution.  You can use "Predefined content to leverage"

It uses services methodology to go through the right process for your project

You can "use prepackaged service with SAP or a partner"

Figure 4: Source: SAP

The speaker said it uses the SAP methodology with the 6 steps shown in Figure 4.

Figure 5: Source: SAP

You can do it yourself – more on this later

Architecture

Figure 6: Source: SAP

Figure 6 shows the target system is the ISU (Industry Solution-Utilities) SAP system.  It is uses the Industry Solution Migration Workbench (ISMW)

This takes flat files and basic validation


Utilities have thousands/millions of meter readings, many customers and partners


The solution takes the flat filesor Excel, connect to system with Data Services, do profiling, cleansing, not build transform from scratch

There is also a configuration extraction feature to read the settings from your SAP configured system to validate the data

Then it uses IS Migration Workbench to load to SAP

See a demo here:

SAP said they are working on upgrading to Data Services 4.2 coming in October

More resources:

Source: SAP

Other:

We have used this solution and we will present this at the SAP for Utilities Conference in 10 days - more here Going to Hollywood - in September for SAP for Utilities

I'll be honest and say when we first faced a data migration of 2 other companies into ours I first thought of LSMW's - but that is not completely right.  You have to think of how you are going to prepare the data to fit SAP's structures, and that is where this solution fits in.

ASUG has a data migration session next month at the SAP Analytics BusinessObjects Conference: Data Migration: A Path to Information Governance

Popular Blog Posts