Apex Code Development You need to sign in to do that
Don't have an account?
AJ-ITI Need to push data from other database to SF on a continual basis
We are looking into our options for getting Salesforce and another in-house database to talk to each other. Essentially, we want Salesforce.com data updated in real time to any updates we make in the other database. I’ve looked at the Ruby on Rails developer kit and other integration tools, but I get the impression that those are useful for helping the data from FROM Salesforce TO something else. We need the data to go FROM the other database TO Salesforce. We have developers who can probably make this happen, but I am supposed to find them the information they need for this (and I'm NOT a developer). What type of key words should I be using to search this type of information? Can you point me in the right direction?THANKS for your help!
The Web Services APIs let you read and write your data in salesforce.com. try starting with http://wiki.developerforce.com/index.php/Integration
If you have some budget and would like a more out of the box solution for something like this, there are lots of AppExchange folks that can help you out with this kind of synchronization: CastIron, Pervasive, and Boomi, just to name a few. Sometimes it's worth paying some cash to get a solution that you can put up quickly and will be more robust than you can do on your own.
If you have budget: hire a consulting company to help you integrate.
If you have no budget: you can use the apex data loader to run on a scheduled basis to query a source database (microsoft sql server, oracle, mysql, etc) and upload the data to salesforce.
Here is the salesforce data loader page with a bunch of links:
http://wiki.developerforce.com/index.php/Apex_Data_Loader
Here is an article on scheduling it to run:
http://wiki.developerforce.com/index.php/Using_Data_Loader_from_the_command_line
http://www.developerforce.com/media/Cheatsheet_Setting_Up_Automated_Data_Loader_9_0.pdf