God, its amazing how fast technology evolves, just as we were trying to get a hang of ODI 11g,
ODI 12c is here and the 'blogosphere' is busy writing whats new and 'cool' in this iteration.
Refer this link for a glance:
http://www.rittmanmead.com/2013/10/oracle-data-integrator-12c-release-part-1/
I had a shot at it myself and started installing, I'll be putting down my experience of working with this new version.
The Installation :
The installable can be downloaded from Oracle's website. Within the zip file is an html page which will tell you how to install. DO READ THE INSTRUCTIONS CAREFULLY !!
THIS BABY RUNS ONLY ON JDK 1.7 !!
To get the new studio, you have to install the ENTERPRISE INSTALLATION, standalone installation will not give you the studio of 12c.
Installation is pretty straightforward, this time it doesn't ask you to 'skip master repository connection' of an existing Repository or prompt for an agent name with port (which I think makes sense).
Thankfully there are no surprises at the time of installation.
Configuration:
The window looks like this, cool blue color is 'khool' \m/ (bad joke)
Configuring repositories is similar to 11g except that I got a warning while creating a new master repository.
I wonder what that is, I had given the necessary privileges (session, connect and resource) to the user, googling the error number wasn't fruitful, I guess I will have to dig deeper for that error, but for now it worked seamlessly. Master Repo creation worked without any error. Only one stupid warning which everyone having an engineering degree should be knowing already.
Then, this message, I need to learn about Wallet now, I chose not to store passwords in wallet.
After that, everything was just the same as far as configuring ODI users and repositories is concerned.
Can I connect an ODI11g repository to ODI 12c studio directly ??
NO, the error you will be getting is:
oracle.odi.core.config.MasterRepositoryVersionMismatchException: ODI-10179: Client requires a repository with version 05.01.01.16 but the repository version found is 04.03.04.02.
Fortunately there is an upgrade assistant for this one as well, I did not run that (had to keep older version functional) but found a link showing how it is done
http://docs.oracle.com/middleware/1212/odi/ODIUG/tasklist.htm
Some of them have already done it. Pretty straight forward.
http://dwteam.in/upgrading-odi-11-1-1-7-repository-to-12c/
NOTE : DO TAKE A BACKUP OF YOUR DATABASE SCHEMA BEFORE TRYING IT
Next topic will be covering creating basic interfaces. Will see if its a revolution or evolution ...
Cheers !!
ODI 12c is here and the 'blogosphere' is busy writing whats new and 'cool' in this iteration.
Refer this link for a glance:
http://www.rittmanmead.com/2013/10/oracle-data-integrator-12c-release-part-1/
I had a shot at it myself and started installing, I'll be putting down my experience of working with this new version.
The Installation :
The installable can be downloaded from Oracle's website. Within the zip file is an html page which will tell you how to install. DO READ THE INSTRUCTIONS CAREFULLY !!
THIS BABY RUNS ONLY ON JDK 1.7 !!
To get the new studio, you have to install the ENTERPRISE INSTALLATION, standalone installation will not give you the studio of 12c.
Installation is pretty straightforward, this time it doesn't ask you to 'skip master repository connection' of an existing Repository or prompt for an agent name with port (which I think makes sense).
Thankfully there are no surprises at the time of installation.
Configuration:
The window looks like this, cool blue color is 'khool' \m/ (bad joke)
I wonder what that is, I had given the necessary privileges (session, connect and resource) to the user, googling the error number wasn't fruitful, I guess I will have to dig deeper for that error, but for now it worked seamlessly. Master Repo creation worked without any error. Only one stupid warning which everyone having an engineering degree should be knowing already.
On pressing the connect button, I got this message, maybe because I already had ODI 11g on my machine.
I said NO and proceeded, NOTE: It does take the existing version's credentials automatically.
I said NO and proceeded, NOTE: It does take the existing version's credentials automatically.
Then, this message, I need to learn about Wallet now, I chose not to store passwords in wallet.
After that, everything was just the same as far as configuring ODI users and repositories is concerned.
Can I connect an ODI11g repository to ODI 12c studio directly ??
NO, the error you will be getting is:
oracle.odi.core.config.MasterRepositoryVersionMismatchException: ODI-10179: Client requires a repository with version 05.01.01.16 but the repository version found is 04.03.04.02.
Fortunately there is an upgrade assistant for this one as well, I did not run that (had to keep older version functional) but found a link showing how it is done
http://docs.oracle.com/middleware/1212/odi/ODIUG/tasklist.htm
Some of them have already done it. Pretty straight forward.
http://dwteam.in/upgrading-odi-11-1-1-7-repository-to-12c/
NOTE : DO TAKE A BACKUP OF YOUR DATABASE SCHEMA BEFORE TRYING IT
Next topic will be covering creating basic interfaces. Will see if its a revolution or evolution ...
Cheers !!
1 comment:
Hi,
You have provided Best information for ODI.it is very usefull to readers who want Data integration platform.Keen Technologies offers in-depth Online Training for Oracle Data Integrator(ODI) in module of Oracle. Our response is almost immediate and we offer you the freedom to cut down on your training costs and ramp-up your resources where needed in minimal time.
Post a Comment