I am seeking a tool that offers the features to
1. export data, using filters, from a legacy organization
2. map that data to a existing or new structures in a new org, example
Leads with set of custom fields
Leads with association to custom object containing those legacy fields
Legacy Object fields to different fields in the new corresponding Object
- Load the data and most importantly, preserve the relationships from the legacy information, example
Account owners (users) to Accounts (mapping newly created Users)
Lead/Contact Owners to Users (mapping newly created Users)
Opportunities to Contacts
Cases to Accounts
Then, once all legacy objects/fields (to be migrated) are mapped, pushing a button to actually move the data, taking into account number of records being transferred, and "chunking" appropriately.
Is this a pipe dream, or does such a thing exist?