1 Reply Latest reply on Jan 29, 2019 12:29 PM by Regina Holman

    Sync Salesforce data with MS SQL table structure

    Josh Kinstler New Member
    Josh Kinstler Aug 29, 2018 9:21 PM

      I need to extract data out of SalesForce and into an MS SQL database.  Is there a way to automatically generate the salesforce object SQL table structure?  I would like to generate a SQL create table script with some of the salesforce objects.  I can then use that table to send my data to SQL. 

      • 191 Views
      • Tags:
        • 1. Re: Sync Salesforce data with MS SQL table structure
          Regina Holman New Member
          Regina Holman Jan 29, 2019 12:29 PM (in response to Josh Kinstler)

          Salesforce uses the SOQL language for queries, therefore you cannot directly extract from salesforce using SQL. In most cases I have seen, users extract files from Salesforce using SOQL queries perform transformations on that file of data and then uploads that data to their database, the automation of this can be done using an ETL tool or writing code to perform these processes. I hope this helped.