function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Naveen JainNaveen Jain 

Suggestions for Syncing in-house Oracle Database and SF in sync

We are looking to keep in-house Oracle Database and SF database in sync on almost real-time basic or with maximum lag of 30 min. The databases are small (7 tables) with may be max 100,000 records each. Total size about 30MB.

 

1. Initially it is going to be one way sync such that there are no updates to SF database that are made directly and changes to Oracle will be replicated to SF database.

 

2. Soon, we might want to have other way sync, where updates can be made only to SF database and Oracle database will need to be in sync with SF database.

 

Any suggestions for tools that are provided from SF or any of their partners to do this.

 

Thanks,

 

-Naveen

Best Answer chosen by Admin (Salesforce Developers) 
NasipuriNasipuri

Hi Naveen,

 

There are many readymade tools available in the market for this use case, to name few of the enterprise call tools are

 

 1. Informatica on Cloud (on premises connector is also available)

 2. IBM Cast Iron.

 

You can use salesforc data loader which supports data connectivity to ORACLE data base and it is free, but you required some configuration to set the batch.

 

Using Force.com web services API and ODBC you can develop own custom application to do the integration.

 

Thanks and Regards,

Dinesh Nasipuri

dinesh.nasipuri@gmail.com