You need to sign in to do that
Don't have an account?
chrismclaren
Oracle
I am looking at updating to.from an oracle database. We are looking to update the accounts/opportunity/contacts table from salesforce to an oracle database and also from oracle to salesforce.
Is this possible and how do I go about starting to achieve this? Any help is appreciated.
I believe both BlueWolf's DRE and Relational Junction do this.
Both these options are quite an expensive alternative. The other option we have is to parse the data into excel, then map it with oracle. Is it possible I could use a web link when a new account is created to pass the values into excel via the url?
Any other suggestions would be appreciated...
Do you have Enterprise Edition (ie. access to the API) ? You could develop your own eg. Java class that reads the records from Oracle (via JDBC) and then sends them up to Salesforce via the API (and vice-versa). You can then cron/schedule the routine to run whenever necessary.
Any language/tool that can connect to Oracle and communicate with Web Services would do, not just Java.
Have a look at http://www.salesforce.com/developer/docs.jsp, there's various stuff on here that should give you an introduction.
Also, we can offer technical Professional Services to assist you if necessary, take a look at http://www.enterprisecrm.com or email me at andy.clark@enterprisecrm.com.
One other way is to install the SQL Server 2005 Express edition from MS ( it's free) and then get DBAmp ($495). Then connnect DBAmp to SQL Server to Oracle via a linked servers. Admittedly a round about way to do it, but cheaper.
Bill
forceAmp.com