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

Hecksel, David

ISBN 10: 184968068X / ISBN 13: 9781849680684

Editore: Packt Publishing 2012-04, 2012

Riguardo questo articolo

Codice articolo 6666-IUK-9781849680684

Dati bibliografici

Titolo: Getting Started with Oracle Data Integrator ...

Casa editrice: Packt Publishing 2012-04

Data di pubblicazione: 2012

Legatura: PF

Condizione: New

Descrizione articolo

Riassunto:

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.

Contenuti:

Preface
Chapter 1: Product Overview
Chapter 2: Product Installation
Chapter 3: Using Variables
Chapter 4: ODI Sources, Targets, and Knowledge Modules
Chapter 5: Working with Databases
Chapter 6: Working with MySQL
Chapter 7: Working with Microsoft SQL Server
Chapter 8: Integrating File Data
Chapter 9: Working with XML Files
Chapter 10: Creating Workflows—Packages and Load Plans
Chapter 11: Error Management
Chapter 12: Managing and Monitoring ODI Components
Chapter 13: Concluding Remarks
Index