Agenda Stage Stage 7.5

Ascential World Korea 2004 11 3 004 Ascential Software Corporation. All rights reserved. Ascential is a trademark of Ascential Software Corporation or its affiliates and may be registered in the United States or other jurisdictions. Reproduction and redistribution is prohibited. -Stage

Agenda Stage Stage 7.5

Ascential Enterprise Integration Suite Service-Oriented Architecture, DISCOVER PREPARE TRANSFORM and DELIVER,,,, ProfileStage QualityStage Stage Enterprise Connectivity IT Web Services, XML, J2EE, JMS One Vendor End-to-end Solution

Custom Apps on Mainframe Requirements Extraction Criteria Common Target Format Custom Apps on UNIX 3 rd Party SW SAP Oracle Siebel PeopleSoft Initial Extraction Extract & Load into Stage 1 Assessment Discover Assess & Validate individual sources Alignment Cleanse Standardize individual sources Harmonization Consolidate Integrate Cleanse Normalize & Harmonize across sources Solution Implementation Target System Prepare Transform Load Load OLTP & 3 rd Party EDW External, EDW, Compliance BASEL II, Sarbanes Oxley

Iterations II Extraction Assessment Alignment Harmonization Solution Implementation Deliverables: Staged Extracted Deliverables: Quality Rpt - Gap Analysis Reports - Business Rules & Requirements - Technical Specs/Design Deliverables: An Application that Splits Domains and Translates each source - The Aligned Structure Deliverables: An Application that Translates, Integrates, Enriches, Standardizes and Consolidates - The Harmonized Structure - Cross Ref Tables - Match Index Tables Deliverables: An Application that Prepares, Transforms and Loads into the final Solution - A procedure for handling daily transactional processing ProfileStage & AuditStage QualityStage Stage & Connectivity PACKs Stage TX & RTI Metadata Management Deliverables: Metadata Repository MetaStage & MetaBrokers

Iterations II - Roles, Process, Architecture Individual Source Level 1 to 1 movement Integrated Across Sources many to 1 movement Business Solution Level system movement Extended Teams Core Team Blueprint (Design) Test Realization (Build) Source Extraction Access Filter Stage Source Definitions Stage Assessment Discover Validate Gap Analysis Requirements DQ Report, Gap Report, Bus Rule Requirements -- Business and Technical Specifications Alignment Translate Standardize (Split Domains) Harmonization Consolidate Cleanse Integrate Harmonized (Logical View) Cross-Ref Keys, Solution Keys & Match Index Tables Solution Implementation Transform Load Transact EDW OLTP 3rd Party Go Live (Final) Information Flow Flow of Translation Tables

- Measure Analyze Improve

Rule Rule 2004 Ascential Software Corporation. All rights reserved. Ascential is a trademark of Ascential Software Corporation or its

ProfileStage AuditStage QualityStage Stage Profiling Auditing,, GUI,

Custom Apps on Mainframe Custom Apps on UNIX 3 rd Party SW SAP Oracle Siebel PeopleSoft External Profile Consolidate Staging Area Harmonize Cleanse Standardize Central Master Reference Master data Mapping SOURCE SYSTEMS ( ) 2004 Ascential Software Corporation. All rights reserved. Ascential is a trademark of Ascential Software Corporation or its

Batch Marts & Warehouses EAI BPM App Servers Java &.Net Apps J2EE WS Msg Q J2EE Application Server RTI Server Ascential Platform Siebel PeopleSoft Transactional bases Packaged Applications SAP RTI Console

RTI Architecture RTI Console RTI Auditing Authentication Authorization Logging J2EE Platform Load Balancing Web Service Client Java Messaging Service Enterprise Java Beans Web Service Client JMS Client Java Application RTI,, RTI Agent Stage Server 1 RTI Agent Stage Server 2 RTI Agent Stage Server N Always on Transformer RTI Output Always on RTI Input QualityStage Always on (Enterprise Integration Suite)

RTI Bindings Web Services (SOAP/HTTP) Enterprise Java Beans Generates Generates WSDL File Session Bean Java Messaging Services Generates Message-Driven Bean

ROOM Solutions Text Files Environmental 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 A B C D E F G H I J Excel Schedules Underwriting base Occupancy Web Geo Room Solutions Insurance Service DB

ROOM Solutions Environmental Occupancy Geo RTI Server Text Files Upload Web Service Underwriting base 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 A B C D E F G H I J Excel Waves CASS RTI Stage/QualityStage Web services QualityStage,, Stage,, IT 80% 2004 Ascential Software Corporation. All rights reserved. Ascential is a trademark of Ascential Software Corporation or its

Agenda Stage Stage 7.5

DBMS Ascential Stage Parallel Extender

Ascential Parallel Extender Ascential Parallel Extender는 어플리케이션을 변경하지 않고도 자동화된 병렬처리를 제공하여 최고의 성능을 발휘함 또한 Oracle, Sybase ASIQ,IBM DB2 EEE, IBM Informix XPS, 등의 RDBMS가 제공하는 병렬성을 최대로 활용 2004년 11월 4일 2004 Ascential Software Corporation. All rights reserved. Ascential is a trademark of Ascential Software Corporation or its affiliates and may be registered in the United States or other jurisdictions. Reproduction and redistribution is prohibited. 18

