I have roughly 7 objects - some with relationship to each other and some stand alone. I have to repeatedly copy the data from the production org to one of the dev orgs (there is roughly 10 so you can see why I want to automate this) whilst maintaining the relationships between the objects.
I am fairly certain I can set something up in Jitterbit that will export the current data from Production and then insert it into the dev org whilst maintaining relationship fields (lookups).
Does anyone know how to do this? If not in Jitterbit is there another application that is better?