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

/wp-content/uploads/2014/08/1fig_528936.png

Figure 1: Source: SAP

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

/wp-content/uploads/2014/08/2fig_528937.png

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

/wp-content/uploads/2014/08/3fig_528968.png

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”

/wp-content/uploads/2014/08/5fig_528969.png

Figure 4: Source: SAP

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

/wp-content/uploads/2014/08/6fig_528970.png

Figure 5: Source: SAP

You can do it yourself – more on this later

Architecture

/wp-content/uploads/2014/08/6afig_528980.png

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:

/wp-content/uploads/2014/08/7fig_528981.png

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply