11 Configuration of OBIA

Configuration of OBIA

1. Go to path C:\OBIEE_HOME\Oracle_BI1\bin → Double click on configapps

2. Click on NEXT

3. Click on NEXT

4. Provide password as RRitec123 → Click on NEXT

5. Observe all parameters → you can not modify any parameters → click on NEXT

6. Select BI Application Components → Click on NEXT

7. Provide RPD password as RRitec123 →  Click on NEXT

8. Provides username as biapps password as RRitec123
   

   

   Provide below details → Click on NEXT 

9. Provide below Details → Click on NEXT

10. Provide below Details → Click on NEXT

11. Provide below Details → Click on NEXT

12. Select Auto Port Configuration → Click on NEXT

13. Click on Continue

14. 

15. To synchronize the security between ODI Studio and the Weblogic server
16. Copy the files cwallet.sso and jps-config-jse.xml from C:\OBIEE_HOME\user_projects\domains\bifoundation_domain\odi-client-config\embedded to C:\OBIEE_HOME\Oracle_ODI1\oracledi\client\odi\bin
17. 
18. Now edit the file <ODI_Home>/oracledi/client/odi/bin/odi.conf
19. 
20. Locate the line AddVMOption -Doracle.security.jps.config=./jps-config.xml   
21. Modify as shown below

IncludeConfFile ../../ide/bin/ide.conf AddVMOption -XX:MaxPermSize=256M AddVMOption -Doracle.core.ojdl.logging.config.file=ODI-logging-config.xml AddVMOption -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger AddVMOption -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration AddJavaLibFile ../../../../oracledi.sdk/lib/ojdl.jar AddJavaLibFile ../../../../oracledi.sdk/lib/dms.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/log4j-1.2.8.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odi_hfm.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odihapp_common.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/ess_es_server.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/ess_japi.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odihapp_essbase.jar AddJavaLibFile ../../jdev/extensions/oracle.odi.navigator/lib/odihapp_planning.jar AddVMOption -Dnative.canonicalization=false AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml AddVMOption -Doracle.odi.studio.ess=false AddVMOption -Dide.AssertCheckingDisabled=true AddVMOption -Dide.AssertTracingDisabled=true AddVMOption -DLOG_FILE=studio.log AddVMOption -Dsun.java2d.noddraw=true SetJavaHome C:\OBIEE_HOME\Oracle_BI1\jdk

23. save → Close

Load Plan Generator Plug-in

24. The load plan generator plug-in for ODI is supplied in a zip file and it is used by BIACM
25. Copy and  paste  the file from the location C:\OBIEE_HOME\Oracle_BI1\clients\biappsclients\odi to C:\OBIEE_HOME\Oracle_ODI1\oracledi\client\ide\extensions

26. Unzip the file OBIA_LPG_PLUGIN
27. 
28. ll

Login to ODI

29. Make sure weblogic server is running
30. open ODI studio
31. click on connect to repository
32. click on new connection
33. provide below details
34. 
35. Click on OK
36. 
37. Again ok
38. In previous step we extracted load plan generator ZIP file because of that we got below plugin
39. 
40. Now we can see all predefined interfaces of SDE SIL and PLP
41. 
42. Copy Boot file from C:\OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\bi_server1\security to C:\OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\odi_server1\security
43. Enjoy :)