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?