In the coming months, I will be migrating data from one Salesforce system to another implementation. These are still two separate systems, with their own data models, but the core concepts are there and I should be able to make a map and migrate the data pretty well.
The data models will be multi-tiered, of course, with several parent-child relationships. The size of the data migration is also a concern, with well over 100k accounts with multiple policies.
I know the proper way to handle data sets this large would be to utilize Data Loader, but with the multi-tiered data structures I will be handling, I'm having a hard time picturing how I could break this load down into multiple loads where I would, for instance, load accounts, get the Id, then use those values to load in policies, and then get those Ids to support the children of the policies. It could get messy pretty quickly.
I had thought to create an API with the complete imported data model available and load the data in an account by account series of data calls. I was warned that I would be in danger of hitting limits if I do this though.
This is still in the conception phase, so I would love to hear about thoughts on possible ways to tackle this feat. I appreciate any insight you may have.
#Data Management #Data Migration #Migration #Automation #Integration
