You need to sign in to do that
Don't have an account?
Bhargav 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
Thanks in Advance
Hi Bhargav ,
You can use any of the below options and you can find other options as well.
- You can use any ETL tools like Informatica ,jitter bit
- You can use SOAP api to extract data and use other programs (JDBC ) to insert data in data base
- Event HerokuConnect is one of the options
- 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
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.
Email me at rhard2651@gmail.com for a trial copy.