How to Login ODI

Before Login ODI through VNC, we need to do some pre-work in Linux.

Go to

/scratch/aime1/work/mw3758/Oracle_BI1/common/bin/

Execute the command

./wlst.sh /scratch/aime1/work/mw3758/Oracle_BI1/bifoundation/install/createJPSArtifactsODI.py embedded --ADMIN_USER_NAME Administrator --DOMAIN_HOSTNAME slc03qdi.us.oracle.com --DOMAIN_PORT 7001 --DOMAIN_HOME_PATH /scratch/aime1/work/mw3758/user_projects/domains/bifoundation_domain Administrator/Admin123

Go to

/scratch/aime1/work/mw3758/user_projects/domains/bifoundation_domain/odi-client-config/embedded/

Copy cwallet.sso and jps-config-jse.xml to target address

cp cwallet.sso jps-config-jse.xml /scratch/aime1/work/mw3758/odi8032/oracledi/client/odi/bin/

Go to

/scratch/aime1/work/mw3758/odi8032/oracledi/client/odi/bin/

Edit odi.conf ( AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml )

vi odi.conf

After I finished this work, I need to open VNC to login ODI.

Go to

/scratch/aime1/work/mw3758/odi8032/oracledi/client/

Execute the command to start ODI client

./odi.sh

In the opened window, click File then New to create a new ODI repository. The following is information of connection.

Login Name: DEAFAULT_LOGIN

User: Administrator1

Password: *********

Database Connection (Master Repository)

User: FA_BIA_ODIREPO

Password: *********

Driver User: Oracle JDBC Driver

Driver Name: oracle.jdbc.OracleDriver

Url: jdbc:oracle:thin:@slc03qdi.us.oracle.com:12915:db4142

Select 'Work Repository' and click the 'Search' button. There will be the default repository 'BIAPPS_WORKREP'. Then Click OK.