Book description
This is a brilliant crash course in Oracle Data Integrator that pulls you straight into the platform through practical instructions and real-world situations rather than dry theory. Written by a team of seasoned experts.
- Discover the comprehensive and sophisticated orchestration of data integration tasks made possible with ODI, including monitoring and error-management
- Get to grips with the product architecture and building data integration processes with technologies including Oracle, Microsoft SQL Server and XML files
- A comprehensive tutorial packed with tips, images and best practices
In Detail
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
-
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
- Table of Contents
- Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
- Credits
- Foreword
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Product Overview
- 2. Product Installation
- 3. Using Variables
- 4. ODI Sources, Targets, and Knowledge Modules
- 5. Working with Databases
- 6. Working with MySQL
-
7. Working with Microsoft SQL Server
- Example: Working with SQL Server
- Sample scenario
- Summary
- 8. Integrating File Data
- 9. Working with XML Files
- 10. Creating Workflows—Packages and Load Plans
- 11. Error Management
- 12. Managing and Monitoring ODI Components
- 13. Concluding Remarks
- Index
Product information
- Title: Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
- Author(s):
- Release date: May 2012
- Publisher(s): Packt Publishing
- ISBN: 9781849680684
You might also like
book
Oracle Data Integrator 11g Cookbook
This book is all you need to take your understanding of Oracle Data Integrator to the …
book
Oracle Data Integration: Tools for Harnessing Data
Deliver continuous access to timely and accurate BI across your enterprise using the detailed information in …
book
Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition, Second Edition
Learn through this practical guide to SQL tuning how Oracle's own experts do it, using a …
book
Pro Oracle GoldenGate for the DBA
Take a simple approach to learning the Oracle GoldenGate product. This approach provides the in-depth perspective …