# Help with batching multiple inserts from Salesforce to Oracle

**URL:** <https://forums.toadworld.com/t/help-with-batching-multiple-inserts-from-salesforce-to-oracle/32113>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [December 17, 2014, 1:23pm UTC](https://forums.toadworld.com/t/help-with-batching-multiple-inserts-from-salesforce-to-oracle/32113 "2014-12-17T13:23:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pdolan](https://avatars.discourse-cdn.com/v4/letter/p/919ad9/32.png) [@pdolan](https://forums.toadworld.com/u/pdolan)\
**Post date:** [December 17, 2014, 1:23pm UTC](https://forums.toadworld.com/t/help-with-batching-multiple-inserts-from-salesforce-to-oracle/32113/1 "2014-12-17T13:23:45Z")

</div>

I’m trying to figure out a way to replicate a dozen or so Salesforce objects into Oracle tables. I seem to have done it once in a sort of ad hoc way but I’m wondering what the best way have a series of scripts run where every target table is truncated and inserted into and the whole job runs in one shot. Has anyone done this before?

Update: I’ve found the Automation Script feature and that seems like it’ll work but how does one do more than 2 things in parallel? (it’s seems hackneyed to nest parallel processes but I guess that would work) Also, I’m using the SQL script thing to pass through dropping idexes and then recreating them after an import - is this the best way?

Thanks,

Phil

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [December 17, 2014, 5:47pm UTC](https://forums.toadworld.com/t/help-with-batching-multiple-inserts-from-salesforce-to-oracle/32113/2 "2014-12-17T17:47:14Z")

</div>

I would suggest using the Import Wizard.

1. Connect to Oracle (destination db).

2. Open Import wizard and choose ‘Add Query’.

3. Change the connection to Salesforce and enter Select \* from table1

4. Click through wizard to set up Oracle table.

5. Repeat 2 - 4 for multiple imports. This will save all into one Import template that can be run in Automation or in TDP.