The Challenge
So you’ve decided to move to Employee Central from your on-premise SAP HCM system, congratulations you are joining the ranks of some of the world’s top companies and will be getting a best in class system. Hopefully you’ve found an excellent system integration partner to help you with the move, once they completed the design and build all you need to do is migrate the data.
Yep that’s right, everyone’s favourite topic. While you may not have to complete all of the technical aspects and will have support from your SI team at the end of the day, you are ultimately going to be responsible for ensuring the success of the data migration to Employee Central. This is actually a good thing, of course the business best understands the data and is in the position to provide the most accurate information to the SI team. The bad news is the standard migration tools are all a bit technical so who has time to really learn some new complex system just for a once off migration?
If you are still a bit earlier on in the process I’d highly recommend reviewing the articles recently published by Darren Souter regarding important considerations before and during the move to a new system. You may also use the free downloadable checklist we’ve included to start planning with your team.
About me
You can call me Brendon. I’ve been working with SAP HCM for a little over ten years now and in that time I’ve worked on a number of large SAP implementation and migration projects, in some I was lucky enough to be able to use the SpinifexIT solutions and in the others I had to do things the old fashioned way! As a Solution Architect at SpinifexIT, I’m here to help highlight the ways we can help in an Employee Central implementation. Read on to find out more.
Where SpinifexIT can fit into the Employee Central Data Migration process
You can call me Brendon. I’ve been working with SAP HCM for a little over ten years now and in that time I’ve worked on a number of large SAP implementation and migration projects, in some I was lucky enough to be able to use the SpinifexIT solutions and in the others I had to do things the old fashioned way! As a Solution Architect at SpinifexIT, I’m here to help highlight the ways we can help in an Employee Central implementation. Read on to find out more.
Step 1: Data Cleansing – All data should be as accurate and correct as possible before extraction and load. Easy Reporter’s powerful functionality allows you to quickly detect exceptions before they become hard-to-solve errors.
Step 2: Data Extraction and Translation – There will always be some translation required between two systems. Easy Reporter provides the tools to quickly convert data formats or values from one system to another. The extracted files can be provided in the exact format needed for Employee Central upload.
Step 3: Data Reconciliation – An optional add-on allows Easy Reporter to connect to the Employee Central system and provide reports with both SAP and Employee Central data, allowing you to quickly and easily confirm the success of the data load.
Data Cleansing Before Migration
When you are populating your shiny new system with data, the last thing you want to do is bring over inaccurate information. Hopefully in the past you have had a focus on data integrity which means you shouldn’t have too many issues with your data. But even if that is the case, there is likely some things you’ll need to check to ensure a smooth migration.
As a simple example, think of a field in SAP that is not mandatory currently but will be mandatory in your Employee Central environment, maybe the employees preferred name.
Easy Reporter can help you to identify those issues and track them throughout your project so you can ensure a smooth migration when it comes to completing the final data load. Along with the standard pre-delivered data integrity checks, it will be quicker and easier to configure your own reports looking for missing data or other data integrity issues.
Data Extraction and Transformation
When you are populating your shiny new system with data, the last thing you want to do is bring over inaccurate information. Hopefully in the past you have had a focus on data integrity which means you shouldn’t have too many issues with your data. But even if that is the case, there is likely some things you’ll need to check to ensure a smooth migration.
As a simple example, think of a field in SAP that is not mandatory currently but will be mandatory in your Employee Central environment, maybe the employees preferred name.
Easy Reporter can help you to identify those issues and track them throughout your project so you can ensure a smooth migration when it comes to completing the final data load. Along with the standard pre-delivered data integrity checks, it will be quicker and easier to configure your own reports looking for missing data or other data integrity issues.
You can take advantage of a number of great features to really get the files you need with minimal effort:
- Advanced mapping capability
- CSV interface file output with simple or complex field assignments
- Field format conversions directly in the report
- Upload your mappings from a spreadsheet to quickly complete the report
Verifying the Accuracy of the Data Loads
Once you have run the files through the load programs in Employee Central, you’ll want to check the logs and ensure that everything made it through okay. Not only, that but I’d suggest you take it a step further and verify that the data in Employee Central ended up in the system as you expected, and it is correctly to match your data in the source system. Easy Reporter can help you here as well!
Using the SuccessFactors connector add-on for Easy Reporter, we can report on SAP HCM data side by side with SuccessFactors Employee Central data. This means you can build some simple reports to verify that the data in Employee Central matches SAP HCM.
First off you probably would need to at least verify that you have the right number of employees in the right groups in Employee Central, then you will likely want to drill down on some specific key fields to ensure their accuracy. As an example the report below verifies an employee’s name and employment status:
The good thing about building these reports early is that they can also be used post go-live to ensure your replication is working correctly.
Comparing Your Results in Parallel Payroll Runs
Once you have all of the data populated and your system is ready for testing, you will definitely be planning to complete a number Parallel Payroll runs to ensure that the payroll pre and post-implementation are providing the same results. The complexity of this stage will depend a lot on how you have chosen to proceed with your implementation – maybe you’ve made significant changes to your payroll system to support Employee Central or maybe you’ve kept the payroll system almost exactly the same. Either way, this is a critical part of your implementation and Easy Reporter is again here to help.
Easy Reporter includes some simple but powerful functionality that will allow you to import data from a text file in to your report. In the parallel run example this can be used to run a report against the payroll in SAP HCM, import the results from a previous run and quickly tell you the differences. Depending on the level of change you have made, you may want to transform the data a little bit – for example grouping multiple legacy wage types in to a single wage type in the new payroll calculations. You can easily map the data as you import the file or once it is imported and displayed in the report. You might want to see a list of wage types together in the report to compare without losing the details.
As an example, see below where we are reporting the SAP Payroll results alongside imported data from the legacy payroll:
This high level report will help you identify any major differences between your payroll calculations. Alternatively you can run additional reports to compare at a more detailed level and show wage type by wage type differences.
Find out more about Easy Reporter, our easy-to-use, flexible solution for Employee Central Data Migration.
Some Final Considerations Before Starting your Employee Central Data Migration Process
I’ll admit that I set out to make this sound easy because I believe that we can simplify the data migration process but of course there are a few things you might want to also look out for.
- Are you planning on performing many data loads for various stages to the system build? In most cases, you can expect to need to populate some data in to the development, test and production environments to support the design and build.
- Will each of those loads will have different requirements? Almost certainly the scope of employees and data fields will change.
- How quickly can you respond to new requirements in the load files? With Easy Reporter it takes just minutes to add a new field or update your transformations.
- Once you go live how will you keep the data up to date across your SAP HCM and Employee Central systems? SpinifexIT Easy Clone allows you to copy and scramble data between both SAP HCM and Employee Central to keep all of your systems aligned and up to date with secure scrambled data. Click here to find out more about Easy Clone..
That’s just the start!
This gives you just a small sample of the many ways that SpinifexIT solutions – specifically Easy Reporter – can help in your implementation project. Of course there is a huge amount we can also help with once you go live, so make sure to keep an eye out for additional posts with more information about our solutions. You can also pop over to our website here to find out more about our range of solutions and use cases.
SpinifexIT have been specialising in providing user friendly reporting tools to SAP customers for 15 years now and are always looking for new ways to help our customers optimise processes using our best in class tools.
Stay current on all SpinifexIT news. Follow us on LinkedIn, Twitter and Facebook to get free invitations to our webinars and discovery group meetings in your area.
This article was originally shared by Brendon Andrews-Warmuth on his Linkedin profile. Brendon recently moved from Melbourne to Frankfurt to support SpinifexIT’s growing presence in the EMEA network. Brendon is primarily focused on SAP Successfactors implementation, Cloud technology, and Partner and Client engagement.