Parallel Extender (Partitioning) Parallel Extender (Pipelining) (Repartitioning) Pipelining Source U-Z N-T G- M A-F Partitioning Repartitioning Repartitioning Warehouse

Stage Parallel Extender Concept Job. Configuration File 4 4

A-F Transform Processor 1 Source G- M N-T Transform Processor 2 U-Z Transform Processor 3 Transform Processor 4

½ 12 5 hours 1 ½ hours Time -Extract - Transform - Load 1 2 3 4 5 6 7 8 9 12

Parallel Extender Configuration File 2004 Ascential Software Corporation. All rights reserved. Ascential is a trademark of Ascential Software Corporation or its CPU CPU CPU CPU Configuration file Parallel Extender Engine (degree)

SMP MPP SMP. (Parallelism) (time-to- market).,.,. Oracle, Sybase ASIQ, IBM DB2 UDB EEE, IBM Informix XPS Teradata..

Agenda Stage Stage 7.5

Version 7.5 Ascential Stage Enterprise Edition Lookup job validation Complex flat file Sequential file multi-node import Transformer, Lookup

Version 7.5 DS and DS EE HTML Job Reporting Job Sequencer Table Transformer Multi-Client Manager Director/Manager Ascential Branding Bar Ascential Stage Standard Edition Job Operational Meta

Version 7.5 Platform and Connectivity OS Connector RTI Mobile Director USS Ascential Stage Enterprise Edition MVS Edition Enhancements DB2 bulk load Null handling

Lookup Lookup stage editor Primary link lookup key Lookup Lookup

Lookup Lookup Conditions Lookup Lookup Lookup

Job Validation Job Canvas Toolbar Job

Complex Flat File - Pane 2: Standard columns grid Pane 1: Hierarchical record viewer Pane 3:column attribute

Complex Flat File Layouts Parallel Engine View COBOL View

Enterprise Edition 3 Suppress message [Informational & Warning messages only] Demote message [from Warning to Informational] Promote message [from Informational to Warning] Job

Job Project,

Job GUI Memory CPU Record Counts APT_PERFORMANCE_DATA XML, style sheet HTML

HTML Job Report - Header & job bitmap Stage informati on Link properties Job properties

HTML Job Report - stylesheet : DSJobReport.xsl XML, XSL

Job Sequencer 004 Ascential Software Corporation. All rights reserved. Ascential is a trademark of Ascential Software Corporation or its affiliates and may be registered in the United States or other jurisdictions. Reproduction and redistribution is prohibited.

ob Sequencer Checkpoint/Restart Checkpoint/restart JOB1, JOB2, JOB3 trigger Checkpoint/restart JOB1 fails Reset JOB1 and run it again JOB1 OK, JOB2 fails Skip JOB1, reset JOB2 and run it again JOB1 OK, JOB2 OK, JOB3 fails Skip JOB1 & JOB2, reset JOB3 and run it again JOB1 OK, JOB2 OK, JOB3 OK Start at JOB1 again.

Job Sequencer Loop StartLoop, EndLoop activitie Loop Loop For firstnum To lastnum Step increment For Each In delimited list..

Job Sequencer Loop Loop startloopname.$counter Loop Loop EndLoop StartLoop Loop loop counter

Job Sequencer User Variables Sequence BASIC Expression Global Job Sequence

Job Sequencer Terminator Stage job Job Sequence job abort STOP job abort

004 Ascential Software Corporation. All rights reserved. Ascential is a trademark of Ascential Software Corporation or its affiliates and may be registered in the United States or other jurisdictions. Reproduction and redistribution is prohibited.

Table Schema Views Enterprise Edition Internal Schema Cobol Standard Edition

Transformer : Expression : Expression DSLink3.OrderCount + 1 If (DSLink3.Total > 0) Then DSLink3.Total Else -1 NullToZero : (DSLink3\.[a-z,A-Z,0-9]*) : NullToZero($1) NullToZero(DSLink3.OrderCount) + 1 If (NullToZero(DSLink3.Total) > 0) Then DSLink3.Total Else

View Before NOW

Re-License Clients 2004 Ascential Software Corporation. All rights reserved. Ascential is a trademark of Ascential Software Corporation or its

Multi Client Manager

Platform Updates Platform Red Hat AS 3.0 z/os 1.3 w/ Unix System Services WinCE (for RTI Mobile Director) Platform Windows NT AIX 4.3.3 Red Hat ASE 2.1

DBMS Oracle 10g Informix XPS 8.5 Sybase 12.5 Teradata V2R5.1 Informix IDS 9.4

RTI Mobile Director 004 Ascential Software Corporation. All rights reserved. Ascential is a trademark of Ascential Software Corporation or its affiliates and may be registered in the United States or other jurisdictions. Reproduction and redistribution is prohibited.

Windows CE RTI Mobile Director PDA Stage Director Viewing jobs Detailed Job View Event Log Detailed Event View

Windows CE RTI Mobile Director Mobile Infrastructure Stage Web Service Ascential RTI Services

Forum What s new Whitepaper Webinar Tips & Techniques