simplify information access - ibm · simplify information access d1 ... ca-idms, adabas ingres...

1

Simplify Information Access

D1 - 04 Simplify Information Access.ppt 2

On Demand Insurance Business Problems1. We lose customers because we process new policy applications too slowly.2. Our claims processing is time-consuming and inefficient.3. We need to do a better job of attracting new customers.4. We need our employees to be more productive. 5. We need to grow revenue in existing accounts, and by partnering.6. Our development teams are always behind schedule and over budget.7. We need to gain maximum efficiency out of our IT infrastructure.

On Demand Insurance CEO

2


Service Combining Frameworks

WebSphere Supports Information Integration

Enterprise Service Bus

PeopleIntegration

Process Integration Information Integration

Partner ServicesApplication Services Data ServicesPeople with Clients

WSDLWSDL WSDL WSDL WSDLWSDL WSDL WSDL

� Single programming view of federated data� Industry specific management of product data


CUSTOMERSERVICE MARKETING CUSTOMERS

& PARTNERS LEGAL HR R&DFINANCE SALES & SUPPORT

Independent Sources and Systems

Enterprise Information is in Isolated Silos

3




Imaging/Document

Mgmt

ReportMgmt

Web Content/Media Asset

Mgmt

Database/CustomSystems

NetworkFile

Systems

Workflow/Business

Process Mgmt

SELF-SERVICE COMPLIANCECALL CENTER CRM / ERP WEBSITES

On Demand Enterprise Initiatives

Each application is programmed for multiple data sources




Imaging/Document

Mgmt

ReportMgmt

Web Content/Media Asset

Mgmt

Database/CustomSystems

NetworkFile

Systems

Workflow/Business

Process Mgmt

SELF-SERVICE COMPLIANCE WEBSITESCALL CENTER CRM / ERP

WebSphere Information Integrator (WII)

WebSphere Makes it Simple, and Better

Each application see’s a single federated view

4

D1 - 04 Simplify Information Access.ppt 7Data sources

DB2Customer

Data

DB2 Claims

SQL ServerPayment

XMLIncidents

Problem: Information for Claims is Stored in Many Places

Customer and Claims data in DB2

Claim payment data in SQL Server

Submitted claims forms stored in file system in XML format

Query

Query

Query

Query

Multiple queriesMultiple connectionsHarder to program

D1 - 04 Simplify Information Access.ppt 8Data sources

DB2Customer

Data

DB2 Claims

SQL ServerPayment

XMLIncidents

Query

Integrated Claims Information

WebSphere InformationIntegrator

Single querySingle connectionEasier to program

5


� For the Customer Service Representative - one request to access all information

� For the Developer – a portlet with a single SQL query

� For the Administrator – manage view of servers, wrappers, nicknames

WebSphereInformation Integrator

Claims…

Payments….

Incident files…

SQL SvrDB2 <custssn> xsd:string,<score> xsd:int,….

<custssn> xsd:string,<score> xsd:int,….

