Data Migration

Konsolt ECImporter

Konsolt ECImporter

ECImporter is an enterprise grade ETL developed specifically to cater to the migration needs of HR data from legacy systems to SAP HCM and SuccessFactors. Born of the expertise and experience of many installations and environments, it is built on a robust web-based opensource platform and offers: -

  • Control over multiple source legacy files. Collection, format validation, merging. Then archiving and timestamping raw data to provide a complete audit trail
  • Use of real-time validation on merged files in the target system. Making sure the data complies with configuration values and real-world business values in real-time, no theoretical ‘should haves’
  • At each stage, provision of reports on progress and cleanliness of the data. Allowing legacy staff to cleanse only what is needed and satisfying any in-house or external audit requirements
  • Best practice methodology to guarantee as smooth and secure a migration as possible. We firmly believe you spend your valuable time agreeing rules for migration and not individual files and records

File Control

Single Source

Konsolt ECImporter - File Control : Single Source

Multiple Source

Any number of legacy files from different sources and global locations are merged into one compatible format per country. No matter how many records, the degree of record population or field nomenclature. Any source records outside of the agreed format are notified with an error report. Each record is tagged with an identifier to show the root legacy source.

Clean merged data is then placed securely in an agreed environment and time-stamped before loading to the SAP staging area for validation and migration to SuccessFactors.

We are mindful of the GDPR and security requirements governing our extracted data files. Secure transmission and limited access are built into the tool and our mindset.

Real-Time validation

In our experience this is the only type of validation that delivers. SAP has countless groups and categories that can be configured to produce a system tailored to your organisation. The best way to test that configuration is with your own data. If it doesn’t fit, then those groups and categories need revisiting.
We believe that once we have agreed a set of mapping and conversion rules this should cover at least 95% of your data. The devil is always in the detail and the final 5% of exceptions must either be cleansed, have additional configuration or additional rules added to allow them to pass. Our tools test every one of those configurations and rules and informs you of any record that fails. As each record is tagged with a source location identifier you will know exactly which source site to address.

Load to SuccessFactors

We have incorporated the standard SAP tool Infoporter to migrate to SuccessFactors. It has two major advantages in that it can handle historical data within the infotypes i.e. terminated employees or career progressions BEFORE cutover date. It also updates the employee key mapping table during migration which ensures that employees are not duplicated at a later date during replication from any amended record in SuccessFactors. Infoporter is part of an Employee Central license agreement and therefore freely available to use at no extra cost.