Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial

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.

eBook
$9.99 $39.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Table of content icon View table of contents Preview book icon Preview Book

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

Chapter 2. Product Installation

This chapter provides instructions for installing and configuring the Oracle Data Integrator product for a development or production environment. After reviewing the prerequisites for the product installation, we will cover the installation and configuration of the ODI repository, the Studio (graphical interface), and the Standalone Agent.

As a point of reference, Oracle maintains a list of prerequisites and step by step installation instructions at http://www.oracle.com/technetwork/middleware/data-integrator/documentation/index.html.

Prerequisites


Before installing the product, we have to make sure that all components are available and that the systems where the product will be installed conform to the product requirements. Download the required components as follows:

  • The components need to be downloaded from the ODI OTN web page at http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html. For the purpose of this book, we will assume that the installation is done on a Windows operating system. Download the ODI installation file.

  • Download the Repository Creation Utility (RCU) tool that will be needed to create the ODI repositories. RCU can be downloaded from the ODI download page on OTN.

Make sure to download the latest release of both products. Note that the ODI file is quite large (close to 2 GB). Depending on the quality of your bandwidth, the download could take quite a while and should be scheduled accordingly.

Prerequisites for the repository

To install the repository, you must have access to...

Installing ODI 11g


In this section we will view step-by-step instructions for installing ODI.

Two installation modes

Since the installation involves several components, there are two distinct installation modes for the repositories. They are as follows:

  • Oracle Repository Creation Utility (RCU) installation: Oracle provides a dedicated program that assists with the creation of repositories. This tool will create repositories for any Oracle tool that requires such an infrastructure, including ODI. This tool makes installation extremely simple, but will necessarily be less flexible than a repository created directly from the ODI Studio.

  • Creation from the ODI Studio: The installation program will only install the graphical interface and the Agent. The repositories can be created from the Studio graphical interface after it has been properly installed. The Agent will have to be manually configured to connect to the repository in this case. This installation mode may be required when additional...

Post installation—parameter files review


The following files are worth looking at:

  • For the Studio, you will find under Documents and Settings\<your login name>\Application Data\odi\oracledi\ all the configuration files that contain your login preferences and Studio preferences. If you need to add JDBC drivers for the Studio, you will need to store them into the userlib subdirectory.

  • For the Agent, under the agent \bin directory, you will find the odiparams.bat file (the same odiparams.sh will exist on Unix) that defines all the connection parameters for the Agent to connect to the repository. For instance, C:\Oracle\product\11.1.1.5\ODI\oracledi\agent\bin. The installation program has also created an agent_<your_agent_name>.bat file to start the Agent you have defined with the appropriate parameters.

Summary


In this chapter, we have reviewed the environment required for the ODI installation as well as the different steps required to install ODI. If you follow these steps with your installation, ODI will be installed and up and running with properly configured Master and Work repositories.

In the next chapter, we will introduce the notion of variables, how to define them, and how and where to use them. Then we will be ready to go into the actual use of the product.

Left arrow icon Right arrow icon

Key benefits

  • Discover the comprehensive and sophisticated orchestration of data integration tasks made possible with ODI, including monitoring and error-management
  • Get to grips with the product architecture and building data integration processes with technologies including Oracle, Microsoft SQL Server and XML files
  • A comprehensive tutorial packed with tips, images and best practices

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.

Who is this book for?

If you are a software/ETL developer or database administrator who is new to Oracle Data Integrator but want to get hands-on with the product quickly, then "Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" is for you. You should have some experience with databases, SQL and ETL technologies.

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

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : May 25, 2012
Length: 384 pages
Edition : 1st
Language : English
ISBN-13 : 9781849680691
Category :
Concepts :

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : May 25, 2012
Length: 384 pages
Edition : 1st
Language : English
ISBN-13 : 9781849680691
Category :
Concepts :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 192.97
Oracle Advanced PL/SQL Developer Professional Guide
$65.99
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
$65.99
Oracle Data Integrator 11g Cookbook
$60.99
Total $ 192.97 Stars icon
Banner background image

Table of Contents

13 Chapters
Product Overview Chevron down icon Chevron up icon
Product Installation Chevron down icon Chevron up icon
Using Variables Chevron down icon Chevron up icon
ODI Sources, Targets, and Knowledge Modules Chevron down icon Chevron up icon
Working with Databases Chevron down icon Chevron up icon
Working with MySQL Chevron down icon Chevron up icon
Working with Microsoft SQL Server Chevron down icon Chevron up icon
Integrating File Data Chevron down icon Chevron up icon
Working with XML Files Chevron down icon Chevron up icon
Creating Workflows—Packages and Load Plans Chevron down icon Chevron up icon
Error Management Chevron down icon Chevron up icon
Managing and Monitoring ODI Components Chevron down icon Chevron up icon
Concluding Remarks Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.1
(15 Ratings)
5 star 53.3%
4 star 26.7%
3 star 0%
2 star 13.3%
1 star 6.7%
Filter icon Filter
Top Reviews

