500 likes | 716 Views
Hyundai Motor Brazil CRM System Implementation Project. Technical Architecture Solution Design. Project Code : P-12-0605 Aug, 2012 Version: 0.8. Revision History. Table of Contents. I. Schedule of Technical Infra Setup II. Architecture – Logical diagram
E N D
Hyundai Motor Brazil CRM System Implementation Project Technical Architecture Solution Design Project Code : P-12-0605Aug, 2012 Version: 0.8
Table of Contents • I. Schedule of Technical Infra Setup • II. Architecture– Logical diagram • III.Architecture– Physical diagram • IV. List of Hardware and Software • V. System Configuration • VI. Step to install/setup Siebel Enterprise Server • VII. Plan to backup • Transfer process for SRF and Browser Script • FAQ
I. Technology infrastructure Schedule System Open (2/1) 설계 완료 구현 완료 Project Kick-Off 6월 7월 8월 9월 10월 시스템 도입 (Procurement) DEV Server in Korea PROD Server 개발 환경 구축 (Development) Install DEV Server in Brazil 운영 환경 구축 (Product) Install PROD Server in Brazil Schedule to install Operate to Server
Web Server Siebel Web Server Extension Enterprise Server Siebel Server Siebel Server Component Component II. Architecture - SIEBEL logical diagram Web Browser Gateway Server Siebel 개발자 Siebel Dedicated Web Client, Siebel Tools Database Server SiebelFile System Local DB
II. Architecture - SIEBEL document security configuration Authentication and key management, log, and document security policy management server, the administrator console interface that provides overall management for document security, document security system from the user's PC client agent, SIEBEL system to control the security policies and functions of a documentconfiguration for the client user authentication, and security module for security interlock applies to personnel in conjunction with an in-house HR DB DB is. Interlocking modules SIELBE system when you call on the screen and document security document security client module interactions within SIEBLE.. Administrator Admin Console DB Authentication and Key management Server Document Security management Server Log management Server Upgrade Server Reper to ‘SIEBEL document security’ SIEBLE System Document Security Client Client Agent Call webpage (start.asp) SIEBLE
개인정보 미포함화면 보안 안함 II. Architecture SIEBEL Document Security Advanced Configuration SIEBEL access (start.asp) DRM interlocking modules of the security target address by checking the installation screen / security document and reads the attribute information security interlock module is powered.Destination View from the SIEBLE of security, a user who is logged in and SIEBEL DRM interlocking Login Login screen control and encrypt the file.. 범례 start.asp SIEBLE System Call webpage(start.asp) DRMModule File System Check DRM module DRM Module 1.SDSATLInstall.cab (DBOHDCAR.dll, SDSATLInstall.dll, XMLPsr.dll) 2. SCGetFileype.dll Load XML File Personal DATA.csv Screen and security documents attributes XML file 1.security target siebel_drm_url.xml (Screen) 2.siebel_drm_file.xml (security documents attributes) ※ SIEBLE access control in the Security Target View Car codeDATA.csv Run DRM Module InformationDATA.csv DRM ID could change When Siebel Login
II. Architecture - Security and destination address DRM interlocking modules to apply a secure connection when screen security and security of the document properties information in the following domains.
II. Architecture, interface mapping jeonguiseo Property information screen security and security documents and read each set of siebel_drm_file_attribute.xml, siebel_drm_url_attribute.xml will be granted.
II. Architecture - View Criteria security target City of SIEBEL in the menu to move DISPID_BEFORENAVIGATE2 of SWEView = [ViewName] read the information and security that will determine the. Analytics to be moved to the 'SWECmd = GetCachedFrame' because SWEView information security. ※ Menu, move DISPID_BEFORENAVIGATE2 If there is no information security on / off does not apply..
II. Interlocking module architecture - SIEBEL document security, and support the environment Interlocking modules DRM is organized as follows: OS WinXP/WIn7 the IE 6/7/8 is supported.
III. System architecture - the physical configuration NTServer Window Server: Application Server UNIX Server: DB Server UNIXServer Master Backup (1socket) Usable 3.1 TB Server#1 2 Socket Server#2 2 Socket Storage DB Server#1 DB Server#2 VMware 1,100GB Load Balancing Siebel Marketing Web Siebel Analytic Web Siebel Marketing Web Siebel Analytic Web Marketing DB Active Analytic DB Active Marketing DB 600GB Siebel SWSE Siebel SWSE VMware HA Siebel Gateway Siebel Gateway Analytic DB 400GB 상호 HA (MC/SG) PROD Server Siebel Marketing Siebel Marketing Analytic DB Standby Marketing DB Standby DEVDB 440GB vCenter ETL Send Mass-Email Engine (1socket) Send Mass-Email Engine (1socket) Backup Module Marketing DB Server Analytic DB Server Siebel Marketing Web/App Siebel Analytic Web/App/ETL (1socket) DEV Server SAN Swtich 1 Drive
IV. Hardware / software list 1) Development server
IV. Hardware / software list 2) SIEBEL operating server(Gateway Server) 3) SIEBEL operating server(Application Server)
IV. Hardware / software list 5) ETL operating server 4 ) SIEBEL operating server(Web Server)
IV. Hardware / software list 7) EMS operational servers(Engine Server) 6) EMS operational servers(WAS Server)
HA V. System Configuration(Physical) Firewall • Application Server : Separate Business • Database Server Separate Biz. andHAConfig • Gateway andSiebel File System – VMware HA L4 Balancing Prod CRM APP Server - 12CORE - 40GB RAM Prod CRM APP Server - 12CORE - 40GB RAM HA Send Mail Engine -6Core -8GB RAM Gigabit Ethernet • Prod CRM DB Stand by • Analytics CRM DB Active • QADB • 2Core • 16GB RAM • Prod CRM DB Active • Analytics CRM DB Stand by • DevelopmentDB • 2Core • 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 DEV DB 440 GB Marketing DB 600 GB AnalyticsDB 400 GB EMS DB 30 GB
V. System Configuration(Logical - Network) Public IP: 200.153.32.42 , 200.153.32.37 Firewall(External) EMS Web 200.153.32.42 DMZ hbcrmwb_L4 10.127.3.153 Firewall(Internal) 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 200.153.32.37 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 DEV BI DB 10.127.3.162 PRD CRM DB (Active) PRD BI DB (Stand by) 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 DEV DB 440 GB Marketing DB 600 GB AnalyticsDB 400 GB EMS DB 30 GB
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 crm.hyundai-brasil.com/marketing_enu crm.hyundai-brasil.com/marketing_ptb crm.hyundai-brasil.com/eAutomotive_enu crm.hyundai-brasil.com/eAutomotive_ptb
VI. Installation procedure, check 1) Installation procedure
VI. Installation procedure, check 1) Pre-installation details
VI. Installation procedure, check 1) Check after installation:
VIII. Migration process Siebel CRM / analysis of migration process Application Development Environment Production Environment Siebel CRM Siebel Analytics Siebel Interface New/Modificationifile DB DB DB Siebel Repository Siebel EIM
IX. Note - Client Architecture Testing and support through FireFox, Chrome, Safari, Web browser does not support
IX. Note– Client Environment Configuration for IE 6,7,8 X: Required Disable, O: Required Enable, P: Prompt OK
IX. Note– Client Environment Configuration for IE 6,7,8 (Continue) --: Not Applicable, X: Required Disable, O: Required Enable, P: Prompt OK
IX. Note– DB account and ROLE generated 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;
IX. Note– System URL • Add Hosts in Windows folder • Open file“C:\Windows\System32\drivers\etc\hosts” • 10.127.3.161 tcrm.hyundai-brasil.com • Save file “hosts”
IX. Note– 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) ) )
IX. Note– 보안 (Security) Browser 1) User Authentication - DB Authentication – DB Security Adapter - Read the DB user account login. 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
IX. Note– Develop procedures Siebel Object reference-tier architecture and the correlation Object type and Relationship Step to develop Configuration
IX. WWNto CRM – Network Configuration WWN 서버(58.87.41.239) BackBone CRM Dev (10.127.3.161) Judge WWN Server (58.87.41.241) BackBone CRM Prd (10.127.3.151) WWN Server (58.87.41.242) CRM Prd (10.127.3.152) Private IP Registered IP WWN Server (58.87.41.221) CRM Prd (10.127.3.153) F/W F/W leased Line
Interface Flow IX. EMSto CRM – Network Configuration