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
Bhargav SurapaneniBhargav Surapaneni 

Pushing salesforce data to sql server table

I want to push data from an object in salesforce to sql server db monthly(once in a month), requires only one side connectivity. Please let me know best ways to integrate this.
Thanks in Advance
Raj VakatiRaj Vakati
Hi  
Hi Bhargav ,
You can use any of the below options and you can find other options as well.
  1. You can use any ETL tools like Informatica ,jitter bit
  2. You can use SOAP api to extract data and use other programs  (JDBC ) to insert data in data base
  3. Event HerokuConnect is one of the options
  4. You can extract data from the Salesforce though data loader ( You can scheduler data loader job ) and user any tools to upload the data into database
Thanks ,
Raj
 
 
Osvald MarkusOsvald Markus
Hi Bhargav,
I think that there are two best ways for you:
- Set up HerokuConnect (https://www.heroku.com/connect)
- Use ETL tools like Dell Boomi, Informatica (https://www.informatica.com/)or Skyvia (https://skyvia.com/)(more affordable than these two).

I personally prefer to use web-based ETL tools, because with help of them I can set-up update in few clicks.
richard harding 1richard harding 1
I have just developed a process to migrated Salesforce data to sql databases (MS. MYSQL or ORACLE).

Email me at rhard2651@gmail.com for a trial copy.