Filter reviews by




GJJ Jul 25, 2012
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Oracle Data Integrator is Oracle Corporation's premier software product for integrating data across an organization's lines of business. It addresses the need to move data among transaction processing systems, data warehousing implementations, business intelligence tools, master data management, so-called "big data," and the like. It is fully integrated with the Service Oriented Architecture (SOA) and Enterprise Data Quality.As an instructor and consultant for the better part of my 40+ year professional career, I have always sought to share with my students value-added collateral that reinforces the lessons I teach them in the classroom (either through traditional or live virtual class settings). I've shared white papers, links to documentation both inside and outside of vendors' mind space and the results of personal research via email threads and blogs. I eagerly anticipate that someone will create a well-written primer that's driven by the needs of a critical mass of product users.Such is the case with the new book, Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial. The authors of this practical, easy to digest, 384 page paperback (available also as an e-book) are directly involved with the development and support of the product known by its users simply as "ODI." They ostensibly avoided creating just another rehash of vendor documentation, opting instead to "accelerate your learning of ODI 11g" through hands-on lessons.As they mention in the first few pages, they hope to "highlight the key capabilities of the product in relation to data integration tasks (loading, enrichment, quality, and transformation" by exposing the key productivity features inherent in a code generator that automates the implementation of much of the required logistics traditionally hand-coded in conventional ETL (Extract-Transform-Load) processes.They illustrate sample use cases that transcend the mundane, offering examples that exploit a varied set of relational database tables, text files and XML (Extensible Markup Language) data. In keeping with their tutorial focus, they maintain an educational perspective, demonstrating how the features and functions of the tool are used in real-world situations. Their "number one goal is to get you familiar, comfortable, and successful" using the product. In my professional opinion, I believe that the entire book is faithful to their objectives.With chapters that cover every critical topic from a brief but effective review of ODI terminology, architecture and concepts, through product installation, application development and administration, the authors provide a comprehensive look at the tool without bogging the reader down in minutia. They cover the use of database technologies like MySQL, Oracle database and Microsoft SQL Server. Best of all, the entire book has an enthusiastic tone. As they say, "If it is not obvious by the time you finish reading this book, we <really like> ODI 11gR1" (the emphasis on "really like" is theirs).I, too, am a zealous devotee of ODI. I have worked with the product ever since Oracle Corporation acquired the French company known as Sunopsis a half-decade ago. Several of the authors were among those who developed and marketed what has evolved into Oracle Data Integrator 11g. I've taught well over 1,000 people how to be successful with ODI in those intervening years. I welcome this new book as an essential title in the library of every student I teach going forward. I will heartily recommend it to everyone "interested in, or responsible for, the content, freshness, movement, access to, or integration with data."One final comment: I pride myself on being well-versed in ODI. I kept track of all the techniques and observations about this software that I may not have fully exploited, despite my experience. When I was finished reading the book, I had compiled a list of about a dozen features that were interpreted in significantly better ways than I've traditionally explained them! My hat's off to the team who wrote this excellent book!(This book is available via www.amazon.com or directly from the publisher, Packt Publishing)Paperback Edition: Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial Kindle Edition: Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
Amazon Verified review Amazon
Anonymous Reviewer Sep 29, 2015
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Great book and exactly what I needed! Good condition as well!
Amazon Verified review Amazon
Tim's Choice Jan 28, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book is written as if you were going to implement the ODI application in a step by step process.
Amazon Verified review Amazon
Umer Malik Jan 11, 2016
Full star icon Full star icon Full star icon Full star icon Full star icon 5
awesome
Amazon Verified review Amazon
Stanley Aug 20, 2012
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book has done a great job of introducing ODI at both conceptual and operational levels. It covers how ODI leverages next generation Extract-Load-Transformation technology to deliver extreme performance in enabling state of the art solutions that help deliver rich analytics and superior business intelligence in modern data warehousing environments.At conceptual level, it has discussed how ODI can deal with heterogeneous datatypes with ease and efficiency. For example, it introduces the concepts of:* Abstraction* Decoupling* Declarative Design* Delegating and distributing processingUsing these design patterns, ODI allows:* Integration strategies be reused* Heterogeneity of data server types be encapsulated via models and other integration objects* Life management of development, test, or production environments be easily maintainedFor operational details, the largest part of the book is a set of hands-on step-by-step tutorials that build a non-trivial Order Processing solution that you can run, test, monitor, and manage. It has highlighted the key capabilities of the product in relation to data integration tasks (loading, enrichment, quality, and transformation) and the productivity achieved by being able to do so much work with heterogeneous datatypes while writing so little SQL.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.