Book Image

Oracle Data Integrator 11g Cookbook

Book Image

Oracle Data Integrator 11g Cookbook

Overview of this book

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.

Related Content you might be interested in

Current Title:

Small book image
Oracle Data Integrator 11g Cookbook
May, 2013 | 352 pages
No titles found
Table of Contents (19 chapters)
Oracle Data Integrator 11g Cookbook
Oracle Data Integrator 11g Cookbook
Credits
Credits
Foreword
Foreword
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Installation, Deployment, and Configuration
Installation, Deployment, and Configuration
Introduction
Deploying and configuring a standalone agent manually
Deploying a JEE ODI Agent
Configuring a standalone agent with OPMN
Deploying JDBC drivers with a JEE ODI Agent
2
Defining the Oracle Data Integrator Security
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
3
Advanced Topology
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
4
Using Variables
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
5
Knowledge Module Internals
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
6
Inside Knowledge Modules – SCD and CDC
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
7
Advanced Coding Techniques
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
8
Package Loops and File Processing
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
9
XML and Web Services
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
10
Advanced Coding Techniques Using the ODI SDK
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
11
More on ODI
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
Index
Index

www.PacktPub.com

Support files, eBooks, discount offers and more

You might want to visit www.PacktPub.com for support files and downloads related to your book.

Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at for more details.

At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.

http://PacktLib.PacktPub.com

Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book library. Here, you can access, read and search across Packt's entire library of books. 

Why Subscribe?

  • Fully searchable across every book published by Packt

  • Copy and paste, print and bookmark content

  • On demand and accessible via web browser

Free Access for Packt account holders

If you have an account with Packt at www.PacktPub.com, you can use this to access PacktLib today and view nine entirely free books. Simply use your login credentials for immediate access.

Instant Updates on New Packt Books

Get notified! Find out when new books are published by following @PacktEnterprise on Twitter, or the Packt Enterprise Facebook page.

Previous Section
Next Chapter