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

4.12 avg rating
( 8 ratings by GoodReads )
 
9781849680684: Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial

Combine high volume data movement, complex transformations and real-time data integration with the robust capabilities of ODI in this practical guide

  • 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 

 

In Detail

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.

What you will learn from this book

  • 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

Approach

"Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" is a practical tutorial bursting with tips, illustrations and real-world best practices to get you on your way with ODI.

Who this book is 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.

"synopsis" may belong to another edition of this title.

About the Author:

David Hecksel


David Hecksel is a Principal Data Integration Architect at Oracle. Residing in Dallas Texas, David joined Oracle in 2006 as a pre-sales Architect for Oracle Fusion Middleware. Six months after joining, David volunteered to add pre-sales coverage for a recently acquired product called Oracle Data Integrator and the rest (including the writing of this book) has been a labor of love working with a platform and solution that simultaneously provides phenomenal user productivity and system performance gains to the traditionally separate IT career realms of Data Warehousing, Service Oriented Architects, and Business Intelligence developers. Before joining Oracle, David spent six years with Sun Microsystems in their Sun Java Center, was CTO for 4 years at Axtive Software architecting and developing several one-to-one marketing and web personalization platforms such as e.Monogram. In 1997, David also invented, architected, developed, and marketed online the award-winning JCertify product - the industry's first electronic delivery of study content and exam simulation for the Certified Java Programmer exam. Prior to Axtive Software, David was with IBM for 12 years as a software developer working on operating system, storage management, and networking software products. David holds a BS Computer Science degree from the University of Wisconsin-Madison and a Masters of Business Administration from Duke University.


Bernard Wheeler


Bernard Wheeler is a Customer Solutions Director at Oracle in the UK, where he has a focus on Information Management. He has been at Oracle since 2005, working in pre-sales technical roles covering Business Process Management, SOA, and Data Integration technologies and solutions. Before joining Oracle, Bernard held various pre-sales, consulting, and marketing positions with vendors such as Sun Microsystems, Forte Software, Borland, and Sybase as well as working for a number of systems integrators. Bernard holds an Engineering degree from Cambridge University.


Peter C. Boyd-Bowman


Peter C. Boyd-Bowman is a Technical Manager and Consultant with the Oracle Corporation. He has over 30 years of software engineering and database management experience, including 12 years of focused interest in data warehousing and business intelligence. Capitalizing on his extensive background in Oracle database technologies dating back to 1985, he has spent recent years specializing in data migration. After many successful project implementations using Oracle Warehouse Builder and shortly after Oracle's acquisition of the Sunopsis Corporation, he switched his area of focus over to Oracle's flagship ETL product: Oracle Data Integrator. Peter holds a BS degree in Industrial Management and Computer Science from Purdue University and currently resides in North Carolina.


Julien Testut

Julien Testut is a Product Manager in the Oracle Data Integration group
focusing on Oracle Data Integrator. Julien has an extensive background
in Data Integration and Data Quality technologies and solutions.

Prior to joining Oracle, he was an Applications Engineer at Sunopsis
which was then acquired by Oracle. Julien holds a Masters Degree in
Software Engineering.


Denis Gray


Christophe Dupupet

Christophe Dupupet is a Director of Product Management for ODI at
Oracle. In this role, he focuses on the Customer Care program where he
works closely with strategic customers implementing ODI. Prior to
Oracle, Christophe was part of the team that started the operations for
Sunopsis in the US (Sunopsis created the ODI product and was acquired by
Oracle in 2006).Christophe holds an Operations Research degree from
EISTI in France, a Masters Degree in Operations Research from Florida
Tech and a Certificate in Management from Harvard University.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

