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 platform through practical instructions and real-world situations rather than dry theory. Written by a team of seasoned experts.

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial

David Hecksel et al.

3 customer reviews
This is a brilliant crash course in Oracle Data Integrator that pulls you straight into the platform through practical instructions and real-world situations rather than dry theory. Written by a team of seasoned experts.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $35.99
Save 72%
Print + eBook
$59.99
RRP $59.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$59.99
$29.99 p/m after trial
RRP $35.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial Book Cover
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
$ 35.99
$ 10.00
Oracle Data Integrator 11g Cookbook Book Cover
Oracle Data Integrator 11g Cookbook
$ 32.99
$ 10.00
Buy 2 for $20.00
Save $48.98
Add to Cart

Book Details

ISBN 139781849680684
Paperback384 pages

Book Description

Oracle Data Integrator (ODI) is Oracle's strategic data integration platform for high-speed data transformation and movement between different systems. From high-volume, 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.

"Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" provides you with everything you to get up and running with Oracle Data Integrator, and more! Following an example scenario, the book covers essential information about the ODI architecture and using ODI across different databases (Oracle, Microsoft SQL Server and MySQL), and file types such as XML, before covering Orchestrating Data Integration Workflows, Error Management, Operational Management and Monitoring, and beyond.

"Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" begins by describing the Oracle Data Integrator architecture and teaching you to install the product following best practices. You’ll then be introduced to some of the key concepts of ODI such as the Knowledge Modules.

Later topics include moving and transforming data from sources to targets including the Oracle Database, Microsoft SQL Server, MySQL, Flat files, and XML files, each with illustrated hands-on examples for the different technologies. Your learning experience will be made all the more rich with chapters introducing, explaining and leveraging additional ODI functionality such as variables, reusable procedures, temporary indexes and more.

Finally ODI's workflow and task orchestration capabilities are explained before introducing you to Error Management with ODI's built-in 'error hospital' and 'error recycling' capabilities for non-compliant data, not to mention tackling ODI Studio, ODI Console and Enterprise Manager Fusion Middleware Control.

Table of Contents

Chapter 7: Working with Microsoft SQL Server
Chapter 10: Creating Workflows—Packages and Load Plans
Chapter 13: Concluding Remarks

What You Will Learn

  • Get to grips with the various components of the Oracle Data Integrator architecture
  • Learn how to install ODI quickly and effectively using recommended best practices
  • Orchestrate your data integration processing by designing ODI packages and scenarios 
  • Discover how to develop ODI interfaces in order to effortlessly move data between servers and files 
  • Get the full lowdown on both Error Processing and Management and Monitoring
  • Give your knowledge a boost with in-depth coverage of various data sources and targets including Oracle, Microsoft SQL Server and XML files
  • Master key ODI concepts like Physical and Logical Architectures or the Knowledge Modules
  • Take advantage of expert advice from the authors’ combined 15 years of ODI experience

Authors

Table of Contents

Chapter 7: Working with Microsoft SQL Server
Chapter 10: Creating Workflows—Packages and Load Plans
Chapter 13: Concluding Remarks

Book Details

ISBN 139781849680684
Paperback384 pages
Read More
From 3 reviews

Read More Reviews

Recommended for You

Oracle Data Integrator 11g Cookbook Book Cover
Oracle Data Integrator 11g Cookbook
$ 32.99
$ 10.00
Getting Started with Oracle Hyperion Planning 11 Book Cover
Getting Started with Oracle Hyperion Planning 11
$ 35.99
$ 10.00
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook Book Cover
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
$ 32.99
$ 10.00
Oracle E-Business Suite R12 Core Development and Extension Cookbook Book Cover
Oracle E-Business Suite R12 Core Development and Extension Cookbook
$ 35.99
$ 10.00
Oracle Essbase 11 Development Cookbook Book Cover
Oracle Essbase 11 Development Cookbook
$ 35.99
$ 10.00
Oracle Application Integration Architecture (AIA) Foundation Pack 11gR1: Essentials Book Cover
Oracle Application Integration Architecture (AIA) Foundation Pack 11gR1: Essentials
$ 38.99
$ 10.00