function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
bklerk1bklerk1 

Using Apatar to extract Salesforce data to an MS SQL table

I know how to do this using a Salesforce table as input and then using a transform to populate a previously-defined SQL table.  But, where I'm getting stuck is what is the easiest way to create the target SQL table "on the fly" without having to create the table layout definition in advance.  What I need is a way to automatically "clone" the Salesforce table definition (opportunities, for example) to a local database without having to manually create the table definition in advance.

 

Is there a way to do this within Apatar?  If this functionality is no available within Avatar, how is the easiest way to "clone" a Salesforce object to a local database?

start_sstart_s

Hi,

 

I posted my respond here http://www.apatarforge.org/forums/viewtopic.php?t=668&start=0

 

Hope it will help you.

 

Regards,

Sergei