Guest Blogger: Cameron Lackpour
ODTUG Expert’s Panel - Oracle Data Integrator (ODI)
Panelists: Cameron Lackpour (CL Solve), Gurcan Orhan (Turkcell ), Michael Rainey (Rittman Mead Consulting), Matthias Heilos (MindStream Analytics)
Moderator: John A. Booth (Emerging Solutions)
Thursday, December 13, 2012 1:00 PM - 2:30 PM EST
*Join the first-ever ODTUG expert’s panel webinar*
Yup, history in the making and you can be a part of it. What do we mean? We’re hoping that this ODTUG virtual expert’s panel will be the first of many panel webinars with the best and brightest ODTUG can access on many, many subjects. Just like Kscope, we are reaching out to the world’s best and bringing them directly to you. You don’t even need to travel, but instead can enjoy without leaving the comfort of your home or office.
Unlike other webinars, this is not a canned presentation but instead an interactive discussion with you. Have an ODI question? We’ll do our very best to answer it. If we can’t answer it, we’ve got contacts at Oracle that we can leverage. Yeah, it’s power, it’s awesome, and it’s yours. FOR FREE. All you have to do is show up and ask away. And we’re not limiting ourselves to a given technology stack either – this is for more than EPM people, or BI practitioners, or DW types – we’ve gathered enough names, talent, and brains to cover ODI’s not inconsiderable scope and power.
Excited yet? You should be. This is ground-breaking stuff that no one else is doing. That’s right, innovation again from ODTUG. Be a part of it.
Three of the panelists are ACE Directors, the moderator (John) is an ACE, and I (this is Cameron here) can’t figure out why Matthias isn’t an ACE as well – he certainly knows as much as we do. :)
If you want a flavor for the kind of information we currently obsess over/love/freely share, check out our blogs here:
Cameron – http://camerons-blog-for-essbase-hackers.blogspot.com
Gurcan – http://gurcanorhan.wordpress.com
Matthias – http://epmstream.blogspot.com
Michael – http://www.rittmanmead.com/blog/
John – http://www.metavero.com
Some of the topics we could cover (and if you don’t ask, this will be all we talk about) are:
- Migration firm OWB to ODI. I had many questions about it. Tips and tricks.
- How flexible is ODI? How to configure, enhance, and modify depending on business/technical needs.
- Heterogeneous environment could be another simple subject. Talking with MSSQL, Sybase, Oracle, Linux, and Windows at the same time.
- GoldenGate and Hadoop interaction.
- How is ODI used differently in data warehousing ("classical" ETL) and the EPM space?
- What are the top five tips and tricks to develop great ODI processes?
- "Buy or sell" questions about the future of ODI or data integration processes in general, maybe even Big Data
- For EPM people, could one of the panelists please describe the scope of ODI usage? Remember that EPM people typically do simple extracts from data and metadata and feed it to EPM apps. But that's the proverbial sledgehammer looking for a walnut to crack. What else is going on with the tool? How should we be thinking about going beyond what we typically do in EPM? How should we be thinking about what ODI can bring to our projects?
- Where is Oracle going with its data management tools? EPM people have ODI, Essbase Studio, Essbase Application Server, EPMA, FDM, DRM, native utilities, etc. It's all a big mess and NO ONE adequately describes why a customer should pick one tool or combination of tools over the other. I would LOVE to have some kind of concrete guide to tool selection.
- How is ODI tied into the BI tools? Is it like EPM's KMs for loading data and metadata? More? Less? Core piece of the functionality?
- How are ODI jobs staffed? Are these hardcode data integration types, DW, SQL, something in between?
- There is the ODI graphical way and then you can go far, far, far off the approved path with Procedures and Variables. ODI does it all—that is its charm and its danger. How bad of a practice is it to treat ODI as a shell for executing SQL?
- Must you be a Java programmer to be effective with ODI?
- When is ODI (gasp) not the answer?
Join us, won’t you?