Challenges:
- Previous attempts for importing the data to Oracle Sales Cloud were not successful
- Data import to Oracle Sales Cloud was complex and in stable
- Deduplication of data was necessary
- Pre-processing of additional extracts from source systems for file-based loader would have been very complex
- Inconsistent and missing relations
- Invalid country codes
Results:
- Combined insert and update in one iteration with conemis data integration tools
- Existing data in OSC is cleansed
- Easy transformation of pick list values
- Data migration completed in less than a month
- Customer very satisfied with tools after live demonstration with production data
