270 likes | 409 Vues
Hyundai Motor Brazil CRM System Implementation Project. Analytics ETL- DAC & Informatica. Project Code : P-12-0605 September, 2012 Version: 1.0. Table of Contents. Analytics ETL Overview Analytics ETL Installed Directory Analytics ETL Server Start & Stop Analytics ETL Monitoring
E N D
Hyundai Motor BrazilCRM System Implementation Project Analytics ETL- DAC & Informatica Project Code : P-12-0605September, 2012 Version: 1.0
Table of Contents • Analytics ETL Overview • Analytics ETL Installed Directory • Analytics ETL Server Start & Stop • Analytics ETL Monitoring • Analytics ETL Backup & Restore • Analytics ETL Tracking Error Logs # Analytics ETL
1. Analytics ETL Overview -. Sieble Analytics ETL Architecture -. ETL Process component : DAC and Informatica (dotted line red box) -. Sieble Analytics ETL solution 1) DAC (Datawarehouse Application Console) Server: Controlled Data Object Unit 2) DAC (Datawarehouse Application Console) Client 2) Informatica PowerCenter Server: Extract, Transformation, Loading of Data Object Unit 3) Infromatica PowerCenter Client: PowerCenter Designer, PowerCenter Workflow Manager PowerCenter Workflow Monitor, … * SRMW : Siebel Relationship Management Warehouse
1. Analytics ETL Overview -. ETL Process Flow ① Execute ETL Execution plan : DAC Client ② Execute ETL Task : DAC Server ③ Reference ETL Task(workflow) Information: Infromatica Server(Informatica Repository) ④ Execute ETL Task(workflow) : Informatica Server ⑤ Extract Data from Siebel OLTP Database ⑥ Load Data from Siebel OLAP Database
1. Analytics ETL Overview -. ETL Processing summary(Table Overview) 1 2 ① Siebel OLTP(On-Line Transaction Processing) ② Siebel OLAP(On-Line Analytical Processing) * ETL(Extract Transformation Load)
1. Analytics ETL Overview -. ETL Processing summary(Task Overview) Execution
2. Analytics ETL Installed Directory -. DAC • Server IP : 10.127.3..161(DEV), 10.127.3.159(PRODUCTION) • User/PWD : appadmin/P!ssw0rd (Remote Desktop Connection) • Location : D:\OracleDAC • - Log Location : D:\OracleDAC/bifoundation/dac/log
2. Analytics ETL Installed Directory -. Informatica • Server IP : 10.127.3..161(DEV), 10.127.3..159(PRODUCTION) • User/PWD : appadmin/P!ssw0rd ( Remote Desktop Connection ) • Location : D:\Informatica/PowerCenter8.6.1 • - Log Location : D:\Informatica/PowerCenter8.6.1/server/infa_shared/SessLogs
3. Analytics ETL Server Start & Stop -. DAC Server : Start • Start > Program > DAC menu> Start Server • Window Task Manager : javaw.exe running
3. Analytics ETL Server Start & Stop -. DAC Server : Stop • Start > Program > DAC menu> Stop Server • Window Task Manager : javaw.exe not running
3. Analytics ETL Server Start & Stop -. Informatica Server : Start • Control Panel > Administrative Tools > Services > InformaticaServices8.6.1 > Start • Window Task Manager : infasvcs.exe running
3. Analytics ETL Server Start & Stop -. Informatica Server : Stop • Control Panel > Administrative Tools > Services > InformaticaServices8.6.1 > Stop • Window Task Manager : infasvcs.exe not running
4. Analytics ETL Monitoring -. DAC : Current Run • Current Run Monitoring : Execute View > Current Run Tab > Tasks Sub Tab
4. Analytics ETL Monitoring -. DAC : Run History • Current Run Monitoring : Execute View > Run History Tab > Tasks Sub Tab
4. Analytics ETL Monitoring -. Informatica : Workflow Monitor • Start > Program > Informatica menu> Client > PowerCenter Workflow Manager
5. Analytics ETL Backup & Restore -. DAC Server : Backup • User : Administrator • Pwd : P!ssw0rd • Tools > DAC Repository Management > Export • Change import/export folder > new folder or select folder > OK
5. Analytics ETL Backup & Restore -. DAC Server : Restore • Tools > DAC Repository Management > Import • Change import/export folder > previous folder or backup folder > OK
5. Analytics ETL Backup & Restore -. Informatica Server : Backup • http://10.127.3.161:6001/admincolsole/ • User : Administrator • Pwd : P!ssw0rd
5. Analytics ETL Backup & Restore -. Informatica Server : Backup • Oracle_BI_DW_Base Repository > Actions > Backup Contents
5. Analytics ETL Backup & Restore -. Informatica Server : Backup • Repository Username : Administrator • Password : P!ssw0rd • Backup Filename : YYYYMMDD_DEV_161_INFA
5. Analytics ETL Backup & Restore -. Informatica Server : Restore • Oracle_BI_DW_Base Repository > General Properties > Exclusive > OK
5. Analytics ETL Backup & Restore -. Informatica Server : Restore • Oracle_BI_DW_Base Repository > Actions > Delete Contents
5. Analytics ETL Backup & Restore -. Informatica Server : Restore • Oracle_BI_DW_Base Repository > Actions > Restore Contents
6. Analytics ETL Tracking Error Logs -. Informatica Server : SessionLogs folder • When occurred error, go to the D:\Informatica\PowerCenter8.6.1\server\infa_shared\SessLogs • Supposed Error Task name is SIL_ActivityFact(=DAC Task name=workflow name) • Prefix name(DATAWAREHOUSE.DATAWAREHOUSE.floder name + SIL[SDE]_ActivityFact + .log • Example: DATAWAREHOUSE.DATAWAREHOUSE.SIL_HMB_CUSTOM.SIL_ActivityFact.log
6. Analytics ETL Tracking Error Logs -. Informatica Server : SessionLogs folder • Open the Log file > search the “error” Key word
Analytics ETL- DAC & Informatica Edu. End of Document