2014-07-22T11:42:00Z
AS
Community Manager at PeerSpot (formerly IT Central Station)
  • 4
  • 184

Experiences with Oracle GoldenGate vs. Oracle Data Integrator?

Pros and Cons? Room for improvement?

4
PeerSpot user
4 Answers
it_user136377 - PeerSpot reviewer
User at Oracle Corporation
Real User
2014-07-22T16:33:16Z
Jul 22, 2014

Oracle GoldenGate(OGG) and Oracle Data Integrator(ODI) are two kinds of product. Oracle GoldenGate is non-intrusive real-time CDC whereas Oracle Data Integrator is an ETL tool (in Oracle’s term, it is E-LT tool).

Oracle GoldenGate differentiates itself by the characteristics of being real-time and non-intrusive, heterogeneity and flexibility whereas ODI by performance, simplicity and cost-saving.

Check these out in the below URL:

http://www.oracle.com/us/products/middleware/data-integration/overview/index.html
 

Product comparison that may be of interest to you
it_user116685 - PeerSpot reviewer
User at a government
Vendor
2014-07-22T12:07:05Z
Jul 22, 2014

I recommend neither of them, use SSIS instead.

GO
Data Quality Software Development Manager at Yapı Kredi Bank
Real User
2016-10-26T10:42:08Z
Oct 26, 2016

These 2 products stands for different kinds of needs. If you want to replicate data with a minimum set of transformation, Oracle Golden Gate is good for you. But if you want to make lots of transformations (eg. loading a data warehouse, OLTP reporting, merging different systems), Oracle Data Integrator should be your first choice.

OGG works with log shipping method (which only works with databases that support log shipping), but ODI works with JDBC (java database connection) any type of database. JDBC driver is the only thing that you need to connect to a datastore.

OGG is a replication tool, but ODI is an E-LT or ETL tool. They stand in different scopes.

BD
Business Process and Strategy Specialist Advisor at NTTData
Consultant
Top 5Leaderboard
2016-04-29T14:33:41Z
Apr 29, 2016

Both are good products. Really depends on what you want to do. If you are looking to run a product that can run something like a brokerage project, with little configuration, then you should go with GoldenGate. If you are looking to run daily operations for Integration then you should use ODI.
To be clear ODI can also do real time integration, but in my opinion GoldenGate does it the best.

Find out what your peers are saying about Oracle Data Integrator (ODI) vs. Oracle GoldenGate and other solutions. Updated: March 2023.
687,256 professionals have used our research since 2012.
Related Questions
DS
Sr. VP at Newt
Sep 26, 2022
Hi community,  I am a Senior VP at a large tech services company. I am considering replacing Oracle Data Integrator with Azure Data Factory. Which product do you prefer, and why? What are the pros and cons of each product? Thank you for your help.
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot
Jan 12, 2023
Hi Everyone, What do you like most about Oracle Data Integrator (ODI)? Thanks for sharing your thoughts with the community!
2 out of 12 answers
AS
Applications Support Manager at a marketing services firm with 1,001-5,000 employees
Nov 18, 2021
The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful.
NM
Principal Consultant at a tech services company with 501-1,000 employees
Jan 24, 2022
Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support.
Related Articles
RG
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting
Mar 22, 2021
Hey guys, how are you?  In this post, I’ll talk about my preferred tips and tricks that I use in ODI (any version). I’m always using these pieces of code for pretty much everything I do in ODI especially because it makes the code more elegant, dynamic, and easier to change later. First, let’s talk about my all-time preferred, Loops. Normally we learn to loop in ODI using a count variable and ...
Anna Odrynska - PeerSpot reviewer
Chief Strategy Officer at Alpha Serve
Oct 11, 2022
Business owners cannot rely on their own market assessments and strategic assumptions to make informed tactical decisions. Rapid technology development and tough competition mean that thorough data analysis is vital for success. In this article, we explain how business analysts, IT teams, and company managers can benefit from Microsoft Power BI integration with the help of BI connectors. Why i...
Product Comparisons
Related Categories
Related Articles
RG
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting
Mar 22, 2021
How to use ODI to generate Dynamic code for you
Hey guys, how are you?  In this post, I’ll talk about my preferred tips and tricks that I use in...
Anna Odrynska - PeerSpot reviewer
Chief Strategy Officer at Alpha Serve
Oct 11, 2022
Power BI Integration: Why Should You Integrate Power BI and Your Software?
Business owners cannot rely on their own market assessments and strategic assumptions to make inf...
Download Free Report
Download our FREE report comparing Oracle Data Integrator (ODI) and Oracle GoldenGate based on reviews, features, and more! Updated: March 2023.
DOWNLOAD NOW
687,256 professionals have used our research since 2012.