ELEMENT incidents (incident)ELEMENT incidentDate(#PCDATA)….

Claims,…Payments,….

Incident files,…

claimid integer

payment decimal

CLAIMS

WebSphere Information Integrator Benefits


DEMO: Integrated Claims Information

Claims Info

XML

DB2

SQLSRV

Customer Service Representative

Get combined claim information –incident forms, claims history, payment info

6


� DB2 UDB � Informix� Oracle� Sybase� Teradata� MS SQL Server� ODBC

� Red Brick Warehouse� Classic Federation (5)

� IMS, VSAM, CA-Datacom, CA-IDMS, Adabas

� Ingres� Lotus Notes� Microsoft Access� Microsoft Excel� MySQL� PostgreSQL� Progress� SAS� Sybase SQL Anywhere� U2 (UniData/UniVerse)� and more…

� Web Services� SAP� PeopleSoft� Siebel� Content Data (4)� Additional Non-

Relational (4)� Life Sciences (6)� Legacy Data Access

via WS II Classic Federation for z/OS (6)

� Build custom wrappers� Java and C++ SDK

Non-relational WrappersODBC SourceRelational Source

Sample WebSphere Information Integrator Federation Data Sources and Wrappers

WIICE Source� FileNet (6)� IBM (6)� Microsoft (2)� …


Advantages of WebSphere Information Integrator over Competition

Source: IBM Software Group Competitive Project Office, 2005

� Widest range of supported information sources� Competition (BEA, Oracle, SAP, Microsoft) rely on third parties or

custom code

� Supports structured and unstructured data� Oracle Gateways does not support unstructured data� BEA Liquid Data does not support unstructured data

� Supports update in addition to query� BEA Liquid Data only supports query

� SAP and TIBCO do not provide this function

7


Product Information Management

IBM

Industry Specific


Merchandise

PlanningMarkdown

Optimize Return to Vendor

NewProduct

intro

PricingOptimize

Promo-tionsMgmt

Productsourcing

End oflife

Images,DocsExcel

Flyers, Inserts,Catalogs

Email,eCommerce

Info-Stations,Kiosks

Shelf Tags,Signage

Point of Sale

RFID

UCCnet

TRANSORA

WWRE

UDEX

QRS

SINFOS

EDI &Manual Entry

New Item Form

Contracts Authorize /Reject

Category Managers

Vendor Managers

Logistics

Price Update

Regional Managers

Brand Managers Customer

Support

Promotion Mgrs

Category Managers IT

LegacySystems

ERP & CRMSystems

DocumentManagement

Systems

CPFR

External data sources

Internal data sources

Where information is needed

Current Processes –EDI, Paper, Spreadsheets, Phone, Fax, email

8


Errors in data – 30% of data in retailers systems is wrong

Lost productivity – 25 minutes manual cleansing per SKU per year

Slow time to market – 4 weeks to introduce new products

Invoice deductions – 43% of invoices result in deductions

Failed scans – up to 70,000 per week (1 large US Retailer)

Lost sales – up to 3.5% per year

Source: A.T. Kearney, GMA, AMR

79% of Retailers and 61% of CPG manufacturers rank “item

management” as their top priorityWebsite &eCommerce

SalesBrochures

ProductSpecs

Shelf Tags &Signage

Kiosks &Info-Stations

RFID

UCCnet

TRANSORA

WWRE

OtherData Pools

Portal

EDI

Broker & RetailDirect

Images,DocsExcel

LegacySystems

ERP & CRMSystems

DocumentManagement

Systems

Business Impact of Fragmented Processes & Systems


Images,DocsExcel

LegacySystems

ERP & CRMSystems

DocumentManagement

Systems

CPFRReturns

End ofLife

Website &eCommerce

SalesBrochures

ProductSpecs

Shelf Tags &Signage

Kiosks &Info-Stations

RFID

ContentLeverage

Browser-based

UnlimitedAttributes

MultipleCategorizations

Multi-enterprise

Standards-based

Security andAudit

NewProduct

Intro

PricingOptimization

PromotionsMgmt

4) Workflow and solutions for supporting multi-department and multi-enterprise business processes

2) Tools for modeling, managing, capturing

and creating this information with high user productivity and

high information quality

1) A flexible, scalable repository managing and linking product,

location, trading partner, organization,

and terms of trade information

6) Leveraging this information via

many internal and external electronic and human touch

points

5) Exchanging and synchronizing this

information externally with

business partners

Product

Product

3) Integrating and synchronizing this information internally with legacy systems, enterprise applications, repositories and masters

I n t e g r a t e – T r a n s f o r m – H a r m o n i z e

UCCnet

TRANSORA

WWRE

OtherData Pools

Portal

EDI

Broker & RetailDirect

Global DataSynchronization

WebSphere Product Center Capabilities

9


Rich Data Model for Product Information� Manage items and various relationships among items (packaging,

substitution, cross-sell, up-sell, bundles/prepacks/outfits etc.)

� Manage locations, location hierarchies and various attributes related to locations

� Best-in-class category hierarchy support

� Support for specific attributes and attribute values� Category � Location� Trading Partner� Relationship

� Manage linkages among items, locations, organization and tradingpartners


Web Hierarchy and Sub Category

Promo. Price

Sizes

Colors

Images Marketing Benefits Cross-Sell & Up-sell

Sample Result of Product Information Management

10


Source: IBM Software Group Competitive Project Office, 2005

Product Information Management Comparison

� SAP NetWeaver – Master Data Management� Only consolidates product information for better decision-making� Does not feed multiple touch points

− Web sites, kiosks, product brochures, etc� Does not support product lifecycle business processes

− Pricing optimization, promotions, returns

� Microsoft does not provide this functionality

� BEA does not provide this functionality

� TIBCO does not provide this functionality


gallery.mpg

Make It Work Together

simplify information access - ibm · simplify information access d1 ... ca-idms, adabas ingres...

Documents