Oracle Data Integrator 12cR2 (12.2.1.3.0). For All Platforms (including x64): Disk 1, Disk 2 Oracle Management Pack for Oracle Data Integrator 12c Includes: Plug-in for Oracle Enterprise Manager 12c (included in Oracle Enterprise Manager Base Platform download) for All Platforms. Data Integration Tips: ODI 12c Repository Query - Find the Mapping Target Table 15 February 2016 on Technical., odi12c, data integration tips, DITips, repository, odi11g. Well, it’s been awhile since I’ve posted one of our Rittman Mead Data Integration Tips, so I thought a recent challenge might be the next great candidate.
Hi….
A small but very helpful tip!
Initially when I was scrolling the documentation there were two location where we would need to place the Drivers one in <WINDOWS_USER_HOME>AppDataRoamingodioraclediuserlib
and the other will be the <ODI_HOME>/agent/oracledi/drivers Folder.
It confused me why two places and this is not feasible architecture , then I turned my attention towards the Global Architecture of Server and Client . So if my ODI Server is located on a UNIX server then I would be placing all my drivers under the agent/oracledi/drivers folder,since Agent will be located on my Server . While my Windows Client machine would be using the AppDataRoamingodioraclediuserlib folder for drivers ,as I would be using the Local Agent for reversing and if I in case I need to use respective RKM automatically Server Agent can be used to connect.
Moreover when we install the ODI Studio namely the ODI client the user wont have the agent folder and so they would have no confusion and would have to use AppDataRoamingodioraclediuserlib for drivers .
See you in the next post!
ODI 12 C Installation Steps
ODI 12 C Installation Steps:
Hello ODI Lovers!!. Its time to install ODI 12 C version. Since Oracle announced Oracle Data Integrator 12c, I was really struggling to get some free time to evaluate the newest version. I would say its another milestone for Oracle. This time you will find lot of changes ( new features ) in the UI and some what contains similarity with OWB. The complete installation took around 45 minutes for me as because I had to struggle around to resolve jdk path issue during start up. Please try it in your Dev environment and let me know if you have any issues.
Download Link
Oracle Data Integrator 12cR1 (12.1.2.0.0)
for All Platforms (including x64)
Extract the zip file. You will see two file (odi_121200.jar, odi_1212_opatch.zip) under ofm_odi_generic_12.1.2.0.0_disk1_1of1.
Go to command prompt and use below command to start the installer.
Since I was in hurry to see the UI, I installed it in my existing Weblogic Home which is of 11g version.
You can mark one thing that the ODI Studio 12.1.2.0.0 feature is coming only in Enterprise Edition not in Standalone Edition.
Congratulation!! You have successfully installed ODI 12c. Now go to the location D:OracleMiddlewareOracle_Homeodistudio and click on odi.exe. On the 1st time it will ask you to provide the jdk location. After providing the jdk path you might see below error.
Well this is somewhat outside my realm of knowledge. Not sure why it is reading jvm.dll. This was not happening in the older version of ODI. After some research on Google, I found the solution. In simple go to D:OracleMiddlewareOracle_Homeodistudiobin and modify the odi.conf. On the 4th line you will find
AddVMOption -XX:MaxPermSize=256M. Just modify this to
AddVMOption -XX:MaxPermSize=128M
AddVMOption -XX:MaxPermSize=128M
Make sure you have the correct jdk home (last line) in the same file. In my case it is
SetJavaHome C:program1Javajdk1.7.0_40
Thats all. Double click on odi.exe.
SetJavaHome C:program1Javajdk1.7.0_40
Thats all. Double click on odi.exe.
There it is !! . The 1st change I can see right from here.
Yes, I want to import preference from previous installation.
Wondering after looking into the home screen ??? Well this is just the beginning. When you will create new mappings ( formerly called as interface) you will find lots of changes. Anyway lets proceed further.
This something new introduced in 12c. Well no one wants to compromise in terms of security. So lets create the wallet password.
I can see my old preference available in the drop down list.
Hmmm..You know what you have to do now. See you in my next post where we will discuss more about repository upgradation.
Thanks for reading.
Bhabani
0