Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial (Anglais) Broché – 25 mai 2012
|Neuf à partir de||Occasion à partir de|
Descriptions du produit
Présentation de l'éditeur
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.
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
Dans ce livre(En savoir plus)
Parcourir et rechercher une autre édition de ce livre.
Commentaires en ligne
Commentaires client les plus utiles sur Amazon.com (beta)
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
At conceptual level, it has discussed how ODI can deal with heterogeneous datatypes with ease and efficiency. For example, it introduces the concepts of:
* 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.
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.
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.
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.