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

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s