D. Hecksel
ISBN 10: 184968068X ISBN 13: 9781849680684
New Quantity Available: 2
Seller
Books_Universe
(Sugarland, TX, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Brand New. US Edition Book. We do not ship to Military Addresses. Fast Shipping with Order Tracking. For Standard Shipping 7-8 business days & Expedite Shipping 4-6 business days, after shipping. Bookseller Inventory # 184968068X-RMX

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 53.92
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

David Hecksel, Bernard Wheeler, Peter C. Boyd-Bowman
Published by Packt Publishing Limited, United Kingdom (2012)
ISBN 10: 184968068X ISBN 13: 9781849680684
New Paperback Quantity Available: 10
Print on Demand
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description Packt Publishing Limited, United Kingdom, 2012. Paperback. Book Condition: New. 232 x 190 mm. Language: English . Brand New Book ***** Print on Demand *****. Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial is a practical tutorial bursting with tips, illustrations and real-world best practices to get you on your way with ODI. 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. Bookseller Inventory # AAV9781849680684

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 55.56
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

3.

David Hecksel, Bernard Wheeler, Peter C. Boyd-Bowman
Published by Packt Publishing Limited, United Kingdom (2012)
ISBN 10: 184968068X ISBN 13: 9781849680684
New Paperback Quantity Available: 10
Print on Demand
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Packt Publishing Limited, United Kingdom, 2012. Paperback. Book Condition: New. 232 x 190 mm. Language: English Brand New Book ***** Print on Demand *****.Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial is a practical tutorial bursting with tips, illustrations and real-world best practices to get you on your way with ODI. 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. Bookseller Inventory # AAV9781849680684

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 57.49
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

4.

Hecksel, David
Published by Packt Publishing (2016)
ISBN 10: 184968068X ISBN 13: 9781849680684
New Paperback Quantity Available: 1
Print on Demand
Seller
Ria Christie Collections
(Uxbridge, United Kingdom)
Rating
[?]

Book Description Packt Publishing, 2016. Paperback. Book Condition: New. PRINT ON DEMAND Book; New; Publication Year 2016; Not Signed; Fast Shipping from the UK. No. book. Bookseller Inventory # ria9781849680684_lsuk

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 58.71
Convert Currency

Add to Basket

Shipping: US$ 4.52
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

David Hecksel
Published by Packt Publishing Limited (2012)
ISBN 10: 184968068X ISBN 13: 9781849680684
New Quantity Available: > 20
Print on Demand
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Packt Publishing Limited, 2012. PAP. Book Condition: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # LQ-9781849680684

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 51.91
Convert Currency

Add to Basket

Shipping: US$ 11.65
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

David Hecksel
Published by Packt Publishing Limited (2012)
ISBN 10: 184968068X ISBN 13: 9781849680684
New Quantity Available: > 20
Print on Demand
Seller
PBShop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description Packt Publishing Limited, 2012. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # IQ-9781849680684

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 61.64
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

7.

D. Hecksel; B. Wheeler; Peter Boyd-Bowman; Julien Testut; Denis Gray; Christophe Dupupet
Published by Packt Publishing (2012)
ISBN 10: 184968068X ISBN 13: 9781849680684
New Paperback Quantity Available: 10
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Packt Publishing, 2012. Paperback. Book Condition: New. Bookseller Inventory # INGM9781849680684

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 64.50
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

8.

D. Hecksel; B. Wheeler; Peter Boyd-Bowman; Julien Testut; Denis Gray; Christophe Dupupet
Published by Packt Publishing (2012)
ISBN 10: 184968068X ISBN 13: 9781849680684
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Packt Publishing, 2012. Paperback. Book Condition: New. Bookseller Inventory # DADAX184968068X

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 72.56
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

9.

D. Hecksel; B. Wheeler; Peter Boyd-Bowman; Julien Testut; Denis Gray; Christophe Dupupet
Published by Packt Publishing (2012)
ISBN 10: 184968068X ISBN 13: 9781849680684
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description Packt Publishing, 2012. Paperback. Book Condition: New. book. Bookseller Inventory # 184968068X

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 78.23
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

10.

D. Hecksel
Published by Packt Publishing (2017)
ISBN 10: 184968068X ISBN 13: 9781849680684
New Paperback Quantity Available: 20
Print on Demand
Seller
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Packt Publishing, 2017. Paperback. Book Condition: New. This item is printed on demand. Bookseller Inventory # 184968068X

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 76.12
Convert Currency

Add to Basket

Shipping: US$ 2.99
Within U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book