Post Installation Steps
How to set Business Analytics Warehouse Connection in Oracle Data Integrator.When you open the the Oracle Studio, click on ‘Connect to Repository’. It will show as
Click on Edit, will show by default following screen:
Change the connection details as per your ODI Schemas created using OBI Apps 11.1.1.8.1 RCU.
Note : jdbc:oracle:thin:@//localhost:1521/ORCLDB
Modify as below.
NOTE: The User in ‘Oracle Data Integrator Connection’, should be the same as while installing BIAPPS RCU – there was step – ‘BI Applications Administrator Username’. Same username should be provided.
In My case, its ‘BIAPPS’.
Possible Errors:
If the same Administrator username is not provided then, may face error : WORKREP not found.
While editing the following line in the file “ODI.CONF”. Please verify is the line correct, may be 2 equal signs, spelling mistakes. May cause
AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml
Click on the Search Icon of - WORK REPOSITORY, Following pop up window will show with the name of ‘BIAPPS_WORKREP’
Final Connection to ODI repository should be as follows :
In the navigation pane, go to Topology, and expand Technologies, and then expand File.
Double-click BIAPPS_DW_FILE.
In the Definition pane, for the Directory (Schema) and Directory (Work Schema) properties, specify the directory where you copied source files ; to a location that ODI Agent deployed in WebLogic Server can access but that is outside of the Oracle Home directory. otherwise, when the Oracle BI Applications environment is upgraded or patched, these files will be overwritten.
Example : <source file home>/biapps/etl/data_files/src_files/BIA_11
Registering Source Systems and Propagating Connection Details to Oracle Data Integrator
Launch Oracle BI Applications Configuration Manager using the URL
http://localhost:9704/biacm
Login with BI Application Administrator User, created by BIAPPS RCU.
No comments:
Post a Comment