Oracle Data Integrator 11g Cookbook

Oracle Data Integrator 11g Cookbook
eBook: $32.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $87.98    Print cover: $54.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 352 pages [ 235mm x 191mm ]
Release Date : May 2013
ISBN : 1849681740
ISBN 13 : 9781849681742
Author(s) : Christophe Dupupet, Denis Gray, Peter C. Boyd-Bowman, Julien Testut
Topics and Technologies : All Books, Enterprise Products and Platforms, Cookbooks, Enterprise, Oracle

Table of Contents

Chapter 1: Installation, Deployment, and Configuration
Chapter 2: Defining the Oracle Data Integrator Security
Chapter 3: Advanced Topology
Chapter 4: Using Variables
Chapter 5: Knowledge Module Internals
Chapter 6: Inside Knowledge Modules – SCD and CDC
Chapter 7: Advanced Coding Techniques
Chapter 8: Package Loops and File Processing
Chapter 9: XML and Web Services
Chapter 10: Advanced Coding Techniques Using the ODI SDK
Chapter 11: More on ODI
    • Chapter 2: Defining the Oracle Data Integrator Security
      • Introduction
      • Setting up LDAP security for Oracle Data Integrator
      • Setting external authentication with Oracle Data Integrator
      • Creating users using generic profiles
      • Creating users using non-generic profiles
      • Creating new custom profiles in the Security navigator
      • Chapter 3: Advanced Topology
        • Introduction
        • Creating a new technology
        • Modifying actions to get more from your diagrams
        • Modifying and expanding datatypes
        • Changing the case sensitivity for code generation
        • Best practice – using the Staging Area User to access your target schema
        • Chapter 4: Using Variables
          • Introduction
          • Passing start-up parameters to a scenario using variables
          • Using table names that run in all contexts using getObjectName
          • Using variables to filter data based on a timestamp
          • Using variables in KM options (and reusing the variables in an interface, package, and so on)
          • Using variables in topology
          • Using variables to control loops inside packages
          • Chapter 5: Knowledge Module Internals
            • Introduction
            • Using the substitution passes
            • Using Java variables in KMs
            • Using Java for condition code generation
            • Invoking Java from the KMs
            • Using substitution methods in Java
            • Combining substitution methods in a KM
            • Chapter 6: Inside Knowledge Modules – SCD and CDC
              • Introduction
              • Implementing Slowly Changing Dimensions (SCD) using ODI
              • Modifying a Slowly Changing Dimension KM to allow undefined behaviors
              • Using Changed Data Capture (CDC) - simple
              • Using Changed Data Capture (CDC) - consistent set
              • Using one single interface to load changes that occur in any dimensions
              • Chapter 7: Advanced Coding Techniques
                • Introduction
                • Using diagrams to develop and maintain models
                • Generating DDL from data models
                • Generating interfaces from data models or diagrams
                • Creating a temporary interface (subquery)
                • Loading data from an SQL query
                • Performing a pivot
                • Loading data using partition exchange
                • Chapter 8: Package Loops and File Processing
                  • Introduction
                  • Defining packages and loops for near real-time execution using a hybrid loop
                  • Using a file from a parameter variable
                  • Detecting files with a variable name
                  • Processing all files in a directory
                  • Processing a large number of files in parallel
                  • Chapter 9: XML and Web Services
                    • Introduction
                    • Defining a connection to XML within ODI
                    • Processing complex files with ODI
                    • Processing XML data within an RDBMS not in memory
                    • Invoking web services from ODI
                    • Invoking asynchronous ODI web services with callbacks
                    • Configuring container-based authentication with ODI web services
                    • Chapter 10: Advanced Coding Techniques Using the ODI SDK
                      • Introduction
                      • Creating the Master and Work repositories using the SDK
                      • Creating a project using the SDK
                      • Automating the import of artifacts using the SDK
                      • Creating models and datastores using the SDK
                      • Creating an interface using the SDK
                      • Invoking and monitoring a scenario using the SDK
                      • Chapter 11: More on ODI
                        • Introduction
                        • Invoking an external program that requires a password
                        • Tuning a standalone ODI agent
                        • Loading a file containing a LOB
                        • Using ODI versioning
                        • Performing a Smart Export/Smart Import
                        • Accessing an Excel spreadsheet
                        • Impacting the data flow by changing the staging area location
                        • Automating Smart Export/Smart Import with the ODI SDK

                        Christophe Dupupet

                        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.

                        Denis Gray

                        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 Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial.

                        Peter C. Boyd-Bowman

                        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. Peter is a co-author of the book Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial.

                        Julien Testut

                        Julien Testut is a Product Manager in the Oracle Data Integration group focusing on Oracle Data Integrator. Julien has an extensive background in Data Integration and Data Quality solutions and is a co-author of Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial. Prior to joining Oracle, he was an Applications Engineer at Sunopsis, which was then acquired by Oracle. Julien holds a Masters degree in Software Engineering.
                        Sorry, we don't have any reviews for this title yet.

                        Code Downloads

                        Download the code and support files for this book.

                        Submit Errata

                        Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


                        - 1 submitted: last submission 24 Oct 2013

                        In LOAD_TRG_SCHEMA.sql script you use date type to populate number field:

                        INSERT INTO TRG_WORK_HIST ( EMPNO, DATE_WORKED, HOURS ) VALUES (7369,  TO_Date( '01/17/2013', 'MM/DD/YYYY'), 8);

                        correct variant should look like

                        INSERT INTO TRG_WORK_HIST ( EMPNO, 
                        DATE_WORKED, HOURS ) VALUES (7369,  TO_CHAR(TO_DATE( '01/17/2013', 'MM/DD/YYYY'),'YYYYMMDD'), 8);

                        Sample chapters

                        You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                        Frequently bought together

                        Oracle Data Integrator 11g Cookbook +    Node.js Blueprints =
                        50% Off
                        the second eBook
                        Price for both: £28.35

                        Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                        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 packages
                        • 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

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


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

                        Code Download and Errata
                        Packt Anytime, Anywhere
                        Register Books
                        Print Upgrades
                        eBook Downloads
                        Video Support
                        Contact Us
                        Awards Voting Nominations Previous Winners
                        Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                        Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software