Business Intelligence Application
Business Intelligence Application
Installation and Configuration
Installation and Configuration
Version 1.0
Version 1.0
May 16, 2012
May 16, 2012
T
T
a
a
ble of
ble of
Content
Content
s
s
Document
Document Overview...
Overview...
...
...
... 5
5
Document Information and
Document Information and Index...
Index...
...
...6
6
Version
Version
...6...6Index
Index
...6...61
1 BI
BI Apps
Apps Architecture..
Architecture...
...
...
...
...
...7
7
...7
...7
2
2 Software
Software e!uirements..
e!uirements...
...
...
... "
"
..."
..."
2.1
2.1 F
For
or Win
Window
dows –
s – Cli
Client
ent Sof
Softwa
tware
re
..."..."2.2
2.2 F
For L
or Linu
inux – Se
x – Serve
rver & Cl
r & Clien
ient So
t Softw
ftware
are
..."..."#
# $ar
$ardware %hec& 'ist
dware %hec& 'ist...
...
...
...
...
...
...
...
...(
...(
...(
...(
)
) %on*+uration
%on*+uration %hec&
%hec& 'ist...
'ist...
...
..1,
1,
5
5 %onnectivit-
%onnectivit- %hec&
%hec& 'ist...
'ist...
...
...11
11
6
6 Instaatio
Instaation
n /ow...
/ow...
...
...
...
... 1#
1#
7
7 0rere!uisites..
0rere!uisites...
...
...
...
...
.... 1)
1)
7.
7.1
1 F
For
or Wi
Wind
ndow
ows 2
s 200
008
8
...1)...1)7.1.1
7.1.1
re!re"uisites...14
re!re"uisites
...14
7.1.27.1.2
Installin# $%
Installin#
$% '
' u(date
u(date )*
)* on
on Windows
Windows...14
...14
"
" Instain+
Instain+ OA%'
OA%' 11+
11+ 2
2 Dataase
Dataase %ient...
%ient...
...
...15
..15
8
8..1
1 +
+n W
n Wiin
nd
do
ow
ws
s
...15...15(
( Instaatio
Instaation
n of
of Informatica
Informatica (.,.1
(.,.1 $/2
$/2 cient...
cient...
...
...
...17
17
,
,..1
1 +
+n W
n Wiin
nd
do
ow
ws
s
...17...171,
1, OBI
OBI 11.
11.1.1.
1.1.6.7 I
6.7 Insta
nstaat
ation on
ion on wind
windows...
ows...
...21
...21
10
10..1
1
re
re!r
!re"
e"ui
uisi
site
tes
s
...21...2110.
10.2
2
-
-un
un -
-e(o
e(osit
sitor
or Cr
Creat
eatin#
in# /ti
/tilit
lit
...21...2110.
10.
+I
+I
11.
11.1.1
1.1.'.
.'.0 In
0 Insta
stalla
llatio
tion o
n on w
n wind
indows
ows
...2)...2)10.)
10.)
3((l
3((lin#
in# 11.1
11.1.1.'
.1.'.7 (
.7 (at45
at45es to
es to +I
+I 11.1
11.1.1.'
.1.'.0 o
.0 on wi
n windows
ndows
...2"...2"11
11 BI
BI Apps
Apps 7(6)
7(6) Instaation...
Instaation...
...
...#,
#,
1
11
1..1
1
+
+n W
n Wiin
nd
do
ow
ws
s
...#,...#,12
12 Informatica
Informatica (.,.1
(.,.1 Server
Server Instaati
Instaation
on on
on !a3i3d...
!a3i3d...#)
...#)
12.
12.1
1
rer
rere"u
e"uisi
isites
tes for
for Inf
Infor6
or6ati
ati4a I
4a Inst
nstall
allati
ation
on
...#)...#)1
1
In
Inst
stal
alli
lin#
n# %3
%3C
C 11
11#
# 4l
4lie
ient
nt
...),
...),
1
1
..1
1
+
+n W
n Wiin
nd
do
ow
ws
s
...),...),1.2
1.2
Insta
Installin#
llin# $%C
$%C drive
drivers fo
rs for %3
r %3C &
C & %ataa
%ataase Co
se Conne4t
nne4tivit
ivit on
on Windo
Windows
ws
. .)). .))1)
1) %on*+
%on*+urin
urin+ DA% %ient
+ DA% %ient...
...
...
...
...
...
...
...
...)5
...)5
FireEye – KPI Confdential
FireEye – KPI Confdential
5is %o4u6ent is -+-I3-9 and
5is %o4u6ent is -+-I3-9 and
C+:FI%:I3L and is solel for t5e use of
C+:FI%:I3L and is solel for t5e use of
I
I
artners a
artners a
nd its
nd its
4lients.
4lients.
:o (art
:o (art
of t5is
of t5is
do4u6ent 6a e s5ared to anone outside of
do4u6ent 6a e s5ared to anone outside of
2 2
T
T
a
a
ble of
ble of
Content
Content
s
s
Document
Document Overview...
Overview...
...
...
... 5
5
Document Information and
Document Information and Index...
Index...
...
...6
6
Version
Version
...6...6Index
Index
...6...61
1 BI
BI Apps
Apps Architecture..
Architecture...
...
...
...
...
...7
7
...7
...7
2
2 Software
Software e!uirements..
e!uirements...
...
...
... "
"
..."
..."
2.1
2.1 F
For
or Win
Window
dows –
s – Cli
Client
ent Sof
Softwa
tware
re
..."..."2.2
2.2 F
For L
or Linu
inux – Se
x – Serve
rver & Cl
r & Clien
ient So
t Softw
ftware
are
..."..."#
# $ar
$ardware %hec& 'ist
dware %hec& 'ist...
...
...
...
...
...
...
...
...(
...(
...(
...(
)
) %on*+uration
%on*+uration %hec&
%hec& 'ist...
'ist...
...
..1,
1,
5
5 %onnectivit-
%onnectivit- %hec&
%hec& 'ist...
'ist...
...
...11
11
6
6 Instaatio
Instaation
n /ow...
/ow...
...
...
...
... 1#
1#
7
7 0rere!uisites..
0rere!uisites...
...
...
...
...
.... 1)
1)
7.
7.1
1 F
For
or Wi
Wind
ndow
ows 2
s 200
008
8
...1)...1)7.1.1
7.1.1
re!re"uisites...14
re!re"uisites
...14
7.1.27.1.2
Installin# $%
Installin#
$% '
' u(date
u(date )*
)* on
on Windows
Windows...14
...14
"
" Instain+
Instain+ OA%'
OA%' 11+
11+ 2
2 Dataase
Dataase %ient...
%ient...
...
...15
..15
8
8..1
1 +
+n W
n Wiin
nd
do
ow
ws
s
...15...15(
( Instaatio
Instaation
n of
of Informatica
Informatica (.,.1
(.,.1 $/2
$/2 cient...
cient...
...
...
...17
17
,
,..1
1 +
+n W
n Wiin
nd
do
ow
ws
s
...17...171,
1, OBI
OBI 11.
11.1.1.
1.1.6.7 I
6.7 Insta
nstaat
ation on
ion on wind
windows...
ows...
...21
...21
10
10..1
1
re
re!r
!re"
e"ui
uisi
site
tes
s
...21...2110.
10.2
2
-
-un
un -
-e(o
e(osit
sitor
or Cr
Creat
eatin#
in# /ti
/tilit
lit
...21...2110.
10.
+I
+I
11.
11.1.1
1.1.'.
.'.0 In
0 Insta
stalla
llatio
tion o
n on w
n wind
indows
ows
...2)...2)10.)
10.)
3((l
3((lin#
in# 11.1
11.1.1.'
.1.'.7 (
.7 (at45
at45es to
es to +I
+I 11.1
11.1.1.'
.1.'.0 o
.0 on wi
n windows
ndows
...2"...2"11
11 BI
BI Apps
Apps 7(6)
7(6) Instaation...
Instaation...
...
...#,
#,
1
11
1..1
1
+
+n W
n Wiin
nd
do
ow
ws
s
...#,...#,12
12 Informatica
Informatica (.,.1
(.,.1 Server
Server Instaati
Instaation
on on
on !a3i3d...
!a3i3d...#)
...#)
12.
12.1
1
rer
rere"u
e"uisi
isites
tes for
for Inf
Infor6
or6ati
ati4a I
4a Inst
nstall
allati
ation
on
...#)...#)1
1
In
Inst
stal
alli
lin#
n# %3
%3C
C 11
11#
# 4l
4lie
ient
nt
...),
...),
1
1
..1
1
+
+n W
n Wiin
nd
do
ow
ws
s
...),...),1.2
1.2
Insta
Installin#
llin# $%C
$%C drive
drivers fo
rs for %3
r %3C &
C & %ataa
%ataase Co
se Conne4t
nne4tivit
ivit on
on Windo
Windows
ws
. .)). .))1)
1) %on*+
%on*+urin
urin+ DA% %ient
+ DA% %ient...
...
...
...
...
...
...
...
...)5
...)5
5is %o4u6ent is -+-I3-9 and
5is %o4u6ent is -+-I3-9 and
C+:FI%:I3L and is solel for t5e use of
C+:FI%:I3L and is solel for t5e use of
I
I
artners a
artners a
nd its
nd its
4lients.
4lients.
:o (art
:o (art
of t5is
of t5is
do4u6ent 6a e s5ared to anone outside of
1)
1).1
.1
+n
+n Wi
Wind
ndow
ows ! L
s ! Lo#
o##i
#in# i
n# in F
n Fir
irst t
st ti6
i6e
e
...)5...)51).
1).2
2
I6(
I6(ort
ortin#
in# %3
%3C S
C Sour
our4e S
4e Sst
ste6
e6 Con
Contai
tainer
ners
s
...5,...5,1).
1).
Set
Settin
tin# u
# u( %a
( %ata
taase
ase Con
Conne4
ne4tio
tions
ns in
in %3
%3C
C
...52...521)
1).)
.)
Cr
Crea
eate
te %a
%ata
ta wa
ware
re5o
5ous
use s
e s45
45e6
e6a
a
...5#...5#1).
1).*
*
Set
Settin
tin# u( In
# u( Infor
for6at
6ati4a S
i4a Serv
ervi4e C
i4e Conn
onne4t
e4tion
ions in %3
s in %3C
C
...55...5515
15 %on*+
%on*+urin
urin+ Inf
+ Informat
ormatica (
ica (.,.1
.,.1 Serve
Server on '
r on 'inux
inux !a3
!a3i3d...57
i3d...57
1*.
1*.1
1
Cre
Creati
atin# I
n# Info
nfor6a
r6ati4
ti4a -
a -e(o
e(osit
sitor
or Ser
Servi4
vi4e
e
...57...5715.1.1
15.1.1
-estorin
-estorin# t5e I
# t5e I 3S 7,') ++ re(ositor
3S 7,') ++ re(ositor ...60
...60
1*
1*.2
.2
Cr
Crea
eati
tin#
n# In
Inte
te#r
#rat
atio
ion s
n ser
ervi
vi4e
4e
...6#...6#16
16 %on*+urin+
%on*+urin+ the
the Informatica
Informatica %ient...
%ient...
...
...65
65
1
1'
'..1
1
+
+n W
n Wiin
nd
do
ow
ws
s
...65...651'
1'.2
.2
Co
Co(
(in
in# So
# Sour
ur4e ;l
4e ;les a
es and l
nd loo
oo<u
<u( ;l
( ;les
es
...67...671'.
1'.
=ow
=ow to s
to star
tart an
t and st
d sto( t
o( t5e I
5e Info
nfor6a
r6ati4
ti4a se
a servi
rvi4e
4e
...67...6717
17 DA% 11
DA% 11+ Serv
+ Server Inst
er Instaa
aation o
tion on !a3
n !a3i3d.
i3d...
...
...6"
...6"
1
17
7..1
1
+
+n
n L
Liin
nu
ux
x
...6"...6"17.2
17.2
Con;
Con;#urin
#urin# n
# nviron
viron6enta
6ental va
l varial
riales in
es in 4on;#
4on;#.s5 a
.s5 and da
nd da4>en
4>env
v.s5 o
.s5 on
n
Linux "a!i!d 6a45ine
Linux "a!i!d 6a45ine
...6(...6(17.
17.
Ins
Instal
tallin
lin# $%C dr
# $%C drive
ivers F
rs For %3
or %3C %ata
C %ataas
ase Conn
e Conne4t
e4tivi
ivit
t
...7,...7,17.)
17.)
Con;
Con;#urin
#urin# t5
# t5e 4onn
e 4onne4tio
e4tions e
ns etween
tween %3C
%3C server
server & %3
& %3C re(
C re(osito
ositor on
r on
Linux "a!i!d 6a45ine
Linux "a!i!d 6a45ine
...7,...7,17
17.*
.*
=o
=ow to
w to st
star
art or
t or st
sto( t
o( t5e %
5e %3
3C S
C Ser
erve
ver
r
...7#...7#17.'
17.'
Con;
Con;#urin
#urin# Co
# Conne4ti
nne4tions
ons in I
in Infor6
nfor6ati4a
ati4a ,.0.
,.0.1 W
1 Wor<?ow
or<?ow 6ana
6ana#er
#er
...7)...7)1"
1" Instaation
Instaation of
of OBI
OBI 11.1.1.6.7
11.1.1.6.7 on
on !a3i3app
!a3i3app 4achine...
4achine...
...
...76
76
1
18
8..1
1
rre
erre
e"u
"uiis
siitte
es
s
...76...7618.1.1
18.1.1
-unnin# -C/ to Create @3>A%S and @3>IL3F+-A s45e6as
-unnin# -C/ to Create @3>A%S and @3>IL3F+-A s45e6as...76
...76
18
18.2
.2
In
Inst
stal
alli
lin# +
n# +I
I 11
11.1
.1.'
.'.0 S
.0 Ser
erve
ver
r
...",...",18.
18.
3((l
3((lin#
in# 11.1
11.1.1.'
.1.'.7 (
.7 (at45
at45es to
es to +I
+I 11.1
11.1.1.'
.1.'.0 o
.0 on L
n Linux
inux
..."7..."71(
1( Dep
Depo-in+
o-in+ BI App
BI Apps O
s Oect.
ect...
...
...
...
...
...
..."(
..."(
1,.1
1,.1
%e(lo
%e(loin#
in# t5e
t5e Aetad
Aetadata
ata -
-e(osi
e(ositor
tor and
and re
resenta
sentation
tion Cata
Catalo#
lo#
..."(..."(1,.2
1,.2
3((l
3((lin#
in# t5e +
t5e +ra4le
ra4le I 3(
I 3((li4a
(li4ations
tions Se4ur
Se4urit
it oli4
oli4 to
to I %o
I %o6ain
6ain
...(,...(,FireEye – KPI Confdential
FireEye – KPI Confdential
3 3
Document Oerie!
FireEye is implementing BI Applications (OBIEE) for reporting. This document eplains the procedure to install Oracle BI Applications !"#$. This is compiled as a part of the installation process in the %A en&ironment.
FireEye – KPI Confdential
Document Information and Inde#
Version
'ate Author(s) Comments ersion
*+,#+-,, hi&in /alhotra BI Apps !"#$ Installation 'ocument ,.
Index
Acronym Abbreviation
OOTB Out of the bo
BI Apps Business Intelligence Applications
OBIEE Oracle Business Intelligence Enterprise Edition
'AC 'ata0arehouse Administration Console
1'2 1a&a 'e&elopment 2it
F/3 Fusion /iddle0are
1 $I %&&s %rc'itecture
The belo0 screen depicts the Architecture of Oracle BI Apps !"#$. There are three tiers5
a) Client tier b) er&er tier c) 'atabase tier
FireEye – KPI Confdential
2
2
)o
)o
ft
ft
!a
!a
re *
re *
e+
e+
ui
ui
re
re
me
me
nt
nt
s
s
2.1
2.1 For W
For W
indows – Clien
indows – Clien
t Software
t Software
Oracle ,,g6- database client Oracle ,,g6- database client Informatica ".., 7F- Client Informatica ".., 7F- Client
'ata 0arehouse Administration Console ('AC) ,,.,.,.#.$ 'ata 0arehouse Administration Console ('AC) ,,.,.,.#.$ 6epository Creation 8tility ,,.,.,.#.
6epository Creation 8tility ,,.,.,.#. BI Apps !"#$
BI Apps !"#$
Oracle Business Intelligence uite
Oracle Business Intelligence uite EE ,,.,.,.#.EE ,,.,.,.#.! (0ith ! (0ith 9atches)9atches) 1a&a E de&elopments 2it (1'2) # update
1a&a E de&elopments 2it (1'2) # update $*$*
2.2
2.2 For Linux – Serv
For Linux – Serv
er & Client Softwa
er & Client Softwa
re
re
'ata 0arehouse Administration Console ('AC) ,,.,.,.#.$ 'ata 0arehouse Administration Console ('AC) ,,.,.,.#.$ Informatica ".., 7F- ser&er
Informatica ".., 7F- ser&er
1a&a E de&elopments 2it (1'2) # update 1a&a E de&elopments 2it (1'2) # update $*$* 6epository Creation 8tility ,,.,.,.#.
6epository Creation 8tility ,,.,.,.#. OBIEE ,,.,.,.#.! (0ith 9atches) OBIEE ,,.,.,.#.! (0ith 9atches)
3
3
-a
-a
rd
rd
!a
!a
re C
re C
'e
'e
c
c
/i
/i
st
st
The belo0 table
The belo0 table sho0s the 7ard0are prere:uisite chec;list sho0s the 7ard0are prere:uisite chec;list for BI A99 !"#$ Installationfor BI A99 !"#$ Installation P
Peerrqquuiissiittee IInnoorrmmaattiiccaa OOBBII!!!! ""AACC
#ar$%are #ar$%are
C98 Cores C98 Cores
$<=(
$<=(malmall l EnteEnterprirprise)>se)> =<
=<,,#(#(//edediiumum))> > ,#,#?? (4arge)
(4arge)
$<=(mall $<=(mall E
Enntteerrpprriissee))> > ==<< , ,##((//eeddiiuumm))> > ,,##?? (4arge) (4arge) $<=(mall Enterprise)> $<=(mall Enterprise)> =<
=<,#,#(/(/edediuium)m)> > ,#,#?? (4arge) (4arge) 9hysical 9hysical 6A/ 6A/ = @B(mall Enterprise)> = @B(mall Enterprise)> = =<<,,# # @@BB((//eeddiiumum))>> ,#?@B(4arge) ,#?@B(4arge) = = @@BB((mmaallll E
Entntererprpriisese)> )> =<=<,#,# @B(/edium)> @B(/edium)> ,#?@B(4arge) ,#?@B(4arge) = = @@BB((mmaallll E
Enntteerrpprriissee))> > ==<<,,## @B(/edium)> @B(/edium)> ,#?@B(4arge) ,#?@B(4arge) torage torage pace pace ,
,@B @B 4o4ocacall((mmalalll Enterprise)> Enterprise)> --((//eeddiiuum m ))>> $(4arge) $(4arge) ,
,@B @B 4oc4ocal(al(mamallll Enterprise)> Enterprise)> --((//eeddiiuum m ))>> $(4arge) $(4arge) ,
,@@B B 4o4ocacal(l(mmalalll Enterprise)> Enterprise)> --((//eeddiiuum m ))>> $(4arge) $(4arge) Belo0 is the 7ard0are configuration 0hich is being used
Belo0 is the 7ard0are configuration 0hich is being used by FireEye5by FireEye5 P
Peerrqquuiissiittee IInnoorrmmaattiiccaa OOBBII!!!! ""AACC
#ar$%are #ar$%are
C
C998 8 CCoorreess $ $ CCoorre e CC9988 $ C$ Coorre e CC9988 $ $ CCoorre e CC9988
9hysical 9hysical 6 6AA// ##$$@@BB ,#,#@@BB ##$$@@BB torage torage
ppaaccee ++uu, , <<$$!!""@@ ++uu, , <<--""@@ ++uu, , <<$$!!""@@
FireEye – KPI Confdential
FireEye – KPI Confdential
4
4
Co
Co
nf
nf
ig
ig
ur
ur
at
at
io
io
n
n
C'
C'
ec
ec
/i
/i
st
st
The belo0 table
The belo0 table sho0s the Configuration prere:uisite chec;list for sho0s the Configuration prere:uisite chec;list for BI A99 !"#$ InstallationBI A99 !"#$ Installation
oofftt00aarree 99rreerree::uuiissiitte e CCoonnffiigguurraattiioonn CCoommmmeennttss Informatica
Informatica
Informatica 6epository user (infarep) should Informatica 6epository user (infarep) should ha&e 'BA pri&ileges
ha&e 'BA pri&ileges
'AC 'AC
'ac reposito
'ac repository ry user (dacrep) should ha&euser (dacrep) should ha&e 'BA pri&ileges.
'BA pri&ileges.
This user should be assigned
This user should be assigned E6O4EE6O4E.. 6ep
6eposiositortory y CreCreatiatingng 8
8ttiilliittyy ''BBA A pprrii&&iilleeggees s aarre e rree::uuiirreedd..
OBIEE OBIEE
4inu En&ironment D 4inu En&ironment D 4i
4ibrabrary ry pacpac;ag;ages es as as menmentiotioned ned in in OraOraclecle F/3 document should be installed.
F/3 document should be installed.
8ni En&ironment 8ni En&ironment
The Follo0ing En&ironment &ariables ha&e to The Follo0ing En&ironment &ariables ha&e to b bee sseett 44A@ 44A@ 4A@ 4A@ 4CA44 4CA44 1AA7O/E 1AA7O/E
" Connectiity C'ec /ist
The section eplains the connecti&ity prere:uisite chec;list for BI A99 !"#$ Installation
Windows Machine
a) /achine 4ogin credentials b) 9 Credentials
c) FT9 soft0are
d) 9utty (For accessing 8IG bo)
e) Access to the 4inu ser&er on ports !,> #*> ,$,> $#> "!> database port (default ,*-,)
Linux (qa-i-d!firee"e!co#$ Machine – %L')C Server
a) Access to database ser&ers on database port (default ,*-,)
b) The ports ,$,> =$$> #*<#"> #,<#,,> $#> database port (default ,*-,) should be open
Linux (qa-i-a**!firee"e!co#$ Machine – +,I%% Server
a) Access to database ser&ers on database port (default ,*-,) b) The port !,> "!>"!$ needs to be open
ataase (qa-i-d$
a) Oracle T entries to connect using client tools(Informatica> 'AC and OBIEE). The tnsnames.ora file used for installation is tnsnames.ora
b) Before you install Oracle Bi Applications, DAC and Informatica PowerCenter, use appropriate database tool to create database schemas to hold the follow ing:
a DAC !epository "DAC#!$P) b Informatica Domain "I%&A)
c Informatica !epository "I%&A#!$P)
d Oracle Business Analytics 'arehouse "OBA') e Create (($ !ole and rant Pri*ileges "(($#!O+$)
Create_metadata.tx t
FireEye – KPI Confdential
Various o#e Locations
a) 'ecide on &arious 7O/E location as follo0s5
-ome older
Descri&tion
D%C-OM
u01D%C11g
DOM%I5-OM
u01Middle!areuser&roectsdomains7ifoundationdomain1
I5%-OM
u01Informatica.0.1
M8-OM
u01Middle!are
O$I-OM
u01Middle!areOracle$I1
O$II5)9%5C
u01Middle!areinstancesinstance1
,ash .rofile for LI/01 server
!TL Server eport O6AC4E7O/EH+u,+app+oracle+product+,,.-.+dbhome, eport O6AC4EI'H%ABI eport 44A@HA/E6ICAA/E6ICA.8TF= eport 4A@Hen8.8TF= eport 4CA44Hen8.8TF= eport 4'4IB6A69AT7HO6AC4E7O/E+lib eport TA'/IHO6AC4E7O/E+net0or;+admin eport 'ACCOFI@4OCATIOH+u,+'AC,,g+dac+conf<shared eport 9AT7H9AT75O6AC4E7O/E+bin
eeds to be set after Installing Informatica eport IFA7O/EH+u,+Informatica+".., eport IFA'O/AIFI4EH+u,+Informatica+"..,+domains.infa OBI!! Server eport 44A@HA/E6ICAA/E6ICA.8TF= eport 4A@Hen8.8TF= eport 4CA44Hen8.8TF= eport O6AC4E7O/EH+u,+/iddle0are+OracleBI, eport TA'/IHO6AC4E7O/E+net0or;+admin eport O6AC4EITACEH+u,+/iddle0are+instances+instance, eport O6AC4EBIA994ICATIOHcoreapplication eport EBAE9AT7HO6AC4E7O/E+clients+epm+Essbase+Essbase6TC eport O'BCIIHO6AC4EITACE+bifoundation+OracleBIApplication+ O6AC4EBIA994ICATIO+setup+odbc.ini eport 'O/AI7O/EH+u,+/iddle0are+userproJects+domains+bifoundationdomain eport 347O/EH+u,+/iddle0are+0lser&er,. eport 9AT7H9AT75O6AC4E7O/E+bin
6 Installation lo!
This section eplains the BI Apps !"#$ Installation Flo0.
FireEye – KPI Confdential
Install : ;atc' O$I on /inu# <+a=7i=a&&>
D%C serer on /inu# <+a=7i= d7>
Install Informatica serer on /inu# <+a=7i=d7>
Install $I %&&s on 8indo!s Configuration c'ec list
Connectiity C'eclist )oft!are ;rere+uisite C'ec /ist
-ard!are ;rere+uisites C'ec /ist
Install D%C on 8indo!s
Install ?D@ soft!are on 8indo!s
Install : ;atc' O$I on 8indo!s
Install Oracle Data7ase client on 8indo!s
*un *CA on 8indo!s Install Informatica Client on
8indo!s
( ;rere+uisites
(.1 For Windows 2334
(.1.1
.re-requisites
a) To pro&ide rich user interface> performance> &ersatility> portability> and security follo0ing prere:uisite soft0are should be installed.
a. 1'2#
(.1.2
Installin5 67 8 u*date 9: on Windows
This section eplains about installing 1a&a de&elopment ;it. tep , D
b) a&igate to the location 0here 1'2 oft0are is sa&ed in C5K'umps
c) 6ight clic; L select M6un as AdministratorN on Jd;<#u$*<0indo0s<#$P to run the Ja&a eecutable file d) Clic; etP on the 0elcome screen.
tep - D
'efault directory for the installation can be seen under Install to5P a) Clic; on ChangeP to choose the ne0 installation directory tep D
a) Change location5
Current 4ocation5 C5K9rogram FilesK1a&aKJd;,.#.$*KP e0 4ocation5 C5K1a&aKJd;,.#.$*KP
b) Clic; O2P
c) Clic; etP to continue the installation tep $ D
a) 1'2 installation can be monitored in MtatusN screen as sho0n belo0 tep * D
a) 8pon completion of successful installation> follo0ing screen is prompted. b) Clic; FinishP to complete the installation.
Installing
O*%C/
11g
*2
Data7ase Client
In order to ha&e appropriate database connecti&ity> Oracle database client should be installed on the machines that host the Informatica er&ices> 'AC er&er> Informatica Client and 'AC Client.
.1 +n Windows
tep , D
a) 6un the setup file to launch the Oracle client installer in C5K'umpsKOracle,,g6-Kclient. b) elect AdministratorP in the elect Installation Type 0indo0
c) Clic; etP
tep - D
a) Chec; the 4anguage is EnglishP in the elected languagesP list b) Clic; etP
FireEye – KPI Confdential
a) pecify the Oracle Base and Oracle 7ome directory b) Clic; etP
tep $ D
a) Clic; on a&e response fileP to sa&e the Oracle home and base location b) Clic; on FinishP
tep * D
a) Clic; CloseP
tep # D
a) Once the oracle data base client is installed> T entries of %ABI and BIEB databases are added in the tnsnames.ora file in C5K oracleKproductK,,.-.Kclient,Knet0or;Kadmin directory
Installation of Informatica .0.1
-2 client
.1 +n Windows
This section eplains about installing Informatica client tools on 0indo0s client machine. 'o not install Informatica client in a directory that has space in the 'irectory name (For eample C5K9rogram FilesKInformatica). If the installation of Informatica is done in a directory ha&ing space in the name then that 0ill cause errors in 'AC
tep , D
a) 6un as admin the install file in C5K'umpsKOBIA!"#$KIFAKClientK b) elect the Install Informatica ".., clients 0ith 7otFi -P
c) Clic; etP
FireEye – KPI Confdential
tep - D
a) erify the Installation 9rere:uisites b) Clic; etP
tep D
a) 9ro&ide the Installation 'irectory path b) Clic; etP
tep $ D
a) Clic; InstallP
tep * D
a) /onitor the progress of Informatica Installation
FireEye – KPI Confdential
tep # D
10 O$I 11.1.1.6.( Installation on
!indo!s
This section eplains about installing OBIEE ,,.,.,.#. as a part of Oracle BI applications !"#$ implementation. 6emember this is only done to generate the BI Apps related files> 0hen installing is done on other instances Just the correct &ersion of OBIEE client can be installed.
10.1 .re-requisites
a) 6un 6epository creating utility (6C8) to create 3I/' and 3IBI94ATFO6/ schemas (in this case these schemas 0ere installed on a local copy of Oracle er&er)
10.2 ;un ;e*ositor" Creatin5 0tilit"
tep ,<
a)
6un rcu.bat file in the 6C8 soft0are location C5K'umpsKOBIA!"#$KOBIEEK3indo0sK6C8Krcu7omeKBI. tep -<a) Clic; on etP
FireEye – KPI Confdential
tep D
a) elect CreateP b) Clic; etP
tep $ D
a) 9ro&ide the 'atabase Connections elect 'atabase type5 Oracle 'atabase 7ostname5 79ATC7A/ETIA<79.FireEye.com 9ort5 ,*-,
er&ice ame5 O6C4 8sername5 9ass0ord5 QQQQQQ 6ole5 'BA b) Clic; etP tep * D
a) elect create a ne0 9refiP type 3IP
b) Clic; on Oracle Business IntelligenceP and select Business Intelligence 9latformP c) Clic; etP
tep # D
a) elect 8se the ame pass0ord for all schemasP b) 9ro&ide the pass0ord 5 QQQQQQQ and confirm the same c) Clic; etP
tep ! D
a> 2eep the 'EAF84T table spaces.
tep = D
a) Clic; on CreateP
tep " D
a) Clic; on CloseP
FireEye – KPI Confdential
10.3 +,I%% <<!<!<!8!3 Installation on windows
tep , D
a) 6un setup.ee in C5K'umpsKOBIA!"#$KOBIEEK3indo0sKbishiphomeK'is;,.
tep - D
a) Clic; etP
tep D
a) elect ;ip oft0are updatesP b) Clic; etP
tep $ D
a) elect imple InstallP b) Clic; etP
tep * D
a) Clic; etP
tep # D
FireEye – KPI Confdential
a) Bro0se to the /iddle0are 7ome5 C5K/iddl0are b) Clic; etP
tep ! D
a) 9ro&ide belo0 details 8sername5 0eblogic 8ser 9ass0ord5 Admin,- Confirm pass0ord5 Admin,- b) Clic; etP
tep = D
a) elect Oracle Business IntelligenceP b) Clic; etP
tep " D
a) 9ro&ide the belo0 details
elect 'atabase type5 Oracle 'atabase
Connect tring is 79ATC7A/ETIA<79.FireEye.com5,*-,5O6C4 BI94ATFO6/ chema 8sername5 3IBI94ATFO6/
BI94ATFO6/ chema 9ass0ord5 0inbi,- b) Clic; etP
tep , D
a) 9ro&ide the belo0 details
elect 'atabase type5 Oracle 'atabase
Connect tring is 79ATC7A/ETIA<79.FireEye.com5,*-,5O6C4 BI94ATFO6/ chema 8sername5 3I/'
BI94ATFO6/ chema 9ass0ord5 0inbi,- b) Clic; etP
tep ,, D
a) Clic; InstallP
tep ,- D
a) 8nchec; I 0ish to recei&e soft0are updates from Oracle upportP b) Clic; etP tep , D a) Clic; esP tep ,$ D a) Clic; InstallP tep ,* D
a)
Installation L Configuration progress can be trac;ed. tep ,# Db) Clic; etP
c) Clic; on FinishP to complete the OBIEE configuration on 0indo0s
FireEye – KPI Confdential
10.4 )**l"in5 <<!<!<!8!= *atches to +,I%% <<!<!<!8!3 on
windows
The Oracle Business Intelligence ,,.,.,.#.! patch set comprises a number of patches5 Patc Abstract
,*"*"== !
9atch ,,.,.,.#.! (, of !) Oracle Business Intelligence Installer
,*"*"=! !
9atch ,,.,.,.#.! (- of !) Oracle 6eal Time 'ecisions
,*"-"#
9atch ,,.,.,.#.! ( of !) Oracle Business Intelligence 9ublisher
,*"*"=" "
9atch ,,.,.,.#.! ($ of !) Oracle Business Intelligence A'F Components
,*"*"=# ,
9atch ,,.,.,.#.! (* of !) Enterprise 9erformance /anagement Components Installed from BI Installer ,,.,.,.#.
,*="$#!
9atch ,,.,.,.#.! (# of !) Oracle Business Intelligence
,*"*"", !
9atch ,,.,.,.#.! (! of !) Oracle Business Intelligence 9latform Client Installers and /apie0er
All the patches to be used for 3indo0s and 4inu are stored in C5K'umpsKOBIA!"#$KOBIEEK3indo0sK9atches. tep ,<
a) top all the BI er&ices before applying any patch
b) tart All 9rogramsOracle Business Intelligencetop BI er&ices
tep -<
Bac; up the Oracle BI ystem> including the follo0ing5 < The O6AC4E7O/EKbifoundationKser&er directory
< The O6AC4EITACEKbifoundationKOracleBIer&erComponentKcoreapplicationobis,Krepository < The O6AC4EBI7O/EKbifoundationKJeeKmap&ie0er.earK0eb.0arK3EBIFKconfKmapie0erConfig.ml>
if you ha&e modified it tep <
a) All the patches need to be applied in the same 0ay.
tep $<
a) At the command prompt> change directory to Oracle BI 7ome directory. (cd C5K/iddle0areKOracleBI,)
tep *<
a) At the command prompt> set the en&ironment &ariables set ORACL!'#O(!)C*+(i$$,e%are+Orac,e'BI-set PAT#).ORACL!'#O(!.+bin/.PAT#. set 0A1A'#O(!).ORACL!'#O(!.+2$3 set PAT#).0A1A'#O(!.+bin/.PAT#. set PAT#).ORACL!'#O(!.+OPatc/.PAT#. tep #<
a) For each of the etracted Oracle BI ,,.,.,.#.! patch directories (starting 0ith , of !> then - of !> and so on)> change directory to the patch directory and eecute the belo0 statement
b) Apply the patch using the command5 opatch apply c) Enter MyN 0hen prompted.
d) 3hen the message SOpatch ucceededS is displayed> repeat the pre&ious steps for the net patch directory until all the patches ha&e been applied.
e) Copy the BI9ublisher'es;top-.ee and BI9ublisher'es;top#$.ee files from the O6AC4EBI7O/EKclientsKbipublisherKrepositoryKTools directory to the C5K/iddle0areKuserproJectsKdomainsKbifoundationdomainKconfigKbipublisherKrepositoryKTools directory.
f) Copy the msmdacc#$.dll file from the
O6AC4EBI7O/EKclientsKbipublisherKrepositoryKAdminK'ataource directory to the C5K/iddle0areKuserproJectsKdomainsKbifoundationdomainKconfigKbipublisherKrepositoryKAdminK'ataour ce directory.
tep !<
a) o0 apply the 1'e&eloper patch ,"*-!$.
b) 1'e&eloper patch is applied to the Oracle Common 7ome directory (C5K/iddle0areKoraclecommon). c) Follo0 the same procedure of unRipping the patch in oraclecommon> setting the en&ironment &ariable.
6emember to set the O6AC4E7O/E to oraclecommon directory to apply this patch. d) erify that the patches ha&e been successfully installed Mopatch lsin&entiryN.
FireEye – KPI Confdential
tep =<
a) tart all the BI er&ices.
11 $I %&&s (64 Installation
11.1 +n Windows
This section eplains ho0 to install the Oracle BI Applications files using the Oracle BI Applications Installer. Oracle BI Applications files are installed into the O6AC4E7O/E (C5K/iddle0areKOracleBI,) in a directory named biapps.
tep , D
a) 6un as admin the setup.eeP in C5K'umpsKOBIA!"#$KBIAKOracleBIApplications
tep - D
a) Clic; etP
tep D
FireEye – KPI Confdential
pecify the details of the Oracle BI EE installation on the local dri&e. Oracle BI EE must be installed on a local dri&e it cannot be a 3indo0s mapped dri&e that maps to a separate machine
a) At the Enter the BI Oracle 7ome 4ocation field> specify the Oracle BI EE Infrastructure home location (or O6AC4E7O/E) on the local dri&e. C5K/iddle0areKOracleBI,K
b) At the Enter the BI Instance 4ocation field> specify the Oracle BI EE instance home location (or O6AC4EITACE) on the local dri&e. C5K /iddle0areKinstancesKinstance,
c) At the Enter the 'omain 7ome 4ocation field> specify the BI domain home location on the local dri&e. C5K /iddle0areKuserproJectsKdomainsKbifoundationdomain
d) Clic; etP
tep $ D
In this screen specify the details of the 3eblogic Administration er&er
a) At the Enter the port number field> specify the 3eblogic er&er port number. The default port number is !,.
b) At the Enter the user name field> specify the 3eblogic administrator account name. The default account name is 0eblogic.
c) At the Enter the pass0ord field> specify the 3eblogic administrator account pass0ord. This pass0ord is user<specified 0hen you run the Oracle BI EE installer.
a)
elect the Oracle BI Applications that needs to install.b)
Clic; etPtep # D
a)
Clic; etPtep ! D
a) Installation progress can be trac;ed as sho0n belo05
FireEye – KPI Confdential
tep = D
12 Informatica .0.1 )erer Installation
on +a=7i=d7
12.1 .rerequisites for Infor#atica Installation
a) Install 1'2 # and eport the 1AA7O/E en&ironment &ariable b) Ensure connecti&ity to %ABI.
c) eport 44A@ H A/E6ICAA/E6ICA.8TF=> 4A@H en8.8TF=> 4CA44Hen8.8TF= d) 7a&e a database chema a&ailable in the database for the Informatica repository and 'omain
configurations
e) Copy and unRip the Informatica ".., ser&er soft0are file ",7F-er&er.Rip from C5K'umpsKOBIA!"#$KIFAK4inu to ser&er.
f) Copy the OracleAllO9rod.;ey file from the C5K'umpsKOBIA!"#$KIFAK4inu to the Informatica ser&er.
tep ,<
a) On the ser&er change to the Informatica ser&er soft0are directory on ser&er ",7F-er&er. 8se a C &ie0er or Gmanager to install to support @8I mode.
b) Type .+install.sh to launch the Informatica installer
tep -<
a) 9ro&ide the &alue for 'o you 0ant to continueP as yP b) 9ress Enter
tep <
a) 9ro&ide the &alue , to install Informatica ".., 0ith 7ot Fi b) 9ress Enter
tep $<
a) To install in @8I mode> type @P b) 9ress Enter
FireEye – KPI Confdential
tep * D
a) elect Install Informatica ".., 0ith 7otFi -P b) Clic; etP
tep # D
a) erify the 9re D re:uisites b) Clic; etP
tep ! D
a) Bro0se for the license ;ey (OracleAllO9rod.;ey) b) 9ro&ide the installation directory
c) Clic; etP
tep = D
a) Clic; on InstallP
tep " D
a) Informatica ser&er installation progress can be trac;ed as screen sho0n belo0
FireEye – KPI Confdential
tep , D
a) elect Create a domainP
b) Chec; Enable 7TT9 for Informatica AdministratorP c) Clic; etP
tep ,, D
a) Enter the follo0ing database user schema details 'atabase Type5 oracle
'atabase user id5 infa 8ser pass0ord5 QQQQ elect 1'BC 864
'atabase address5 :a<bi<db.fireeye.com5,*-, 'atabase ser&ice name5 %ABI
elect 1'BC parameters b) Clic; on Test ConnectionP
ote5
If the test connection is not passed> please chec; the 'atabase user credentials tep ,- D
a) Clic; O2P on the test connection is successful 0indo0
tep , D
a) 6etain the 'efault &alues
b) 9ro&ide the 'omain username and 9ass0ord as mentioned belo0 'omain 8ser name5 Administrator
'omain pass0ord5 QQQQQQ Confirm pass0ord5 QQQQQQ c) Clic; etP
FireEye – KPI Confdential
tep ,$ D
a) Informatica domain creation status can be trac;ed from the net screen.
tep ,* D
a) a&e the Informatica Administrator home pageP url b) a&e Installation 'irectory
13
13 Installin5 )C <
Installin5 )C <
<5 client
<5 client
13.1
13.1 +n Windows
+n Windows
This section eplains ho0 to use the 'AC installer to install 'AC Client and 'AC er&er for an Oracle Business This section eplains ho0 to use the 'AC installer to install 'AC Client and 'AC er&er for an Oracle Business Intelligence Applications en&ironment.
Intelligence Applications en&ironment.
The 'AC Client can only be installed and run on 3indo0s. The 'AC Client must be installed on the machine The 'AC Client can only be installed and run on 3indo0s. The 'AC Client must be installed on the machine 0here Informatica 9o0erCenter Client Tools 0as installed. The 'AC er&er must be installed on the machine 0here Informatica 9o0erCenter Client Tools 0as installed. The 'AC er&er must be installed on the machine 0here Informatica 9o0erCenter er&ices 0as installed. Informatica 9o0erCenter er&ices must be installed 0here Informatica 9o0erCenter er&ices 0as installed. Informatica 9o0erCenter er&ices must be installed before installing 'AC.
before installing 'AC.
.re-requisites
.re-requisites
a)
a) CoCopy py ththe e ddomomaiainsns.i.infnfaP aP fifile le frfrom om ththe e InInfoformrmataticica a seser&r&er er ininststalallalatition on 'i'irerectctorory y in in 4i4inunu :a:a<b<bi<i<dbdb +u,+Informatic
+u,+Informatica+"..,P to a+"..,P to the Informatica client the Informatica client Installation soft0are 'irectory C5KInformaticaK"..Installation soft0are 'irectory C5KInformaticaK"..,,
Installation .rocess
Installation .rocess
tep ,<
tep ,<
a)
a) 6un the 6un the dac,,dac,,ginstall.ee ginstall.ee file to file to launch the launch the installer installer in C5K'umpsKOin C5K'umpsKOBIA!"#$K'AC BIA!"#$K'AC directorydirectory b)
b) ClClicic; ; eettPP
FireEye – KPI Confdential
FireEye – KPI Confdential
41 41
tep -<
tep -<
a)
a) elecelect Inft Informatormatica cica clienlient inst installtallation ation diredirectoryctory.. b)
b) ClClicic; ; eettPP
tep <
tep <
a)
a) elecelect Int Informaformatica tica 'oma'omains fins file> ile> CliClic; c; etPetP
tep $<
tep $<
a)
a) elelect thect the 'AC ie 'AC instnstallallatiation folon folderder.. b)
tep *<
tep *<
a)
a) eelelect ct as as rere:u:uirired.ed. b)
b) ClClicic; ; eettPP
tep # <
tep # <
a)
a) ClClicic; ; InInststalallPlP
FireEye – KPI Confdential
FireEye – KPI Confdential
43 43
tep ! <
a) Trac; on progress.
tep = <
13.2 Installin5 6,C drivers for )C & ataase
Connectivit" on Windows
'AC re:uires 1'BC dri&ers for database connecti&ity. The 1'BC dri&ers that are used should be for the databases supported. ince 1'BC dri&ers sho0 &ariations 0ith different database &ersions> only dri&ers that are shipped 0ith the database or do0nloaded from database &endor site and ;no0n to be certified for the gi&en database &ersion should be used. Currently> third<party 1'BC dri&ers for the databases are not supported
teps<
a) Copy oJdbc*.Jar and oJdbc#.Jar from the C5KOracleKproductK,,.-.Kclient,KJdbcKlib directory to C5K'AC,,gKdacKlib
FireEye – KPI Confdential
14 Configuring D%C Client
14.1 +n Windows - Lo55in5 in First ti#e
This section eplains about configuring 'AC client connecti&ity to the 'AC 6epository and the 'AC ser&er. 3hen 'AC 6epository connections need to be configured> the configuration process includes creating a ne0 authentication file or selecting an eisting authentication file. The authentication file authenticates the database in 0hich the repository resides. A user 0ith the Administrator role must distribute the authentication file to any user account that needs to access the specified 'AC 6epository
After configuring a connection to the 'AC 6epository and logging in> 'AC 0ill automatically prompt to upgrade the repository schema.
tep , D
a) 4aunch 'ac client by start All 9rogramsOracle Business Intelligence 'ata 0arehouse Administrator
ConsoleClient
tep - D
a) Clic; on ConfigureP
tep D
tep $ D
a) 9ro&ide the follo0ing details
ame5 'AC%A (Any 4ogical name) Connection Type5 Oracle (Thin) Instance5 %ABI
'atabase 7ost5 :a<bi<db.fireeye.com 'atabase 9ort5 ,*-,
b) Clic; on the dialog bo Authentication FileP
tep *<
FireEye – KPI Confdential
a) elect Create authentication fileP from the drop do0n list b) Clic; O2P
tep # D
a) Clic; O2P
tep ! D
a) 9ro&ide the 'AC repository schema name Table o0ner name5 dacrep
9ass0ord5 QQQ b) Clic; O2P
c4 Save te ran$om 3ey 5enerate$6 it %i,, be use$ %i,e coni5urin5 "AC server7 tep = D
a) Clic; Test ConnectionP
tep "<
a) If uccessful> Clic; CloseP b) Clic; ApplyP
tep , D
a) Clic; FinishP
tep ,, D
a) 9ro&ide the follo0ing credentials to log into dac Connection5 'AC%A
8sername5 Administrator 9ass0ord5 Administrator b) Clic; 4oginP
tep ,- D
a) Enter the appropriate information and Clic; esP tep , D
On Create default Administrator account
a) 9ro&ide the credentials to create default account 8sername5 Administrator
9ass0ord5 fireeye:a,-
Confirm pass0ord5 fireeye:a,- b) Clic; O2P
FireEye – KPI Confdential
tep ,$ D
a) Tools 'AC er&er /anagement 6epository Configuration
14.2 I#*ortin5 )C Source S"ste# Containers
This section eplains ho0 to import metadata into the 'AC 6epository. There are some pre<re:uisites5
< Copy the contents of folder ORACLE_HOME KbiappsKd0repKdacmetadataKdacclientKeport to C5K'AC,,gKdacKeport.
< Copy 'eleteTriggers.list from ORACLE_HOME KbiappsKd0repKdacmetadataKdacclient to C5K'AC,,gKdacKconf.
tep ,<
a) Clic; on Tools'AC 6epository managementImport
tep -<
a) elect 4ogical> system> o&er 0rite log file in the categories list b) In applications list select Oracle ,-.,.,P and 8ni&ersalP c) Chec; Truncate repository tables and Enable batch modeP d) Clic; O2
tep <
a) 6etype the tet b) elect esP
FireEye – KPI Confdential
tep $<
a) Importing tableNs progress can be trac;ed as belo0
tep *<
14.3 Settin5 u* ataase Connections in )C
This section eplains the procedure to specify the transactional and data 0arehouse data sources in 'AC. tep ,<
a) Clic; on etup9hysical 'ata sources
b) 9ro&ide the 'ata 0arehouse details as sho0n belo0 and test Connection and a&e it ame5 'ata3arehouse
Type5 3arehouse
Connection Type5 Oracle (Thin) Instance5 %ABI
Table O0ner5 OBA3
Table o0ner 9ass0ord5 QQQQQQQ 'B 7ost5 :a<bi<db
9ort5 ,*-,
c) Clic; on Test ConnectionP
d) Clic; O2P on Test connection uccessful 0indo0 e) Clic; on AEP
tep -<
a) Clic; on the ame5 O6A,,*,
b) 9ro&ide the source system (Apps) Connections ame5 O6A6,-,,
Type5 ource
Connection Type5 Oracle (Thin) T ame5 BIEB
7ost5 de&<erp<db.fireeye.com 9ort5,*#
Table O0ner5 apps
Table o0ner 9ass0ord5 QQQQQQQ c) Clic; on Test ConnectionP
d) Clic; O2P on Test connection uccessful 0indo0 e) Clic; on AEP
FireEye – KPI Confdential
14.4 Create ata warehouse sche#a
This section eplains ho0 to create data 0arehouse schema table through 'AC. tep ,<
a) Configure the connections in the ystem tab in 'AC.
tep -<
a) Tools ET4 /anagement Configure
tep <
a) elect Oracle in the dropdo0n as sho0n belo05
a) Choose @enerate Create statements for 'ata 3arehouse Table b) Clic; etP
tep *<
elect the datasource 0here you 0ant to create the tables. elect eecute to let 'AC create it
tep #<
a) /onitor the process
b) Clic; FinishP on the uccessful screen
FireEye – KPI Confdential
14." Settin5 u* Infor#atica Service Connections in )C
This section eplains ho0 to register the Informatica 9o0erCenter Integration er&ices ser&ice and the Informatica 9o0erCenter 6epository er&ice in 'AC.
tep , D
a) Clic; on etupInformatica ser&ers
b) Clic; IFO6/ATICA6E9E6E6 and configure it ame5 IFO6/ATICA6E9E6E6 Type5 6epository 7ostname5 :a<bi<db er&er port5 #* 4ogin5 Administrator 9ass0ord5 :aadmin,-
6epository ame5 6OBIA%A c) Clic; on Test Connection
d) Clic; O2 on Test connection uccessful 0indo0 e) Clic; on AEP
ote5 'AC ser&er should be up and running before testing the Connections tep -<
a) Clic; on Informatica ser&ersP and configure IFO6/ATICA'3E6E6 b) pro&ide the follo0ing details in the Edit Tab
ame5 IFO6/ATICA'3E6E6 Type5 Informatica er&ice5 IOBIA%A 'omain5 'omain:a<bi<db 4ogin5 Administrator 9ass0ord5 QQQQQQ
6epository er&ice5 6OBIA%A c) Clic; on Test ConnectionP
d) Clic; O2P on Test connection uccessful 0indo0 e) Clic; on AEP
FireEye – KPI Confdential
1" Configuring Informatica .0.1 )erer
on /inu# +a=7i=d7
This section eplains about creating the Informatica 6epository ser&ice and Informatica Integration ser&ice and re:uired configurations.
1".1 Creatin5 Infor#atica ;e*ositor" Service
tep ,<
a) Open the Informatica administrator console (open https5++:a<bi<db5=$$+administrator+ in the bro0ser) b) 8se the belo0 credentials to 4og into Informatica Admin console
8sername5 Administrator 9ass0ord5 QQQQQQQQ
tep -<
a) Clic; on Actionse09o0erCenter 6epository er&ice in the 'omain a&igator
tep <
a) 9ro&ide the follo0ing details ame5 6OBIA%A
4ocation5 'omain:a<bi<db (default &alue)
4icense5 ",license :a<bi<db$=*$, (select it from the drop do0n bo) ode5 node,:a<bi<db (select it from the drop do0n bo)
b) Clic; etP
tep $ D
a) 9ro&ide the follo0ing database details for Informatica repository elect 'atabase Type5 Oracle (from the drop do0n list)
8sername5 infarep 9ass0ord5 QQQQQQQQ Connect tring5 :abi
Code page5 8TF<= encoding of 8nicode
b) Chec; o Content eists under specified connection tring. Create ne0 contentP c) Clic; on FinishP
FireEye – KPI Confdential
1".1.1
;estorin5 the ,I )..S =>89 ++, re*ositor"
This section eplains about restoring the contents of this OracleBI'3Base.rep file into the Informatica repository. An Informatica 6epository file called OracleBI'3Base.rep is installed in the O6AC4E7O/EKbiappsKd0repKInformaticaK6epository directory during the Oracle BI Applications installation on 0indo0s machine.
tep ,<
a) Copy the OOTB BI Apps Informatica repository bac; up file (OacleBI'3Base.rep) From folder C5K/iddle0areKOracleBI,KbiappsKd0repKInformaticaK6epository to bac; up directory in Informatica +u,+Informatica+"..,+ser&er+infashared+Bac;up
b) Change the 6epository 9ropertiesOperating /ode to Eclusi&e.
c) Clic; on Actions6epository Contents'elete
d) Clic; on Actions6epository Contents6estore (Actions tab 0ill be on the right side top of the admin
page)
FireEye – KPI Confdential
tep -<
a) elect the Bac;up file OracleBI'3Base.repP from the drop do0n bo b) Clic; O2P
tep <
a) Clic; O2P to Confirm restore contents
tep $<
tep *<
a) elect the 6epository ser&ice (6OBIA%A) in the 'omain na&igator b) elect the 9ropertiesP tab in the 6epository ser&ice
c) Clic; on EditP in the 6epository 9ropertiesP section
tep #<
a) Change the operating mode to ormalP from Eclusi&eP mode (select it from the drop do0n bo) b) Clic; O2P
tep !<
a) Chec; Complete<0ait for all processes to completeP b) Clic; O2P
FireEye – KPI Confdential
1".2 Creatin5 Inte5ration service
tep ,<
a) 6epository ser&ice (6OBIA%A) should be a&ailable and running in ormal /ode
b) To create Integration ser&ice clic; on Actionse09o0erCenter Integration er&ice in the 'omain
a&igator 3indo0
tep -<
a) 9ro&ide the belo0 details for Integration ser&ice ame5 IOBIA%A (9ro&ide a logical name) 4ocation5 'omain:a<bi<db (default &alue)
4icense5 ",license:a<bi<db$=*$, (select it from the drop do0n bo) ode5 node,:a<bi<db (select it from the drop do0n bo)
b) Clic; etP
tep <
'etermining the 'ata /o&ement /ode5
Before deploying Oracle BI Applications> data mo&ement mode (ACII or 8nicode) for the 9o0erCenter Integration er&ice has to be determined. The Character 'ata /o&ement /ode is an Informatica 9o0erCenter Integration er&ice option needs to be chosen based on 0hether it is a single<byte or multi<byte data.
Choose 8nicode if non<ACII characters ha&e to be mo&ed. Other0ise> choose ACII. The 'ata /o&ement /ode option is configurable and can be reset after installation.
a) 9ro&ide the belo0 repository ser&ice details
9o0erCenter 6epository ser&ice5 6OBIA%A (select from the dropdo0n bo) 8sername5 Administrator
9ass0ord5 QQQQ
b) 'ata /o&ement /ode5 8nicode (select from the dropdo0n bo)
FireEye – KPI Confdential
tep $<
a) Change the code page to UTF-8 encoding of unicodeP (select from the dropdo0n bo) b) Clic; O2P
tep *<
a) Enable the Integration er&ice by clic;ing the Enable the er&iceP (mall green button on the right side top of the page)
ote5 'onNt clic; on the recycle button Just net to the Enable button. It 0ill e&entually recycle the Integration ser&ice that 0e Just created
16 Configuring t'e Informatica Client
16.1 +n Windows
This section eplains about adding a repository in the Informatica client and connection to the repository is configured
tep ,<
a) 4aunch 9o0erCenter 6epository /anager tart All programsInformatica"..,9o0erCenter
6epository /anager
tep -<
a) Clic; on 6epositoryConfigure 'omain
tep <
a) Clic; on Add 'omain and pro&ide the belo0 details 'omain ame5 'omain:a<bi<db
@ate0ay 7ost5 :a<bi<db @ate0ay 9ort5 #* b) Clic; O2P
FireEye – KPI Confdential
tep $<
/a;e sure that the repository 6OBIA%A is selected in the right<hand pane L Clic; O2
tep *<
a) 6ight clic; on the repository and select Connect b) 9ro&ide the follo0ing connection details
ecurity 'omain5 ati&e 9ass0ord5 QQQQ
c) Clic; on ConnectP
tep #<
16.2 Co*"in5 Source files and loo?u* files
teps D
a) Copy the source files from C5K/iddle0areKOracleBI,KbiappsKd0repKInformaticaKrcFiles to +u,+Informatica+"..,+ser&er+infashared+rcFiles.
b) Copy the loo;up files from C5K/iddle0areKOracleBI,KbiappsKd0repKInformaticaK4;pFiles to +u,+Informatica+"..,+ser&er+infashared+4;pFiles
16.3 ow to start and sto* the Infor#atica service
teps D
a) Change to Informatica ser&er installation directory +u,+Informatica+"..,+ser&er+tomcat+bin b) Type Infaservice [startup | shutdown]to start or stop the Informatica ser&ice
FireEye – KPI Confdential
1( D%C 11g )erer Installation on
+a=7i=d7
1(.1 +n Linux
The 'AC er&er can run on 4inu> but it must first be installed on a 3indo0s machine> and then copied o&er to a 4inu machine> as described in the steps belo0. Oracle does not pro&ides an installer for 'AC on 8IG
9rere:uisites5
a) 1'2 &ersion ,.#. or higher needs to be installed
b) Informatica 9o0erCenter er&ices has to co<locate on a machine that 0ill host the 'AC er&er c) Informatica ser&er has been configured
d) Connection details for 'AC /etadata 6epository database (dacrep) are re:uired Note5 If FT9 is used to copy the Rip file> use binary mode.
tep , D
a) On the 3indo0s machine 0here 'AC is installed> create a temporary folder (for eample> a folder K'AC,,g8IGK).
b) Copy the C5K'AC,,gKdac inside the 'AC,,g8IG folder> remo&e the Kicons and Keport sub<folder. c) Uip the temporary folder and copy to the 'AC ser&er linu machine.
d) 8nRip the temporary folder in the +u,> rename it to 'AC,,g. tep -<
a) Change to the uniscriptb;p directory +u,+'AC,,g+dac+uniscriptb;pP
tep <
a) 8se dos-uni command as belo0 to con&ert the shell script files to 8IG format (this 0ill remo&e the carriage return and line feed characters) in the directory +u,+'AC+dac+uniscriptb;pP
b dos!uni" #$sh
tep $<
1(.2 Confi5urin5
%nviron#ental
variales
in
confi5!sh and dac@env!sh on Linux qa-i-d
#achine
In this section the en&ironment &ariables for 1AA7O/E is configured in config.shP and en&ironment &ariables for the 'AC er&er are configured in dacen&.shP
tep ,<
a) Edit the config.shP file located in the +u,+'AC,,g+dac directory to point to the correct &ersion of the 1'2 by setting the 1AA7O/E en&ironment &ariable.
b) eport 1AA7O/EH+usr+Ja&a+Jd;,.#.$
tep -<
a) Edit the dacen&.shP P file located in the +bda,+'AC+dac directory as belo0 IFO6/ATICAE6E64OCATIOH+u,+Informatica+"..,
'O/AIIFAFI4E4OCATIOH+u,+Informatica+"..,+domains.infa
