Book Image

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial

Book Image

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial

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, 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. "Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" provides you with everything you to get up and running with Oracle Data Integrator, and more! Following an example scenario, the book covers essential information about the ODI architecture and using ODI across different databases (Oracle, Microsoft SQL Server and MySQL), and file types such as XML, before covering Orchestrating Data Integration Workflows, Error Management, Operational Management and Monitoring, and beyond. "Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" begins by describing the Oracle Data Integrator architecture and teaching you to install the product following best practices. You'll then be introduced to some of the key concepts of ODI such as the Knowledge Modules. Later topics include moving and transforming data from sources to targets including the Oracle Database, Microsoft SQL Server, MySQL, Flat files, and XML files, each with illustrated hands-on examples for the different technologies. Your learning experience will be made all the more rich with chapters introducing, explaining and leveraging additional ODI functionality such as variables, reusable procedures, temporary indexes and more. Finally ODI's workflow and task orchestration capabilities are explained before introducing you to Error Management with ODI's built-in 'error hospital' and 'error recycling' capabilities for non-compliant data, not to mention tackling ODI Studio, ODI Console and Enterprise Manager Fusion Middleware Control.
Table of Contents (21 chapters)
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
10
Creating Workflows—Packages and Load Plans
13
Concluding Remarks
Index

About the Reviewers

Uli Bethke has more than 12 years of experience in various areas of data management such as data analysis, data architecture, data modeling, data migration and integration, ETL, data quality, data cleansing, business intelligence, database administration, data mining, and enterprise data warehousing. He has worked in finance, the pharmaceutical industry, education, and retail.

He has more than three years of experience in ODI 10g and 11g.

He is an independent Data Warehouse Consultant based in Dublin, Ireland. He has implemented business intelligence solutions for various blue chip organizations in Europe and North America. He runs an ODI blog at www.bi-q.ie.

Kevin Glenny has international software engineering experience, which includes work for European Grid Infrastructure (EGI), interconnecting 140K CPU cores and 25 petabytes of disk storage. He is a highly rated Oracle Consultant, with four years of experience in international consulting for blue chip enterprises. 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 www.BigDataMatters.com.

GridwiseTech, as Oracle Partner of the Year 2011, 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 10 years. He began his career as a Database Application Programmer and quickly developed a passion for the SQL language, data processing, and analysis.

He entered the realm of BI and data warehousing and has specialized in the design of EL-T frameworks for integration of high data volumes. His experience covers the full data warehouse lifecycle in various sectors including financial services, retail, public sector, telecommunications, and clinical research.

To relax, he enjoys nothing more than taking his camera outdoors for a photo session.

He can be reached at his personal blog http://artofdi.com.

Suresh Lakshmanan is currently working as Senior Consultant at Keane Inc., providing technical and architectural solutions for its clients in Oracle products space. He has seven years of technical expertise with high availability Oracle Databases/Applications.

Prior to joining Keane Inc., he worked as a Consultant for Sun Microsystems in Clustered Oracle E-Business Suite implementations for the TSO team. He also worked with Oracle India Pvt Ltd for EFOPS DBA team specializing in Oracle Databases, Oracle E-Business Suite, Oracle Application servers, and Oracle Demantra. Before joining Oracle India, he worked as a Consultant for GE Energy specializing in the core technologies of Oracle.

His key areas of interests include high availability/high performance system design and disaster recovery solution design for Oracle products. He holds an MBA Degree in Computer Systems from Madurai Kamaraj University, Madurai, India. He has done his Bachelor of Engineering in Computer Science from PSG College of Technology, Coimbatore, India. He has written many Oracle related articles in his blog which can be found at http://applicationsdba.blogspot.com and can be reached at .

Ronald Rood is an innovating Oracle DBA with over 20 years of IT experience. He has built and managed cluster databases on about each and every platform that Oracle has ever supported, right from the famous OPS databases in version 7 until the latest RAC releases, the current release being 11g. He is constantly looking for ways to get the most value out of the database to make the investment for his customers even more valuable. He knows how to handle the power of the rich Unix environment very well and this is what makes him a first-class troubleshooter and solution architect. Apart from the spoken languages such as Dutch, English, German, and French, he also writes fluently in many scripting languages.

Currently, he is a Principal Consultant working for Ciber in The Netherlands where he cooperates in many complex projects for large companies where downtime is not an option. Ciber (CBR) is an Oracle Platinum Partner and committed to the limit.

He often replies in the oracle forums, writes his own blog called From errors we learn... (http://ronr.blogspot.com), writes for various Oracle-related magazines, and also wrote a book, Mastering Oracle Scheduler in Oracle 11g Databases where he fills the gap between the Oracle documentation and customers' questions. He also was part of the technical reviewing teams for Oracle 11g R1/R2 Real Application Clusters Essentials and Oracle Information Integration, Migration, and Consolidation, both published by Packt Publishing.

He has many certifications to his credit, some of them are Oracle Certified Master, Oracle Certified Professional, Oracle Database 11g Tuning Specialist, Oracle Database 11g Data Warehouse Certified Implementation Specialist.

He fills his time with Oracle, his family, sky-diving, radio controlled model airplane flying, running a scouting group, and having lot of fun.

He believes "A problem is merely a challenge that might take a little time so solve".