• Complain

D. Hecksel - Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial

Here you can read online D. Hecksel - Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2012, publisher: Packt Publishing, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

D. Hecksel Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial

Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

Combine high volume data movement, complex transformations and real-time data integration with the robust capabilities of ODI in this practical guideDiscover the comprehensive and sophisticated orchestration of data integration tasks made possible with ODI, including monitoring and error-managementGet to grips with the product architecture and building data integration processes with technologies including Oracle, Microsoft SQL Server and XML filesA comprehensive tutorial packed with tips, images and best practicesIn DetailOracle Data Integrator (ODI) is Oracles 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. Youll 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 ODIs workflow and task orchestration capabilities are explained before introducing you to Error Management with ODIs 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.What you will learn from this bookGet to grips with the various components of the Oracle Data Integrator architectureLearn how to install ODI quickly and effectively using recommended best practicesOrchestrate your data integration processing by designing ODI packages and scenariosDiscover how to develop ODI interfaces in order to effortlessly move data between servers and filesGet the full lowdown on both Error Processing and Management and MonitoringGive your knowledge a boost with in-depth coverage of various data sources and targets including Oracle, Microsoft SQL Server and XML filesMaster key ODI concepts like Physical and Logical Architectures or the Knowledge ModulesTake advantage of expert advice from the authors combined 15 years of ODI experienceApproachGetting Started with Oracle Data Integrator 11g: A Hands-On Tutorial is a practical tutorial bursting with tips, illustrations and real-world best practices to get you on your way with ODI.Who this book is forIf you are a software/ETL developer or database administrator who is new to Oracle Data Integrator but want to get hands-on with the product quickly, then Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial is for you. You should have some experience with databases, SQL and ETL technologies.

D. Hecksel: author's other books


Who wrote Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial? Find out the surname, the name of the author of the book and a list of all author's works by series.

Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

Reset

Interval:

Bookmark:

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

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

Copyright 2012 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the authors, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: May 2012

Production Reference: 1180512

Published by Packt Publishing Ltd. Livery Place 35 Livery Street Birmingham B3 2PB, UK.

ISBN 978-1-84968-068-4

www.packtpub.com

Cover Image by David Gutierrez ( <> )

Credits

Authors

Peter C. Boyd-Bowman

Christophe Dupupet

Denis Gray

David Hecksel

Julien Testut

Bernard Wheeler

Reviewers

Uli Bethke

Kevin Glenny

Maciej Kocon

Suresh Lakshmanan

Ronald Rood

Acquisition Editor

Stephanie Moss

Lead Technical Editor

Hyacintha D'Souza

Technical Editors

Veronica Fernandes

Joyslita D'Souza

Project Coordinator

Joel Goveya

Proofreader

Katherine Tarr

Indexer

Hemangini Bari

Graphics

Valentina D'silva

Manu Joseph

Production Coordinator

Prachali Bhiwandkar

Cover Work

Prachali Bhiwandkar

Foreword

The May 26, 2011 edition of the Economist magazine cites a report by the the McKinsey Global Institute (MGI) about data becoming a factor of production, such as physical or human capital. Across the industry, enterprises are investing significant resources in harnessing value from vast amounts of data to innovate, compete, and reduce operational costs.

In light of this global focus on data explosion, data revolution, and data analysis the authors of this book couldn't have possibly chosen a more appropriate time to share their unique insight and broad technical experience in leveraging Oracle Data Integrator (ODI) to deliver key data integration initiatives across global enterprises.

Oracle Data Integrator constitutes a key product in Oracle's Data Integration product portfolio. ODI product architecture is built on high performance ELT, with guiding principles being: ease of use, avoiding expensive mid-tier transformation servers, and flexibility to integrate with heterogeneous platforms.

I am delighted that the authors, six of the foremost experts on Oracle Data Integrator 11g have decided to share their deep knowledge of ODI in an easy to follow manner that covers the subject material both from a conceptual and an implementation aspect. They cover how ODI leverages next generation Extract-Load-Transformation technology to deliver extreme performance in enabling state of the art solutions that help deliver rich analytics and superior business intelligence in modern data warehousing environments. Using an easy-to-follow hands-on approach, the authors guide the reader through successively complex and challenging data integration tasksfrom the basic blocking and tackling of creating interfaces using a multitude of source and target technologies, to more advanced ODI topics such as data workflows, management and monitoring, scheduling, impact analysis and interfacing with ODI Web Services. If your goal is to jumpstart your ODI 11g knowledge and productivity to quickly deliver business value, you are on the right track. Dig in, and Integrate.

Alok Pareek

Vice President, Product Management/Data Integration

Oracle Corp

About the Authors

Peter C. Boyd-Bowman is a Technical Consulting Director with the Oracle Corporation. He has over 30 years of software engineering and database management experience, including 12 years of focused interest in data warehousing and business intelligence. Capitalizing on his extensive background in Oracle database technologies dating back to 1985, he has spent recent years specializing in data migration. After many successful project implementations using Oracle Warehouse Builder and shortly after Oracle's acquisition of the Sunopsis Corporation, he switched his area of focus over to Oracle's flagship ETL product: Oracle Data Integrator. He holds a BS degree in Industrial Management and Computer Science from Purdue University and currently resides in North Carolina.

Christophe Dupupet is a Director of Product Management for ODI at Oracle. In this role, he focuses on the Customer Care program where he works closely with strategic customers implementing ODI. Prior to Oracle, he was part of the team that started the operations for Sunopsis in the US (Sunopsis created the ODI product and was acquired by Oracle in 2006).

He holds an Operations Research degree from EISTI in France, a Masters Degree in Operations Research from Florida Tech, and a Certificate in Management from Harvard University.

He writes blogs (mostly technical entries) at http://blogs.oracle.com/dataintegration as well as white papers.

Special thanks to my wife, Viviane, and three children, Quentin, Audrey, and Ines, for their patience and support for the long evenings and weekends spent on this book.

David Hecksel is a Principal Data Integration Architect at Oracle. Residing in Dallas, Texas, he joined Oracle in 2006 as a Pre-sales Architect for Oracle Fusion Middleware. Six months after joining, he volunteered to add pre-sales coverage for a recently acquired product called Oracle Data Integrator and the rest (including the writing of this book) has been a labor of love working with a platform and solution that simultaneously provides phenomenal user productivity and system performance gains to the traditionally separate IT career realms of Data Warehousing, Service Oriented Architects, and Business Intelligence developers. Before joining Oracle, he spent six years with Sun Microsystems in their Sun Java Center and was CTO for four years at Axtive Software, architecting and developing several one-to-one marketing and web personalization platforms such as e.Monogram. In 1997, he also invented, architected, developed, and marketed the award-winning JCertify product onlinethe industry's first electronic delivery of study content and exam simulation for the Certified Java Programmer exam. Prior to Axtive Software, he was with IBM for 12 years as a Software Developer working on operating system, storage management, and networking software products. He holds a B.S. in Computer Science from the University of Wisconsin-Madison and a Masters of Business Administration from Duke University.

Julien Testut is a Product Manager in the Oracle Data Integration group focusing on Oracle Data Integrator. He has an extensive background in Data Integration and Data Quality technologies and solutions. Prior to joining Oracle, he was an Applications Engineer at Sunopsis which was then acquired by Oracle. He holds a Masters degree in Software Engineering.

Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial»

Look at similar books to Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


Reviews about «Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial»

Discussion, reviews of the book Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.