
Oracle Data Integration: Tools for Harnessing Data
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- 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
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.