Tuesday Oct 22, 2013

ODI 12c - Getting up and running fast

Here's a quick A-B-C to show you how to quickly get up and running with ODI 12c, from getting the software to creating a repository via wizard or the command line, then installing an agent for running load plans and the like.

A. Get the software from OTN and install studio. Check out this viewlet here for quickly doing this.

B. Create a repository using the RCU, check out this viewlet here which uses the FMW Repository Creation Utility. 

You can also silently create (and drop) a repository using the command line, this is really easy.

  • .\rcu -silent -createRepository -connectString yourhost:1521:orcl.st-users.us.oracle.com -dbUser sys -dbRole sysdba -useSamePasswordForAllSchemaUsers true -schemaPrefix X -component ODI -component IAU  -component IAU_APPEND  -component IAU_VIEWER -component OPSS < passwords.txt

where the passwords file contains info such as;

  • sysdba_passwd
  • newschema_passwd
  • odi_user_passwd
  • D
  • workreposname
  • workrepos_passwd

 You can find details about the silent use of RCU here in the FMW documentation.

C. Quickly create an agent for executing load plans and the like -  there is a great OBE for this, check it out here. If you are on your laptop and just wanting as minimal an agent as possible then this link is a must.

With these three steps you are ready to get to the fun stuff! Check out more OBEs here - keep on the lookout for more!

Monday Aug 20, 2012

Book Review Getting Started with Oracle Data Integrator 11g

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. If you interested in this book, you can get further info from Packt Publishing  here plus see Julien's earlier blog post here on discounts.


Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality


« April 2014