Jerry Held

1
(No Transcript)
2
Treehouse Software, Inc. Oracle
March 13, 2002
Bill Giovinazzo Oracle Corporation
Mitch Doricich Treehouse Software, Inc.
Joel Cherkis Oracle Corporation
Wayne Lashley Treehouse Software, Inc.
3
Agenda

• Treehouse Company Overview
• Challenges with State Local Systems
• Business Solutions
• Treehouse Solutions
• Oracle Solutions
• Products
• tRelational/DPS
• Oracle Business Intelligence
• Oracle Public Sector Applications
• Questions and Answers
• Contact Information

4
Treehouse Company Overview

• Founded in 1982, Treehouse Software is the
  leading independent software vendor for the
  Software AG community. Treehouse provides
• A broad suite of systems management products
  including performance management, change
  management, development, security and database
  utilities.
• The most comprehensive data migration and
  integration management products available for
  ADABAS.
• A complete set of implementation and support
  services to ensure customer satisfaction.

5
Challenges with State Local Systems

• Scarcity of human resources with ADABAS and
  NATURAL expertise
• Budgetary constraints in the current economy
• High ongoing cost of ownership
• ADABAS does not support packaged applications

6
Data Warehousing and Business Intelligence
?
Cobol or NATURAL Application
Query
OLAP
ADABAS
Data Mining
RDBMS
Data Warehouse
Business Intelligence
Transactional Data Applications
7
Data Warehousing and Business Intelligence
?
Cobol or NATURAL Application
Query
Treehouse Software
OLAP
ADABAS
Data Mining
RDBMS
Data Warehouse
Business Intelligence
Transactional Data Applications
8
Treehouse Solutions

• Data Migration and Propagation for
• Business Intelligence
• Application Migration (over time)
• Supplemental Oracle Applications
• Full Data Conversion for
• Application Conversion (all at once)

9
Oracle Solutionse-Business Intelligence

• Provide e-Business Intelligence
• Technology and Applications
• that are
• Complete
• Integrated
• Scaleable
• High Availability
• Secure
• Standards based

10
Treehouse Products

• tRelational for
• Data Mapping
• Data Propagation System (DPS)
• Extract Transform Load (ETL)
• Change Data Capture (CDC)

11
Treehouse Products

• tRelational Data Propagation System
• tRe/DPS

12
How does it work?
13
tRelational and DPS Functionality
14
Fast and Easy as Map and Pump
15
Auto Generation
Auto Generation Example Five tables with Primary
Key and Foreign Key constraints, and the added
DPS Sequencer (MU or PE occurrence).
16
Oracle State Local Overview Joel
Cherkis Oracle Public Sector Applications
17
Public Sector e-Business
18
Traditional Business Model for Public Sector

• Partners
• Suppliers
• Agencies
• Service Providers

• Customers
• Citizens
• Students

Administrators
19
Public Sector and e-Business Today
Semi-Manual Transactions

• Partners
• Fax
• E-mail
• Phone
• EDI

Electronic Transactions

• Customers
• Web Store
• Kiosks

• Administrators
• ERP Applications

Mostly Paper-based
20
Public Sector e-Business Architecture
Administrator Portal
Customer Portal
21
11i Transforming into e-Business
22
Fragmented Point Systems to Integrated Suite
Goal
Oracle Solution

• Oracle Applications 11i
• Complete e-Business Suite
• Runs entirely on the Internet

Seamless Integration
23
From Internal to External Focus
Goal
Oracle Solution

• Oracle Applications 11i
• Unifies all processes online
• Improves efficiency and reduces costs

Connecting all constituents and operations online
24
From Administrative to Self-Service
Goal
Oracle Solution

• Oracle Applications 11i
• Lowers cost
• Improves accuracy
• Enhances speed
• Promotes productivity

Move all administrative transactions to
self-service
25
From Local to Global
Goal
Oracle Solution

• Oracle Applications 11i
• Real-time information
• Better decision-making
• Lowers cost

Single source of Enterprise-wide information
26
Oracles State Local Division

• Dedicated State Local Industry Division
• 400 professional staff
• Dedicated development team
• Dedicated professional services group
• Dedicated sales and sales support organization
• Leverages Oracle Corporations 1B RD budget

27
Oracle Public Sector Applications

• Oracle Public Sector Financials
• Oracle U.S. Federal Financials
• Oracle Grants
• Oracle Public Sector Budgeting
• Oracle Student System

28
Summary

• Key success factors in Public Sector e-Business
  transformation
• Connect constituents, internal operations, and
  partners online by unifying business processes
• Move all administrative transactions to
  self-service
• Consolidate into one single source system
• Oracle Public Sector Applications 11i brings the
  e-Business Solution to you

29
(No Transcript)
30
Oracle Solutionse-Business Intelligence

• Provide e-Business Intelligence
• Technology and Applications
• that are
• Complete
• Integrated
• Scaleable
• High Availability
• Secure
• Standards based

31
E-Business Intelligence Suite 11i
Business Intelligence Portal
Corporate Strategist
LOB Decision Maker
Business Analyst
32
Roles Based Executive Dashboard

• Operational

33
Oracle Balanced Scorecard
Balanced View of Measures of Performance
34
Activity Based Management
Foundation for Understanding Performance

• Develop enterprise cost management capability
• Drive product and customer profitability
• Assess activities value add
• Determine transfer pricing
• Optimize capacity utilization

35
Business Intelligence SystemInformation Cubes

• 32 fact tables
• 27 dimensions
• 43 performance measures
• 38 reports
• 35 workbooks (over 100 worksheets)
• Collections for OA 10.7, 11.0, 11i

36
Oracle9iComplete, Therefore Simple
37
Oracle9i Application Server (Oracle9iAS)
Faster Than Ever, With Oracle9iAS Cache
38
Oracle9i Application Server - Wireless Edition
Access Using Any Device
39
Turbo-charge Web Sites

• Serve Web Pages More Quickly, To More Users
• Answer Database-Dependent Web Queries Faster
• Reduce Investment, Complexity in Web
  Infrastructure

...
Application Server
40
The Old WayFragmented Information Supply Chain
OLAPEngine
DataIntegrationEngine
Data Warehouse Engine
MiningEngine

• Protracted implementation and maintenance cycle
• Synchronization and currency issues
• Information Management chaos

41
The New Way Oracle9i

• Single business intelligence platform
• Reduce administration and implementation costs
• Faster deployment
• Improved scalability and reliability

42
Platform for Business Intelligence ETL
Oracle9i
43
Platform for BI OLAP
Oracle9i
44
Platform for Business IntelligenceData Mining
Oracle9i
45
Platform for Business IntelligenceData
Warehousing
Oracle9i
46
Oracle e-Business IntelligenceSummary

• Provide e-Business Intelligence
• Technology and Applications
• that are
• Complete
• Integrated
• Scaleable
• High Availability
• Secure
• Standards based

47
QA
48
Contact Information

• To schedule an on site appointment, call
• Mitch Doricich
• National Sales Manager, Treehouse Software
• [phone] ext.226
• www.treehouse.com