I am looking for a way to synchronize Salesforce data with a local database. At the moment I just want a pain free way of downloading the data. I've been playing around with importing CSVs from the data loader and direct database inserts using Jitterbit. This all works fine (as fine as CSVs can be!) but it is very tedious work to create tables without any strict data type/constraint definitions for classes with many fields. Is there a way to find this information so that I can create the tables with more confidence? Or better yet a tool or some APEX that will output a create table script based on the actual Salesforce class fields?

The destination database is SQL Server 2008.

  • 1
    If you are going to go very far with this (and have funds and believe in make vs buy tradeoffs) then there are 3rd party products already written that do this (and more) well and pretty much in a fully automated way. Can you confirm that spending such money is not an option? – Keith C Mar 20 '14 at 15:30
  • Unfortunately I am unable to spend any money on software to do this. I was hoping that there might be some sort of free tool available or maybe some apex code. – JonM Mar 20 '14 at 15:32
  • 1
    Maybe you can give a try for the Talend – Sergej Utko Mar 20 '14 at 15:39
  • @JonM Fair enough. As you probably know the APIs are there, but it would be good to get a head start with the code. – Keith C Mar 20 '14 at 15:42
  • 3
    I once made an application for a company that would build a SQL Server schema using the Salesforce meta data and then load the DataExport CSVs into it. I'll see if I can find a reference to it. – Daniel Ballinger Mar 23 '14 at 7:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.