Book description
This book is all you need to take your understanding of Oracle Data Integrator to the next level. From initial deployment right through to esoteric techniques, the task-based approach will enhance your expertise effortlessly.
- 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
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.
Table of contents
-
Oracle Data Integrator 11g Cookbook
- Table of Contents
- Oracle Data Integrator 11g Cookbook
- Credits
- Foreword
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Installation, Deployment, and Configuration
- 2. Defining the Oracle Data Integrator Security
- 3. Advanced Topology
-
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
- 5. Knowledge Module Internals
-
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
- 7. Advanced Coding Techniques
- 8. Package Loops and File Processing
- 9. XML and Web Services
- 10. Advanced Coding Techniques Using the ODI SDK
-
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
- Index
Product information
- Title: Oracle Data Integrator 11g Cookbook
- Author(s):
- Release date: May 2013
- Publisher(s): Packt Publishing
- ISBN: 9781849681742
You might also like
book
Oracle GoldenGate 11g Complete Cookbook
Dig deep into administering Oracle Goldengate 11g using this comprehensive cookbook. From the very basics of …
book
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
This is a brilliant crash course in Oracle Data Integrator that pulls you straight into the …
book
Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition, Second Edition
Learn through this practical guide to SQL tuning how Oracle's own experts do it, using a …
book
Oracle Data Integration: Tools for Harnessing Data
Deliver continuous access to timely and accurate BI across your enterprise using the detailed information in …