You need to sign in to do that
Don't have an account?
Enry
Integration data from Ms SQL database to Salesforce
How to send data from Ms sql-server to salesforce?
I have seen a lots of posts but i don’t understand which is the best solution.
1) Use the Apex Data Loader command line interface to get information from a SQL server db and after import into salesforce.
It is a robust and easy solution?
I would not buy app but if it is required for a good work....
2) Are there solution? webservices , call out,http requests
Thank you in advance.
BR
You need real time integration or batch?
If batch is fine then you can use Apex data loader in CLI mode to connect with SQL server(This will require some work but you will be able to automate the job) OR you can export the data in .csv format and use UI version of the data loader.
Also, there are many paid applications available (ETL tools) like Informatica cloud/ETL , Pervasive etc.
If real time integration is needed then go or webservices.
Apex Data Loader is a good enough solution for simple async integration purposes. Configuring the CLI is quite fiddly, however, and I would suggest using something like CLIq to help you get started.
If you have any degree of complexity, such as stringing together jobs and the like (job B comes after job A), you might consider an ETL tool and pay for it.
Direct to DB integration is possible provided your DB has some means of SFDC making a call to that DB. For outbound integration (call originates from SFDC), this would mean some sort of SOAP implementation or REST endpoint on the external DB server which SFDC might call.
Alternatively, you could do an inbound integration, where the call originates from the external system. This would typically be the SOAP API.
There is another "poor man's" integration: an Apex inbound email service. In this instance, you write some Apex code and expose it as an email address on the SFDC servers. This is done sometimes when SOAP is not an option. In this instance you would martial up your data in the body of an email message sent to SFDC. The Apex code would parse the body of the email, extract the relevant data, then save it.
Good luck!
5 k records per month + 100 k CSV import/export are free.