• Complain

Christophe Dupupet - Oracle Data Integrator 11g Cookbook

Here you can read online Christophe Dupupet - Oracle Data Integrator 11g Cookbook full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2013, 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.

Christophe Dupupet Oracle Data Integrator 11g Cookbook

Oracle Data Integrator 11g Cookbook: summary, description and annotation

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

Over 60 field-tested recipes for successful data integration projects with Oracle Data Integrator

Overview

  • Clear, step-by-step recipes to walk you through some of the most advanced features of Oracle Data Integrator
  • Covers everything from administration, to development, to deployment, including advanced coding techniques using the Oracle Data Integrator SDK
  • Numerous code samples, screenshots, diagrams, and best practice recommendations

In Detail

Oracle Data Integrator (ODI) is Oracles 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.

What you will learn from this book

  • Understand how to install, secure, and deploy Oracle Data Integrator
  • Explore the advanced features of ODI Topology, including creating new technologies and data types
  • Learn many new ways to use variables in the product, including in Topology and Knowledge Modules
  • Discover the inner workings of the code substitution in ODI to become more proficient with Knowledge Modules
  • Get to grips with reusable coding best practices for interfaces and packagesFind out more more about using XML and web services in ODI
  • Find out more more about using XML and web services in ODI
  • Leverage the SDK to expand your solutions
  • Review many of the key concepts and best practices of ODI

Approach

Written as a practical Cookbook, the recipes in this essential guide will help you make the most out of Oracle Data Integrator 11g.

Who this book is written for

This book is meant for people who already possess a basic understanding of Oracle Data Integrator and want to take it to the next level by learning how to better leverage advanced ODI features and functionality as they continue to develop and manage their data integration projects.

Christophe Dupupet: author's other books


Who wrote Oracle Data Integrator 11g Cookbook? Find out the surname, the name of the author of the book and a list of all author's works by series.

Oracle Data Integrator 11g Cookbook — 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 "Oracle Data Integrator 11g Cookbook" 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
Oracle Data Integrator 11g Cookbook

Oracle Data Integrator 11g Cookbook

Copyright 2013 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 2013

Production Reference: 1080513

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-84968-174-2

www.packtpub.com

Cover Image by Karl Moore (<>)

Credits

Authors

Christophe Dupupet

Peter C. Boyd-Bowman

Denis Gray

Julien Testut

Reviewers

Uli Bethke

Hans Forbrich

Kevin Glenny

Maciej Kocon

Ray McCormack

Acquisition Editors

Edward Gordon

Erol Staveley

Lead Technical Editor

Neeshma Ramakrishnan

Technical Editors

Saijul Shah

Sayali Mirajkar

Hardik B. Soni

Project Coordinator

Arshad Sopariwala

Proofreader

Paul Hindle

Indexer

Monica Ajmera

Production Coordinator

Aparna Bhagat

Cover Work

Aparna Bhagat

Foreword

In 1998, when Sunopsis first opened its door to begin development of the product that would become ODI, the technology landscape was very different from today. There were very few data warehouses over 10 terabytes, and both the underlying hardware and software were struggling to keep up with the load and query demands placed upon them. As a result, the warehouses only included the most critical transactional data from the few key systems. The prevailing ETL approach of the day was to hand-build highly optimized flows, which executed in dedicated hardware, and then spoon-feed the results into the data warehouse. In this context, the founding principles of ODI were extraordinarily bold: leverage the data warehouse itself as the transformation engine and enable developers to work at a much higher level of abstraction, counting on the tool to generate an optimized execution plan.

Viewed with hindsight 15 years later, these principles seem prescient. Data warehouses have grown to be petabytes in size, and the hardware that houses them is often the most powerful in the data center 100s of processor cores, terabytes of RAM, and 10s of terabytes of Flash. After many years of concerted effort, and with thousands of mappings to show for it, many enterprises have added far more transaction systems into their warehouses, and they are now looking to bring in data sets that have hitherto been dark (for example, server logs, social media feeds), and may be best preprocessed on open source distributed frameworks such as Hadoop. The world has finally caught up to ODI.

Congratulations on your decision to take a different approach to bulk movement and transformation of data within your business. For developers experienced on traditional ETL tools, you will discover yourself doing far less mundane work once you grasp a few of the key ODI concepts such as topologies, knowledge modules, and set-based transformation. This book will be an excellent companion for you on this journey. Written by four experts on the product (with decades of experience among them), including key product managers who are continuing to drive ODI's evolution, this book complements the product documentation with a variety of practical recipes. In addition to all of the common tasks required in populating a data warehouse (for example, change data capture, slowly changing dimensions), readers will also find valuable information on using ODI within a web service environment, and how to use its powerful APIs to programmatically author ODI artifacts.

Since its acquisition, ODI has become the key bulk data technology within Oracle products and within our cloud offerings. I hope you find it as impactful in your business as it has been in ours.

Brad Adelberg

Vice President, Development for Data Integration

Oracle Corp.

About the Authors

Christophe Dupupet is a Director in the Fusion Middleware Architects Team, where he leads the expertise on ODI. The team works closely with strategic customers that implement ODI, and helps define best practices on the product in terms of architecture, implementation, and operations.

Prior to Oracle, Christophe was part of the team that started the operations for Sunopsis in the US, where he lead the technical team (presales, support, and training). Sunopsis was acquired by Oracle in 2006.

Christophe 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.

Christophe is a co-author of the book Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial .

There would be no book if we did not have a fantastic product and customers to trust us with this product. I want to particularly thank all the individuals that have helped this product become what it is today: the architects and software engineers that work and have worked on ODI for their vision and production; our support engineers that help our customers every day and help shape best practices with a forever growing knowledge base (support.oracle.com is truly a goldmine if you are looking for information on how to use ODI); our sales engineers and product managers that help customers and partners in their selection of our product.

Peter C. Boyd-Bowman is a Technical Director and Consultant 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. Peter holds a BS degree in Industrial Management and Computer Science from Purdue University and currently resides in North Carolina.

Denis Gray is a Director of Product Management for Data Integration at Oracle. Denis has over 15 years of experience in the data-integration field. For the past seven years, Denis has been an integral part of Oracle Development Organization as a Product Manager within Fusion Middleware, delivering data integration solutions. Prior to this, Denis was a data integration consult for Hyperion Solutions (Oracle). Here, Denis worked at many of the largest Fortune 100 companies, building data warehouses and implementing business intelligence solutions. Denis has a Bachelor's Degree in Computer Science from the University of Missouri and currently resides in St. Louis, MO. Denis also co-authored the Packt book

Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «Oracle Data Integrator 11g Cookbook»

Look at similar books to Oracle Data Integrator 11g Cookbook. 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 «Oracle Data Integrator 11g Cookbook»

Discussion, reviews of the book Oracle Data Integrator 11g Cookbook 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.