Migration steps RPD, Informatica & DAC
prepare for a Full load
[Link] Backup of repository from test..................................................................1
[Link] Seq number from current repository to avoid problems with row_wids.. . .2
[Link] current repository in PROD with backup created from TEST..................2
[Link] database-connections and assign workflows to Integration Service in
Workflow Manager................................................................................................. 2
[Link] DAC repository........................................................................................ 3
[Link] DAC-settings to PROD-values.................................................................3
[Link] DW-db schema and update AP Load.......................................................4
[Link] and deploy new rpd...............................................................................4
[Link] Backup of repository from test.
a. Login to [Link] on the server.
Administrator/administrator
b. Click the repository Oracle_BI_DW_Base
c.
d.
e. Open Actions in top right corner and choose Repository Contents>
Back up..
f.
i. Username/pw: Administrator/Administrator
ii. Filename: Oracle_BI_DW_Base_xx
iii. Check the boxes Skip x 3.
g. Copy backupfile from
C:\Informatica_Server\server\infa_shared\Backup to C:\Analytics
Migration Folder\To Prod
[Link] Seq number from current repository to avoid
problems with row_wids.
h. These reside in these mapplets: (Copy the Current Value in the
Sequence Generator).
i. AP01_mplt_SIL_SpidEventsFact
j. AP01_mplt_SIL_SpidEventsFact_AGG
k. AP01_mplt_SIL_TickingFact
l. AP01_mplt_SIL_TickingFact_AGG
m. AP01_mplt_SIL_TickingFact_NONAGG
n. AP01_SIL_Activity_archive_fact (Mappings)
o. AP01_SIL_Assets_archive_fact
p. AP01_SIL_Agreement_archive_fact
q. AP01_SIL_CampHist_archive_fact
r. AP01_SIL_Orders_archive_fact
s. AP01_SIL_SR_Archive_fact
[Link] current repository in PROD with backup
created from TEST.
t. Login to [Link] on the server.
Administrator/administrator
u. Click the repository Oracle_BI_DW_Base
v.
w. Edit > Operating Mode from Normal to Exclusive in Repository
Properties.
i. Wait for Service to recycle.
x. Open Actions in top right corner and choose Repository
Contents>Delete.
y.
z. Copy file from Analytics Migration Folder to
[Link] Actions and choose Repository Contents>Restore
i. Choose the file from Backup folder
ii. Restore as new > Uncheck
iii. Skip x 3> Check
[Link] operating mode to Normal
[Link] database-connections and assign workflows
to Integration Service in Workflow Manager
ac. Open repository by double-click the Oracle_BI_DW_Base
[Link] Connections>Relational and Change Service:
i. ACCBALS > ACCBALP
ii. SIEBELT2>SIEBELP2
iii. ANALYTT2>ANALYTP2
[Link] Service>Assign Integration Service
i. Choose Integration Service
1. Inf_int_service (test)
2. Inf_int_service_prod (prod
ii. Show All folders
iii. Check the Select All displayed workflows > Assign
af. Open Informatica Designer>Mapplets
i. Set current values in the sequence generators in the
mapplets as mentioned in chapter 2.
ii.
[Link] DAC repository
[Link] to DAC Client on oraclebit
[Link] to Tools>DAC Repository Management>Export
i. Change folder to C:\Analytics Migration Folder\To Prod\XX
ii.
iii. Press OK and wait for it to import.
[Link] DAC-settings to PROD-values
ai. Go to
i.
ii.
iii.
aj. Go to
i.
Setup>DAC System Properties
Change InformaticaParameterFileLocation:
TEST: C:\Informatica_Server\server\infa_shared\SrcFiles
PROD: C:\Informatica\9.5.1\server\infa_shared\SrcFiles
Setup>Informatica Servers
INFORMATICA_DW_SERVER
ii.
ak. Go to
i.
ii.
iii.
1. Service: inf_int_service(test) to
inf_int_service_prod(prod)
2. Domain: Domain_ORACLEBIT(test) to
Domain_ORACLEBIP(prod)
INFORMATICA_REP_SERVER
1. Hostname: oraclebit(test) to oraclebip(prod)
Setup>Physical Data Sources
Accbal
1. Service Name: ACCBALS(test) to ACCBALP(prod)
2. Host: [Link](test) to [Link](prod)
DataWarehouse
1. Service Name: ANALYTT2(test) to ANALYTP2(prod)
2. Host: [Link](test) to [Link](prod)
SEBL_VERT_80
1. Service Name: SIEBELT2(test) to SIEBELP2(prod)
2. Host: [Link](test) to [Link](prod)
[Link] DW-db schema and update AP Load
al. Go to Design> Tables and query updated/new tables
i. Right click and choose: Generate DW Table Scripts
ii.
am.
Go to Design>Subject Areas
i. Query Owner = AP*
ii. Click Assemble > Choose All records in the list
[Link] to Execute>Execution Plans >AP Load
i. Click Build
ii. Leave checkboxes unchecked x 2
ao. Go to Tools>ETL management>Reset data sources
[Link] AP Load > Good luck
[Link] and deploy new rpd
[Link] new rpd from oraclebit to C:\Analytics Migration Folder\To
Prod\XX on oraclebit
ar. Copy new rpd from //oraclebit\ Analytics Migration Folder\To Prod\XX
to
C:\OBIEE_MW\instances\instance1\bifoundation\OracleBIServerCom
ponent\coreapplication_obis1\repository on oraclebip
as. Open new rpd with Administration Tool
i. Rpd-pw: Admin123
ii. If promted:
1. Username:weblogic
2. Password: weblogic_01
at. Change Variables:
i. Open Manage>Variables>Repository>Variables>Static
1. OLAP_DSN: ANALYTT2(test) to ANALYTP2(prod)
2. ORA_EBS_OLTP_DSN: SIEBELT2(test) to SIEBELP2(prod)
3. OLTP_DSN: SIEBELT2(test) to SIEBELP2(prod)
4. ACCBAL_DSN: ACCBALS(test) to ACCBALP(prod)
ii. Open Manage>Variables>Session>System
1. LOGLEVEL: 7(test) to 0(prod)
a. Be aware of no logfiles being created. Can be a
good idea to keep at 7 in prod for debug, and
change to 0 and restart services after stabile
production.
[Link] to [Link]
i. weblogic/weblogic_01
ii. Choose Business Intelligence> Core Application
iii.
iv. Go to
1.
2.
3.
4.
5.
Deployment>Repository
Click Lock and edit configuration
Click Choose file and choose new rpd to deploy
Password: Admin123 x 2
Click Apply(important)
Check if new rpd name is chosen.
6.
7. Click Activate Changes
8. Go to Availability>Processes
9. Start all(if services are down during load)
[Link] to login after when Restart all completes.