Your expert views are highly appreciable regarding the following.
We at work are evaluation different solutions to achieve data synchronization between oracle and sql server data bases. Data sync i mentioned here is for live applications. We are runnign oracle EBS 11i with custom applications and intending to implement a custom software based on .NET and SQL Server. Now the whole research is to see updates and data changes whenever happens between these systems.
I googled and found Oracle Golden Gate, Microsoft SSIS, Wisdom Force from Informatica....
If you can pour in more knowledge then it's great.
Oracle Golden gate is the leader in Data Replication and Synchronisation followed by IBM Infosphere CDC and the Informatica Wisdom Force.
However IBM has an edge over Oracle in that DataMirror / InfoSphere CDC has a user interface and GoldenGate does not.
GoldenGate requires user scripting to integrate data sources and this is bad for productivity and governance
Edited by: satrap on Nov 30, 2012 6:16 AM
Most of the work involved has to be done through scripts and there is no effective GUI to implement OGG.However using commands is not vey togh and they are very intutive.
These are the steps, from a high level:
1.Get the appropriate GG Software for your source and target OS.
2.Install GG on source and target systems.
3.Create Manager and extract processes on source system
4.Create Manager and replicat processes on target system
5.Start these processes.
First try to achieve uni-directional replication. Then Bi-directional is easy.I have implemented bi-directional active active replication using Oracle DBs as source and target. Refer to Oracle installation and admin guides for more details.
Here is a good article that may be handy in your case.
Edited by: satrap on Nov 30, 2012 8:33 AM
Thank You for the huge insight. I am going to take this to my DBA. He already arranged for a demo for Oracle for OGG.
We are still in very initial stages. How about Infosphere ? . I did take a look in the IBM website. Can you throw some light on that.
Sorry if i am too pushing.... ;)
Although I have not used Infosphere, it is said that it has an edge over Oracle in that it has a user interface whereas GoldenGate requires user scripting to integrate data sources.
On the contrary, I have also heard that the documentation of IBM products is not as great as that of Oracle (do not know the truth though) and you have to rely a lot on their consultants.
I heard of OGG 5 months ago and I am not even a DBA, still I have implemented it in one of my projects just reading the documents and browsing websites.
A lot depends on the license cost etc as well and I am not aware which of the two is cheaper.