Categories
Ebooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Computer in the office
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Multimedia trainings
- Real estate
- Persuasion and NLP
- Taxes
- Social policy
- Guides
- Presentations
- Leadership
- Public Relation
- Reports, analyses
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
E-press
- Architektura i wnętrza
- Biznes i Ekonomia
- Home and garden
- E-business
- Finances
- Personal finance
- Business
- Photography
- Computer science
- HR & Payroll
- Computers, Excel
- Accounts
- Culture and literature
- Scientific and academic
- Environmental protection
- Opinion-forming
- Education
- Taxes
- Travelling
- Psychology
- Religion
- Agriculture
- Book and press market
- Transport and Spedition
- Healthand beauty
-
History
-
Computer science
- Office applications
- Data bases
- Bioinformatics
- IT business
- CAD/CAM
- Digital Lifestyle
- DTP
- Electronics
- Digital photography
- Computer graphics
- Games
- Hacking
- Hardware
- IT w ekonomii
- Scientific software package
- School textbooks
- Computer basics
- Programming
- Mobile programming
- Internet servers
- Computer networks
- Start-up
- Operational systems
- Artificial intelligence
- Technology for children
- Webmastering
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Narrative poetry
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
School textbooks
-
Popular science and academic
- Archeology
- Bibliotekoznawstwo
- Cinema studies
- Philology
- Polish philology
- Philosophy
- Finanse i bankowość
- Geography
- Economy
- Trade. World economy
- History and archeology
- History of art and architecture
- Cultural studies
- Linguistics
- Literary studies
- Logistics
- Maths
- Medicine
- Humanities
- Pedagogy
- Educational aids
- Popular science
- Other
- Psychology
- Sociology
- Theatre studies
- Theology
- Economic theories and teachings
- Transport i spedycja
- Physical education
- Zarządzanie i marketing
-
Guides
-
Game guides
-
Professional and specialist guides
-
Law
- Health and Safety
- History
- Road Code. Driving license
- Law studies
- Healthcare
- General. Compendium of knowledge
- Academic textbooks
- Other
- Construction and local law
- Civil law
- Financial law
- Economic law
- Economic and trade law
- Criminal law
- Criminal law. Criminal offenses. Criminology
- International law
- International law
- Health care law
- Educational law
- Tax law
- Labor and social security law
- Public, constitutional and administrative law
- Family and Guardianship Code
- agricultural law
- Social law, labour law
- European Union law
- Industry
- Agricultural and environmental
- Dictionaries and encyclopedia
- Public procurement
- Management
-
Tourist guides and travel
- Africa
- Albums
- Southern America
- North and Central America
- Australia, New Zealand, Oceania
- Austria
- Asia
- Balkans
- Middle East
- Bulgary
- China
- Croatia
- The Czech Republic
- Denmark
- Egipt
- Estonia
- Europe
- France
- Mountains
- Greece
- Spain
- Holand
- Iceland
- Lithuania
- Latvia
- Mapy, Plany miast, Atlasy
- Mini travel guides
- Germany
- Norway
- Active travelling
- Poland
- Portugal
- Other
- Russia
- Romania
- Slovakia
- Slovenia
- Switzerland
- Sweden
- World
- Turkey
- Ukraine
- Hungary
- Great Britain
- Italy
-
Psychology
- Philosophy of life
- Kompetencje psychospołeczne
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Audiobooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Real estate
- Persuasion and NLP
- Taxes
- Guides
- Presentations
- Leadership
- Public Relation
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
History
-
Computer science
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
Popular science and academic
-
Guides
-
Professional and specialist guides
-
Law
-
Tourist guides and travel
-
Psychology
- Philosophy of life
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Videocourses
-
Data bases
-
Big Data
-
Biznes, ekonomia i marketing
-
Cybersecurity
-
Data Science
-
DevOps
-
For children
-
Electronics
-
Graphics/Video/CAX
-
Games
-
Microsoft Office
-
Development tools
-
Programming
-
Personal growth
-
Computer networks
-
Operational systems
-
Software testing
-
Mobile devices
-
UX/UI
-
Web development
-
Management
Podcasts
- Ebooks
- Computer science
- Business applications
- Oracle Data Integrator 11g Cookbook. 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
E-book details
Log in, If you're interested in the contents of the item.
Oracle Data Integrator 11g Cookbook. 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
Christophe Dupupet, Peter Boyd-Bowman, Julien Testut, Denis Gray
Ebook
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.
- Oracle Data Integrator 11g Cookbook
- Table of Contents
- Oracle Data Integrator 11g Cookbook
- Credits
- Foreword
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Support files, eBooks, discount offers and more
- Why Subscribe?
- Free Access for Packt account holders
- Instant Updates on New Packt Books
- Support files, eBooks, discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code
- Errata
- Piracy
- Questions
- 1. Installation, Deployment, and Configuration
- Introduction
- Understanding the ODI Installation
- Deploying and configuring a standalone agent manually
- Getting ready
- How to do it...
- How it works...
- Theres more...
- Deploying a JEE ODI Agent
- How to do it...
- How it works...
- There's more...
- Configuring a standalone agent with OPMN
- Getting ready
- How to do it...
- How it works...
- There's more...
- Deploying JDBC drivers with a JEE ODI Agent
- Getting ready
- How to do it
- There's more...
- Introduction
- 2. Defining the Oracle Data Integrator Security
- Introduction
- Setting up LDAP security for Oracle Data Integrator
- How to do it...
- How it works...
- Setting external authentication with Oracle Data Integrator
- How to do it...
- How it works...
- There's more...
- Creating users using generic profiles
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Creating users using non-generic profiles
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating new custom profiles in the Security navigator
- Getting ready
- How to do it...
- How it works...
- 3. Advanced Topology
- Introduction
- Creating a new technology
- Getting ready
- How to do it...
- How it works...
- There's more...
- Modifying actions to get more from your diagrams
- Getting ready
- How to do it...
- How it works...
- There's more...
- Modifying and expanding datatypes
- Getting ready
- How to do it...
- How it works...
- Changing the case sensitivity for code generation
- Getting ready
- How to do it...
- How it works...
- There is more...
- Best practice using the Staging Area User to access your target schema
- Getting ready
- How to do it...
- How it works...
- 4. Using Variables
- Introduction
- Passing start-up parameters to a scenario using variables
- Getting ready
- How to do it...
- How it works...
- Using table names that run in all contexts using getObjectName
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using variables to filter data based on a timestamp
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using variables in KM options (and reusing the variables in an interface, package, and so on)
- How to do it...
- How it works...
- There's more...
- Using variables in topology
- How to do it...
- How it works...
- Using variables to control loops inside packages
- Getting ready...
- How to do it...
- How it works...
- There's more...
- 5. Knowledge Module Internals
- Introduction
- Using the substitution passes
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using Java variables in KMs
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using Java for condition code generation
- Getting ready
- How to do it...
- How it works...
- There's more...
- Invoking Java from the KMs
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using substitution methods in Java
- Getting ready
- How to do it...
- How it works...
- There's more...
- Combining substitution methods in a KM
- Getting ready
- How to do it...
- How it works...
- There's more...
- 6. Inside Knowledge Modules SCD and CDC
- Introduction
- Implementing Slowly Changing Dimensions (SCD) using ODI
- Getting ready
- How to do it...
- How it works...
- Modifying a Slowly Changing Dimension KM to allow undefined behaviors
- Getting ready
- How to do it...
- How it works...
- Using Changed Data Capture (CDC) - simple
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using Changed Data Capture (CDC) - consistent set
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using one single interface to load changes that occur in any dimensions
- Getting ready
- How to do it...
- How it works...
- There's more
- 7. Advanced Coding Techniques
- Introduction
- Using diagrams to develop and maintain models
- Getting ready
- How to do it...
- How it works...
- There's more...
- Generating DDL from data models
- Getting ready
- How to do it...
- How it works...
- Generating interfaces from data models or diagrams
- Getting ready
- How to do it...
- How it works...
- Creating a temporary interface (subquery)
- Getting ready
- How to do it...
- How it works...
- There's more...
- Loading data from an SQL query
- Getting ready
- How to do it...
- How it works...
- Performing a pivot
- Getting ready
- How to do it...
- How it works...
- There's more...
- Loading data using partition exchange
- Getting ready
- How to do it...
- How it works...
- 8. Package Loops and File Processing
- Introduction
- Defining packages and loops for near real-time execution using a hybrid loop
- Getting ready
- How to do it...
- How it works...
- Using a file from a parameter variable
- Getting ready
- How to do it...
- How it works...
- There's more...
- Detecting files with a variable name
- Getting ready
- How to do it...
- How it works...
- There's more...
- Processing all files in a directory
- Getting ready
- How to do it...
- How it works...
- Processing a large number of files in parallel
- Getting ready
- How to do it...
- How it works...
- There's more...
- 9. XML and Web Services
- Introduction
- Defining a connection to XML within ODI
- How to do it...
- How it works...
- There's more...
- Processing complex files with ODI
- Getting ready
- How to do it...
- How it works...
- There's more...
- Processing XML data within an RDBMS not in memory
- How to do it...
- How it works...
- There's more...
- Invoking web services from ODI
- How to do it...
- How it works...
- There's more...
- Invoking asynchronous ODI web services with callbacks
- How to do it...
- How it works...
- Configuring container-based authentication with ODI web services
- How to do it...
- How it works...
- 10. Advanced Coding Techniques Using the ODI SDK
- Introduction
- Creating the Master and Work repositories using the SDK
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating a project using the SDK
- Getting ready
- How to do it...
- How it works...
- There's more...
- Automating the import of artifacts using the SDK
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating models and datastores using the SDK
- Getting ready
- How to do it...
- How it works...
- There is more
- Creating an interface using the SDK
- Getting ready
- How to do it...
- How it works...
- There's more...
- See Also
- Invoking and monitoring a scenario using the SDK
- Getting ready
- How to do it...
- How it works...
- There's more...
- 11. More on ODI
- Introduction
- Invoking an external program that requires a password
- Getting ready
- How to do it...
- How it works...
- There's more...
- Tuning a standalone ODI agent
- Getting ready
- How to do it...
- How it works...
- There's more...
- Loading a file containing a LOB
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using ODI versioning
- Getting ready
- How to do it...
- How it works...
- There's more...
- Performing a Smart Export/Smart Import
- Getting ready
- How to do it...
- How it works...
- There's more...
- Accessing an Excel spreadsheet
- Getting ready
- How to do it...
- How it works...
- There's more...
- Impacting the data flow by changing the staging area location
- Getting ready
- How to do it...
- How it works...
- There's more...
- Automating Smart Export/Smart Import with the ODI SDK
- How to do it...
- How it works...
- There's more...
- Index
- Title: Oracle Data Integrator 11g Cookbook. 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
- Author: Christophe Dupupet, Peter Boyd-Bowman, Julien Testut, Denis Gray
- Original title: Oracle Data Integrator 11g Cookbook. 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
- ISBN: 9781849681759, 9781849681759
- Date of issue: 2013-05-15
- Format: Ebook
- Item ID: e_3b45
- Publisher: Packt Publishing