Hyundai Motor Brazil CRM System Implementation Project

1. Hyundai Motor Brazil CRM System Implementation Project Technical Architecture Solution Design Project Code : P-12-0605July, 2012 Version: 0.2

2. Revision History

3. Table of Contents • I. 기술 인프라 구축 추진 일정 • II.아키텍처 – 논리 구성도 • III.아키텍처 – 물리 구성도 • IV. 하드웨어/소프트웨어 목록 • V. System Configuration • VI. 설치절차, 체크사항 • VII. 백업 • 이관 프로세스 • 참고사항

4. I. 기술 인프라 구축 추진일정 System Open (2/1) 설계 완료 구현 완료 Project Kick-Off 6월 7월 8월 9월 10월 시스템 도입 (Procurement) 개발 장비 운영 장비 도입 개발 환경 구축 (Development) 브라질 개발 환경 구축 운영 환경 구축 (Product) 운영 환경 구축기간 유지기간

5. Web Server Siebel Web Server Extension Enterprise Server Siebel Server Siebel Server Component Component II. 아키텍처 – SIEBEL 논리구성도 Web Browser Gateway Server Siebel 개발자 Siebel Dedicated Web Client, Siebel Tools Database Server SiebelFile System Local DB

6. II. 아키텍처 – BI 논리구성도

7. III. 시스템아키텍처 - 물리구성도 NT서버 Window 서버 : Application 서버 UNIX 서버 : 통합 DB 서버 UNIX서버 백업마스터 (기도입 사용) (1socket) Usable 3.1 TB 통합 서버 #1 2 Socket 통합 서버 #2 2 Socket 스토리지 통합 DB 서버 #1 통합 DB 서버 #2 VMware 1,100GB 로드 밸런싱 Siebel Marketing Web Siebel Analytic Web Siebel Marketing Web Siebel Analytic Web Marketing DB Active (6만 tpmC) Analytic DB Active (7만 tpmC) Marketing DB 600GB Siebel SWSE Siebel SWSE VMware HA Siebel Gateway Siebel Gateway Analytic DB 400GB 상호 HA (MC/SG) 운영서버 Siebel Marketing Siebel Analytic Siebel Marketing Siebel Analytic Analytic DB Standby (7만 tpmC) Marketing DB Standby (6만 tpmC) 검증 DB 1000GB vCenter ETL 대량Email 발송엔진 (1socket) 대량 메일 발송관리 WEB (1socket) 백업장치 Marketing DB Server (1.8만 tpmC ) Analytic DB Server (2.1만 tpmC) Siebel Marketing Web/App Siebel Analytic Web/App/ETL (1socket) SAN 스위치 검증 서버 1 드라이브

8. IV. 하드웨어/소프트웨어 목록 1) 개발 서버

9. IV. 하드웨어/소프트웨어 목록 2) SIEBEL 운영 서버(Gateway Server) 3) SIEBEL 운영 서버(Application Server)

10. IV. 하드웨어/소프트웨어 목록 4) SIEBEL 운영 서버(Web Server)

11. HA V. System Configuration(Physical) Firewall • Application Server : Separate Business • Database Server Separate Biz. andHAConfig • Gateway와 Siebel File System – VM ware HA L4 Balancing Prod CRM APP Server - 12CORE (30,000 tpmC↑) - 40GB RAM Prod CRM APP Server - 12CORE (30,000 tpmC↑) - 40GB RAM HA 대량메일 발송엔진- -6Core -8GB RAM Gigabit Ethernet • Prod CRM DB Stand by • Analytics CRM DB Active • QADB • 2Core (70,000tpmC↑) • 16GB RAM • Prod CRM DB Active • Analytics CRM DB Stand by • DevelopmentDB • 2Core (60,000 tpmC↑) • 16GB RAM Development, QA APP Server -4 Core -16GB RAM ETLServer -6Core-40G RAM Backup Device External Storage - LTO G4 2 Drive - Media 80 EA - Cleaning 5 EA VMWARE 1,1000 GB QA DB 1000 GB Marketing DB 600 GB AnalyticsDB 400 GB EMS DB O GB Dev.DB 0 GB

12. V. System Configuration(Logical - Network) Public IP 10.127.3.153 Public x.x.x.x Public IP: x.x.x.x ~ x.x.x.x Firewall(External) EMS Web x.x.x.x hbcrmwb_L4 DMZ 10.127.3.153 Firewall(Internal) x.x.x.x QA CRM 10.127.3.161 Standby Active Gateway Server (10.127.3.154 ~155) Gateway Service 10.127.3.154 HA HA EMS Engine x.x.x.x Application Server (10.127.3.156 ~157) CRM 2EA, MKT 2EA Web Server Gigabit Ethernet CRM DB Svc 10.127.3.164 BI DB Svc 10.127.3.165 10.127.3.163 PRD BI DB (Active) PRD CRM DB (Stand by) 10.127.3.167 QABI DB 10.127.3.167 DEV BI DB 10.127.3.162 PRD CRM DB (Active) PRD BI DB (Stand by) 10.127.3.166 QA CRMDB 10.127.3.166 DEV CRM DB ETL Server 10.127.3.159 DEV BI 10.127.3.161 DEVCRM 10.127.3.161 EMS DB Server 10.127.3.162 External Storage VMWARE 1,1000 GB QA DB 1000 GB Marketing DB 600 GB AnalyticsDB 400 GB EMS DB O GB Dev.DB 0 GB

