EUR 49,57
  • Tous les prix incluent la TVA.
En stock.
Expédié et vendu par Amazon. Emballage cadeau disponible.
Quantité :1
Getting Started with Orac... a été ajouté à votre Panier
Vous l'avez déjà ?
Repliez vers l'arrière Repliez vers l'avant
Ecoutez Lecture en cours... Interrompu   Vous écoutez un extrait de l'édition audio Audible
En savoir plus
Voir les 2 images

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial (Anglais) Broché – 25 mai 2012

Voir les formats et éditions Masquer les autres formats et éditions
Prix Amazon
Neuf à partir de Occasion à partir de
Format Kindle
"Veuillez réessayer"
"Veuillez réessayer"
EUR 49,57
EUR 49,57 EUR 52,10
--Ce texte fait référence à une édition épuisée ou non disponible de ce titre.

Offres spéciales et liens associés

Descriptions du produit

Présentation de l'éditeur

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. --Ce texte fait référence à une édition épuisée ou non disponible de ce titre.

Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.

  • Apple
  • Android
  • Windows Phone
  • Android

Pour obtenir l'appli gratuite, saisissez votre adresse e-mail ou numéro de téléphone mobile.

Détails sur le produit

En savoir plus sur l'auteur

Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.

Dans ce livre

(En savoir plus)
Parcourir et rechercher une autre édition de ce livre.
Parcourir les pages échantillon
Couverture | Copyright | Table des matières | Extrait | Quatrième de couverture
Rechercher dans ce livre:

Commentaires en ligne

Il n'y a pas encore de commentaires clients sur
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoiles

Commentaires client les plus utiles sur (beta) HASH(0x902c69a8) étoiles sur 5 12 commentaires
8 internautes sur 8 ont trouvé ce commentaire utile 
HASH(0x906d772c) étoiles sur 5 Practical, easy-to-digest hands-on tutorial is a winner! 25 juillet 2012
Par GJJ - Publié sur
Format: Broché
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 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
2 internautes sur 2 ont trouvé ce commentaire utile 
HASH(0x9145c7d4) étoiles sur 5 A great introduction book to Oracle Data Integrator 20 août 2012
Par S. Guan - Publié sur
Format: Broché
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 processing

Using 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 maintained

For 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.
1 internautes sur 1 ont trouvé ce commentaire utile 
HASH(0x902ba7a4) étoiles sur 5 Well Written Intro to Oracle Data Integrator 30 août 2012
Par Bob Griesemer - Publié sur
Format: Broché
The authors have written an excellent introduction to the Oracle Data Integrator (ODI). The list of authors reads like a who's who of Oracle folks who are key people on the Oracle Data Integator team and who have worked with it extensively. A couple of them were even with Sunopsis, the company who developed ODI and came over to Oracle when Oracle purchased Sunopsis to gain ownership of the ODI product. So if you're concerned about the qualifications of the authors for your technical books, you needn't be about this group.

It shows in the quality of the information presented in the book. For an intro book they've done a great job including everything you need to know to get started. They've started with an overview of the product, describing the repositories, the Studio, the Agent, the Console and a brief mention of integrating with Enterprise Manager.

The first chapter covers some key concepts like Execution Contexts which are ODI's way to separate the design from the actual parameters used to define where to execute it all. They cover Knowledge Modules which are templates of code for defining your Extract, Transform and Load processes and can be a little confusing to someone first using the product but they provide a great overview to help you understand it.

Chapter 2 covers the installation and they walk you through it step by step complete with screen shots to help you along the way.

Chapter 3 is an entire chapter devoted to the topic of Variables in ODI and at first seemed a bit out of place but upon reading you realize that it's pretty much a stand-alone chapter as they've stated and by putting it up front, gives you the chance to be exposed to the topic for when the use of variables is covered later.

Chapter 4 begins the real meat of starting to use ODI, covering sources targets and knowledge modules. They walk you through the Topology Navigator features for defining your physical data servers, physical schemas and logical schemas. You'll reverse engineer some meta-data into the tool and cover interface flows by looking at some actual examples. The all important topic of Knowledge Modules is covered also, explaining in more detail what they are and the importing of them.

Chapter 5 covers working with databases in general talking about some scenarios and then provides a hands on exercise to work through which puts into practice what we just read about in the previous chapter.

Chapters 6 through 9 then go into more detail about ODI in the context of integrating with four other technologies, a MySQL database in chapter 6, an MS SQL Server database in chapter 7, a flat file in Chapter 8 and an XML file in chapter 9, giving scenarios and some step by step instructions along the way. They have chosen this common set of platforms to illustrate ODI's capabilities in connecting to many different 3rd part databases and technologies and the topics can be adapted to whatever technology you are using. If you're an Oracle only shop, you'll have to adapt the the MySQL database and MS SQL Server database discussion for Oracle but it's understandable they'd cover these non-Oracle databases given ODI's multi-platform support. They've done a good job weaving together those other technologies while covering ODI concepts.

