Home Page Icon
Home Page
Table of Contents for
Dedication
Close
Dedication
by Chris Lawless, Bob Curtis, Michelle Malcher
Oracle Data Integration: Tools for Harnessing Data
Cover
Title Page
Copyright Page
Dedication
Contents at a Glance
Contents
Acknowledgments
Introduction
1 Data Integrations Overview
What Is a Data Integration?
History of Data Integration
Integrations Today
Decision Flow Chart
Tools for Harnessing Data
Summary
2 Moving Data Around the Oracle Environment
Structured Query Language
SELECT
Data Manipulation Language
Data Definition Language
Data Control Language
SQL Summary
PL/SQL
Functions
Procedures
Packages
Triggers
The COPY Command
SPOOL
SQL*Loader
Control File
Dealing with the Bad File
Invoking SQL*Loader
External Tables
Summary
3 Moving/Using Data
Database Links
Gateways
Materialized Views
Export/Import
Invoking Export from the Command Line
Invoking Export Interactively from the Command Line
Invoking Export via Parameter Files
Data Pump
Transportable Tablespaces
Pluggable Databases and Transport Databases
Logminer
Advanced Replication
Oracle Streams
Oracle GoldenGate
XStream API
XStream Out
XStream In
Summary
4 Oracle Replication (GoldenGate)
Oracle GoldenGate Use-Cases
Unidirectional Use-Case
Consolidation Use-Case
Data Distribution Use-Case
Near-Zero-Downtime Migration
Oracle GoldenGate Architecture
Capture (Extract) Process
Data Pump (Extract) Process
Apply (Replicat) Process
Trail File
Transforming Data on the Fly with Oracle GoldenGate
Configure DEFGEN
Running DEFGEN
Using Oracle GoldenGate to Create Flat Files
Types of Flat Files
Generating Flat Files
Generating an ASCII-Formatted File
Using Oracle GoldenGate to Create Native Database Loader Files
Extracting for Database Utility Usage
Oracle GoldenGate User Exit Functions
Testing Data with Oracle GoldenGate
Changing Data Using @IF
Summary
5 Oracle Data Integrator
Architecture
Repositories
Users
Run-Time Agents
Oracle Data Integrator Console
Installation
Deploying the Binaries
Preparing the Repository
Verifying the Repository
Configuring the ODI Agent
Starting Oracle Data Integrator
Setting Connections
Initial Connection and Wallet Configuration
Configuring a Topology
Physical Architecture
Logical Architecture
Designing Models
Target Side
Mappings
Creating a Project
Running the Mappings
Simulation
Step-by-Step Execution
Validating That the Data Has Been Integrated
Summary
6 Common Challenges
Examining the Issues
Design for Integrations
Change
Business Purpose
Standardization
Data Problems
Synchronizing Data and Copies: Multiple Systems
Latency
Tool Issues
Managing Mapping Tables: Metadata
Testing
Performance
Summary
7 Data Cleansing
What Is Data Cleansing?
Master Data Management
Process
Standards
Governing Data Sources
Tools for Cleansing
Developing Other Tools
Summary
8 Big Data
Oracle Big Data Appliance
Cloudera
Oracle NoSQL
Oracle R Distribution
Oracle XQuery for Hadoop
Oracle Loader for Hadoop
Oracle SQL Connector for Hadoop
Oracle Big Data SQL
Hadoop
Hadoop Distributed File System
MapReduce
NoSQL
HBase
Big Data Connectors
Oracle Data Integrator and Big Data
Oracle GoldenGate and Big Data
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Copyright Page
Next
Next Chapter
Contents at a Glance
For my friends in the user community:
you inspire, encourage, and are just simply awesome!
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset