OBIA 7.9.6.4 Installation

To download OBIA 7.9.6.4, log into oracle edelivery

https://edelivery.oracle.com

select the below option under Business Intelligence category

Oracle Business Intelligence 11g Media Pack for Microsoft Windows x64 (64-bit)

and download Oracle Business Intelligence Applications 7.9.6.4 for Microsoft Windows  -- V35873-01

Click on setup file and Run as Administrator

Click Next

 

 Select Oracle Home, Instance and domain locations from the OBIEE install folder.

 Enter weblogic user details.

Select components to install and click Next.

 

 

 Click Next

 

Installation process will restart the OBIEE services. This process might take time.

 Starting OPMN components.

 

OBIEE RPD, catalog, informatica repository and DAC code will be available in the biapps folder.

DAC 11G Installation and Configuration- Part1

Create Database User:-

For Sql Server:-
Create a DAC_USER  and add the below permissions to the user.

For Oracle:-
Create a user in the database and grant all privileges to the user.

 Select dac11g_install and Run As Administrator

 

Click Next

 

 Select the folder where Informatica is installed.

 

Select domains.infa file which is under Informatica folder.

 

Create a folder DAC11G and Select that folder to have the DAC installation files.

 

Select appropriate option.

 Select Install

 

Click Done

Click DAC Client to configure

 

Click on configure

Create Connection and Click Next.

 Enter details as shown above and for Authentication . choose create New authentication file.

Click OK

 

 Enter DAC_USER details, user created in the database and click OK

 

(For SQL Server Only) driver is available for Oracle, SQL Server driver has to be downloaded.

Download SQL SERVER driver Executable Jar File and copy jar file in to the lib directory of DAC(sqljdbc4.jar) and rename the file to sqljdbc.jar

 

Test Connection now.

 Create a new connection to log into DAC.

Click on Login

 

Click Yes

Enter DAC_USER details.

 Enter Administrator username and password.

Click on Tools-> DAC Server Management -> Repository Configuration . Change Mode to Standalone