Book Image

Oracle Data Integrator 11g Cookbook

Book Image

Oracle Data Integrator 11g Cookbook

Overview of this book

Oracle Data Integrator (ODI) is Oracle's strategic data integration platform for high-speed data transformation and movement between different systems. From high-volume batches, to SOA-enabled data services, to trickle operations, ODI is a cutting-edge platform that offers heterogeneous connectivity, enterprise-level deployment, and strong administrative, diagnostic, and management capabilities."Oracle Data Integrator 11g Cookbook" will take you on a journey past your first steps with ODI to a new level of proficiency, lifting the cover on many of the internals of the product to help you better leverage the most advanced features.The first part of this book will focus on the administrative tasks required for a successful deployment, moving on to showing you how to best leverage Knowledge Modules with explanations of their internals and focus on specific examples. Next we will look into some advanced coding techniques for interfaces, packages, models, and a focus on XML. Finally the book will lift the cover on web services as well as the ODI SDK, along with additional advanced techniques that may be unknown to many users.Throughout "Oracle Data Integrator 11g Cookbook", the authors convey real-world advice and best practices learned from their extensive hands-on experience.
Table of Contents (19 chapters)
Oracle Data Integrator 11g Cookbook
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

About the Reviewers

Uli Bethke has been working with ODI since 2007. After some initial difficulties familiarizing himself with the tool, he quickly realized the huge potential of ODI. A couple of great innovations went into ODI and it is light years ahead of any of its competitors. It is one of those tools that really make a difference. Uli has been working in data integration and data warehousing for more than 13 years. Verticals include Finance, Retail, Pharma, and Education.

Uli is a managing partner and owner of a small but growing BI consultancy in Dublin, Ireland. He offers expert services on ODI including training. He also consults on data warehousing, data integration, and enterprise architecture. If you want to avail of any of his services, you can contact him through his blog http://www.bi-q.ie or directly via e-mail.

Uli has also been a reviewer of the book Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial, published by Packt.

Hans Forbrich has been working with, consulting on, and teaching Oracle products for 30 years. He is experienced in data integration using Oracle Warehouse Builder and Oracle Data Integrator, as well as with the SOA and OSB technologies. Hans has been enthusiastic about ODI since the Sunopsis acquisition by Oracle, and regularly teaches the Oracle University ODI courses in North America through his partner, ExitCertified Corp.

Hans has been an Oracle ACE since 2005 and an Oracle ACE Director since 2008. For more information about the Oracle ACE program, see http://www.oracle.com/technetwork/community/oracle-ace/index.html.

Hans is a frequent reviewer of Packt Publishing's Oracle books, spanning the range of OracleVM and Oracle Scheduler through Oracle SOA Suite.

Kevin Glenny has international Oracle Technical Architecture experience integrating large scale real-time systems. His most notable projects include the European Grid Infrastructure (EGI) supporting the particle physics large data generated by CERN.

He specializes in the area of scalable OLAP and OLTP systems, building on his Grid computing background. He is also the author of numerous technical articles and his industry insights can be found on his company's blog at http://oracle.gridwisetech.com/.

GridwiseTech, Oracle Partner of the Year 2013, is the independent specialist on scalability and large data. The company delivers robust IT architectures for significant data and processing loads. GridwiseTech operates globally and serves clients ranging from Fortune Global 500 companies to government and academia.

Maciej Kocon has been in the IT industry for over 12 years. He began his career as a database application programmer and quickly developed a passion for SQL language, data processing and analysis.

He entered the realm of BI and data warehousing, and has specialized in the design of various data integration frameworks for high data volumes. His experience covers the full data-warehouse lifecycle in various sectors including Financial Services, Retail, Public Sector, Telecommunications, and Life Sciences.

He first came across the tool in 2005 when it was Sunopsis product and has been gradually spending more time on it since. For the last 4 years he has worked full-time on ODI, performing heavy customizations made for enterprise class data warehouse implementations.

He believes the template architecture, which ODI is built upon, is the perfect solution giving the best from both worlds (flexibility and reusability), offering practically limitless possibilities

Maciej is managing partner and owner of a small but growing BI consultancy in Dublin, Ireland. He offers consulting services on data warehousing and data integration architectural solutions tailored for enterprises. He is a contributor to the blog http://www.bi-q.ie that focuses on data integration and ODI in particular.

If you want to avail of any of his services you can contact him through that website or via e-mail:

Maciej has also been a reviewer of the book Getting Started with Oracle Data Integrator 11g, published by Packt.

Ray McCormack was introduced to databases 12 years ago, and since that time he has been synchronizing his on-job and off-job interests with database programming. He has a comprehensive background in database application design, development, business process mapping, systems integration, and leading teams of developers.

Originally from a development background, Ray is very passionate about Business Intelligence and Data Warehousing solutions. He has complete end-to-end expertise in all facets of BI/DW including project management, dimensional modeling, performance tuning, ETL design and development, report and dashboard design and development, as well as installation and administration. He has vast experience in various roles across industry sectors such as pharmaceutical (Icon PLC), education (University of San Diego), scientific (National Instruments), and broadcasting (RTE).

Ray's hobbies include spending time with his family, all sports, and playing with the latest technological gadgets. He loves traveling, having worked in California for 8 years.