New Book : Oracle Data Integrator 11g Cookbook

http://www.packtpub.com/oracle-data-integrator-11g-cookbook/book

I got hold on this book, this is first book i seen on ODI. Currenty reading it and will publish review soon.

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.

• Chapter 1: 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

• 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

http://www.packtpub.com/oracle-data-integrator-11g-cookbook/book