13. V. System Configuration (Siebel Native Load Balancing) HTTP/HTTPS L4 Switch(10.127.3.153) Web Server2 (10.127.3.152) Web Server1 (10.127.3.151) HTTP Load Balancer CRM Server Farm Listening Port : 2321 Listening Port : 2322 hbcrmap1(10.127.3.156) hbcrmap2(10.127.3.151) Marketing/BI Server Farm hbcrmap2:2322/ES_HMBPRD/eAutomotive_enu hbcrmap2:2322/ES_HMBPRD/eAutomotive_ptb hbcrmap1:2321/ES_HMBPRD/eAutomotive_enu hbcrmap1:2321/ES_HMBPRD/eAutomotive_ptb

14. V. Hyundai/Kia HMB Marketing(Analytics) System Domains

15. V. Hyundai/Kia HMB EMS(Email Marketing System) Domains

16. VI. 설치절차, 체크사항 1) 설치절차

17. VI. 설치절차, 체크사항 1) 설치 전 체크사항

18. VI. 설치절차, 체크사항 1) 설치 후 체크사항

19. VII. 백업

20. VIII. 이관 프로세스 Siebel CRM/분석 이관 프로세스 애플리케이션 개발(Development) 및 테스트환경 운영(Production )환경 Siebel CRM Siebel Analytics Siebel Interface 신규/수정된 물리적 파일 DB  DB DB Siebel Repository Siebel EIM관련 SQL

21. IX. 참고사항 – Client 아키텍처 FireFox를 통한 지원을 테스트 하고 있으며, Chrome, Safari 등의 웹 브라우저는 지원하지 않음

22. IX. 참고사항 – Client Environment Configuration for IE 6,7,8 X: Required Disable, O: Required Enable, P: Prompt OK

23. IX. 참고사항 – Client Environment Configuration for IE 6,7,8 (Continue) --: Not Applicable, X: Required Disable, O: Required Enable, P: Prompt OK

24. IX. 참고사항 – Naming Rule(개발)

25. IX. 참고사항 – Naming Rule(운영)

26. IX. 참고사항 – DB계정 및 ROLE생성 create role sse_role; grant create session to sse_role; create role tblo_role; grant ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW, CREATE DIMENSION, CREATE MATERIALIZED VIEW, QUERY REWRITE, ON COMMIT REFRESH to tblo_role; create user SIEBEL identified by Siebel#1; grant tblo_role to SIEBEL; grant sse_role to SIEBEL; alter user SIEBEL quota 0 on SYSTEM quota 0 on SYSAUX; alter user SIEBEL default tablespace SBDATA; alter user SIEBEL temporary tablespace TEMP; alter user SIEBEL quota unlimited on SBDATA; alter user SIEBEL quota unlimited on SBIDX; create user SADMIN identified by Sadmin#1; grant sse_role to SADMIN; alter user SADMIN default tablespace SBDATA; alter user SADMIN temporary tablespace TEMP; create user GUESTCP identified by Guestcp#3; grant sse_role to GUESTCP; alter user GUESTCP default tablespace SBDATA; alter user GUESTCP temporary tablespace TEMP;

27. IX. 참고사항 – System URL

28. IX. 참고사항 – System Account

29. IX. 참고사항 – DB Account

30. IX. 참고사항 – Network 구성

31. IX. 참고사항 – TNS정보 1. MARKET 운영HMBMPRD1 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.127.3.164)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = HMBMPRD1)    )  ) 2. MARKET 검증HMBMDEV1 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.127.3.166)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = HMBMDEV1)    )  ) 3. ANALYTIC 운영HMBAPRD1 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.127.3.165)(PORT = 1522))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = HMBAPRD1)    )  ) 4. ANALYTIC 검증HMBADEV1 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.127.3.167)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = HMBADEV1)    )  )

32. IX. 참고사항 – 보안 (Security) Browser 1) 사용자 인증(Authentication) - 내부 인증방식(DB) – DB Security Adapter - DB의 사용자계정을 읽어 로그인을 한다. Web Server 1. User provides name and password SWSE Credentials Siebel Object Manager 2. Password may be encrypted to prevent direct database access Encrypt password Connect using DB account 3. Connect to database Siebel Database

33. IX. 참고사항 – 개발절차 Siebel Object기준의 계층별 아키텍처 및 상관 관계 주요 Object 타입과 그들간의 관계 Configuration 개발 순서

34. End of Document