How can you get expert guidance on how-to implement and troubleshoot Oracle GoldenGate?
To answer that question and many more, I invited John P. Jeffries, author of Oracle GoldenGate Implementer’s Guide, the first book written on the GoldenGate technology, to chat with the ArtOfBI.com Podcast.
Oracle GoldenGate is the real-time data integration tool that enables continuous data availability by capturing and delivering updates of critical information as the changes occur. It can also provide continuous data synchronization across heterogeneous environments.
On this Podcast
Just listen to the podcast and you’ll know that this is the first time I am interviewing a guest on the ArtOfBI.com podcast. John was more than polite in taking time out of his busy schedule to talk to us about GoldeGate, his experiences, his new book, and sharing information. Thanks again John, we’ll see you at OOW 2011.
Got Something to Talk About Related to Business Intelligence or Technology?
We are currently building our schedule for interviewing authors, bloggers, product developers, and C-Level folks. If you happen to be doing something new or ground-breaking with Business Intelligence, Data Warehousing, or EPM we would like to interview you or someone from your team about what you’ve achieved. You can email me directly at christian [at] artofbi [dot] com and we’ll get something on the books.
This Podcast (Issue #1)
The podcast can be played from the media enclosure above (Just press play). All feedback is of course very welcome.
Posted on 29 April 2010
Tags: ODI
If you haven’t had a need for utilizing Oracle Data Integrator (ODI) as an ETL (or E-LT source as ODI advertises itself) then you wouldn’t know that it is actually somewhat of a beast of a ETL tool. The interface leaves a lot to be desired and I could really get picky but again it is a beast – very powerful. I recently read a great review by the good folks at BI Quotient about ODI. They did a 3 part series on the topic and really covered some areas not mentioned in most ODI write-ups. I consider myself well versed in ODI but these guys threw in some great ancillary discussion with links to awesome tools such as PolePOS and SQuirrel SQL that I did not know about. And, we know that I am a big fan of open-source software so this was a great discovery for me.
Okay, well the article by Uli Bethke might not be the “Best ODI Review…” but it is really solid. I like how he keeps HyperSQL at the forefront of the article. Since HyperSQL (HSQLDB) is really at the core of ODI you know that ODI has the potential to be powerful as an ETL tool. As you know, HyperSQL is at the core of another very well known software suite, OpenOffice.org so clearly it works pretty well.
The article introduced me to PolePOS which a database benchmarking tool. I’ve yet to get it a go but you can see the possibilities there, especially since it is free. Could this be used against OBIEE as a source?
Lastly, in part 2 of the article Uli takes an investigative look at the in-memory synopsis memory engine of ODI against one of the Microsoft SysInternals tools to see just how severely the server’s memory gets consumed as an ODI process executes. For some this is not a common-sense benchmarking approach but subtly suggest strong performance tuning technique when working with such an application.
Just to wrap it up, no the article did not provide an immediate tutorial or a step-by-step solution. John Goodwin and some others have some killer articles like that. However, this one seemed to be one of the first ODI articles that I’ve read that touched on the tool as a part of whole not just the whole itself. Give it read if you have the chance.
References:
http://www.business-intelligence-quotient.com/?p=703
http://hsqldb.org/
http://www.polepos.org/