Chapter 10 is on workflows and how to package up your interfaces.

Chapter 11 is on Error management which is very valuable for any tool like this and the authors have devoted a whole chapter to it.

Chapter 12 is on managing and monitoring the ODI components and then some closing remarks in Chapter 13.

Overall a great introduction to the product. There is a lot of information in this book and the authors have managed to weave it together into a comprehensive whole while covering the interface with other technologies. The writing is in a very relaxed style that is easy to understand with many explanations and tips along the way. If you are new to ODI, this is the book you need.
1 internautes sur 1 ont trouvé ce commentaire utile 
HASH(0x902baa50) étoiles sur 5 Great introduction for rapid learning 21 août 2012
Par David - Publié sur
Format: Broché
The Getting Started with Oracle Data Integrator 11g: A hands On Tutorial book is a good introduction to ODI with some common examples that will be useful to many. It illustrates how data can be imported from various sources, transformed and exported to various sources with ODI. Following the step by step guide of the examples and you will have the right knowledge at the end of the book to create your own data integration solutions. The book is easy to read for novices and offers a great introduction to the world of ODI with useful tips from the authors - and there are a few of them ;-)

This book is an ideal book for somebody who wants to learn quickly about ODI, it's not a reference manual but a good introduction. It is filled with an abundance of useful info, I even discovered new information myself! Such as the Column Setup Wizard when importing flat file data. The chapter on Working with XML Files is also a useful one for anyone working in that area clearly spelling out with an example how it works.

The first and second chapters are all about the product overview and installation. Chapter 3 introduces variables which is a useful reference since it details now only how variables are defined but also where they can be used - this is a much asked question which I have seen many ask for mailing lists and forums. So good to see it included here. The fourth chapter introduces the design objects including topology, models and interfaces. There are useful notes scattered throughout the book which are worth checking out - these are little insights into useful hints on using the tool, personally these are my favorite items in the book. Chapters five, six and seven have illustrations of working with databases including Oracle, MySQL and Microsoft SQL Server covering various areas along the way from building interfaces using ODI's declarative designer, designing lookups, writing transformation expressions and KM selection. Chapters eight and nine are all about files and XML files and as I mentioned even surprised me with a few little pieces of info. Chapter 10 covers the workflow oriented objects including load plans, packages and procedures - a lot for a single chapter but an ok introduction. These 3 could easily be expanded into much, much more information. Chapter 11 covers errors in general - nice to see this too, this gives some insight of how the error handling in ODI works, and where to go to check up on errors. Finally there is an introduction to the ODI management components including the integration with Oracle's Enterprise Manager and the ODI console itself. There are some topics covered quickly such as procedures and I couldn't find any information on user functions, but on the whole it's a good start.

All in all, this book is in excellent read for somebody who wants to have a quick start in ODI. Its a useful book to dive into each chapter and have a read up on topics you don;t have to read end to end - my favorite type. Its an introduction, not a cookbook, the cookbook would be another useful companion book for ODI! This book is ideal for somebody who wants to get up and running in a short amount of time.
HASH(0x902babf4) étoiles sur 5 good mention of MySql 14 juillet 2012
Par W Boudville - Publié sur
Format: Broché
One thing you have to wrap your mind around is that key portions of the book are about metadata. Where you have source and target silos and a separate silo that holds the ODI (Oracle Database Integrator). The book explains how to use the ODI to generate transformations between the source and target. The power lies in the flexibility of the transformations that you can write via the ODI GUI. Considerable effort has been expended by Oracle in making a simple and yet flexible GUI for this ends.

XML is quoted extensively as a good use case. Basically, the source silo contains data in XML format, that uses some given schema. But you need to map this into another schema in the target silo. Crucially, the fact that the input data is already structured according to some logic makes it much easier to write a programmatic transformation.

ODI also has some ability to reverse engineer the extraction of data from a flat file. ODI comes with what Oracle calls wizards, that have knowledge of typical low level formatting structures in a flat file. Like whether the file has column or delimiter boundaries.

Interestingly, though the book is primarily about ODI that uses 11g, there are numerous examples involving MySql. This is freeware that is owned by Oracle. Naturally Oracle would prefer you to pony up to their expensive 11g. So I was somewhat surprised to see those mentions of MySql. The authors are clearly acknowledging the market reality that many users will indeed have source silos stored in MySql. Taking this further, the text also says commendably that "MySql is equally suitable as a target or for use as a staging area". Very good.

There are the occasional jarring phrases, like the oxymoronic "some ETL tools all have the ability". Do your best to ignore those if you can.
Ces commentaires ont-ils été utiles ? Dites-le-nous

Rechercher des articles similaires par rubrique


Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?