Friday, May 27, 2016

ODI 12C

Hi All, 

It was good experience to learn new technology, if your working on OBIEE, You should know ODI or Informatica. because most of companies are using ODI and informatica for data warehouse design.Below are few ODI 12c tutorial which help you. 

ODI 12c : Installation and setup of Oracle Data Integrator (ODI) 12c on Windows with Weblogic
ODI 12c : File to Table
ODI 12 : Integrating with Big Data
ODI 12c : Install and Configure Oracle Data Integrator 12c on Non-GUI Platforms
ODI 12c : Creating and Connecting to ODI Master and Work Repositories
ODI 12c : Creating Procedures and Scenarios
ODI 12c : Creating a Collocated Agent
ODI 12c : Creating a Standalone Agent
ODI 12C : New Features of Version 12.1.3

Thanks
Rakesh Patil
rakeshpatil002@gmail.com

Friday, May 13, 2016

OBIEE 12c File Path, URL and Server Details

As per the file location OBIEE 12c completely diffrenect from OBIEE11g
Here the file location

Installation of OBIEE and Weblogic under:
“C:\Rakesh\Oracle\Middleware\Oracle_Home”  Here  Oracle_Home is the installation Directory.

DOMAIN_HOME [In 11g BI_Domain]: 
C:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi

CATALOG: C:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bidata\service_instances\ssi\metadata\content\catalog

RPD: C:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bidata\service_instances\ssi\metadata\datamodel\customizations

BI ADMINISTATORT TOOLC:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\OBIEE12\bitools\bin\admintoo.CMD

BI SERVER START AND STOPC:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\OBIEE12\bitools\bin

INSTANCECONFIG [instaceconfig.xml]:C:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\config\fmwconfig\biconfig\OBIPS

NQSCONF.INIC:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\config\fmwconfig\biconfig\OBIS

LOG FILE:
C:\Rakesh\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\servers\obips1\logs

OBIEE 12c URL : As per my installation below are the URL.
Note: Rakesh-PC is my computer name, you have to change based on your pc name.
WebLogic Console : http://Rakesh-PC:9500/console
Fusion Middleware Control : http://Rakesh-PC:9500/em
BI Publisher : http://Rakesh-PC:9502/xmlpserver
BI Analytics : http://Rakesh-PC:9502/analytics

Thanks and Regards
RP
-rakeshpatil002@gmail.com

Tuesday, May 3, 2016

OBIEE 12c Installation

Hello All,

Sorry, Could not find time to update OBIEE blog. Today I will explain how to installed OBIEE 12c on Windows 7. Yes-day i did installation on my PC[Windows 7]

Before installation download below software from oracle website.
JDK -8
Oracle DB 12c
Weblogic
OBIEE 12c Software

Here are my files 











There are total 7 steps you need to follow in order:

Step 1st: Microsoft Loopback Adapter Installation  - http://rakeshpatil002.blogspot.in/2014/06/obiee-11117-installation.html
Step 2nd : JDK 8 Installation 
Step 3rd :  Oracle 12C Database Installation, In case if you don’t know DB installation check below video link.
Step 4th: Weblogic server and setup_bi_platform-12.2.1.0.0_win64 installation : Follow below steps.
Go to CMD (Rus as Administrator) and follow below steps and click on next[Here i am giving olny half screen shots] 
 





























 Similar to Weblogic Server you have to installed setup_bi_platform-12.2.1.0.0_win64
Step 5th: RCU installation : Execute Oracle_Home\oracle_common\bin\RCU.bat
 You need click on Next and configure details as per screen shots.




































Step 6th: Set Variable : Set below environment variable 

BI_PRODUCT_HOME= C:\Oracle\Middleware\Oracle_Home\bi

Step 7th: OBIEE12c Installation :Go To D:\OBIEE12C\Middleware\Oracle_Home\bi\bin
and click on Config.sh.






































After installation you will see you 100 % completed.