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