Jerry Held

1
Treehouse Software, Inc. Oracle Corporation
January 15, 2003
Mitch Doricich Treehouse Software, Inc.
Carrie-Anne Michos Oracle Corporation Carrie-anne.
michos_at_oracle.com
Daniel J. Sycalik Treehouse Software, Inc.
2
Agenda

• Company Overviews
• Public Sector Challenges
• Business Solutions
• Treehouse Solutions
• Oracle Solutions
• Products
• tRelational/DPS
• Oracle Public Sector Applications
• Oracle Business Intelligence
• Questions and Answers
• Contact Information

3
Treehouse Corporate 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 transfer and
  integration management products available for
  ADABAS.
• A complete set of implementation and support
  services to ensure customer satisfaction.

4
Oracles Government, Education, and Health
Division

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

5
Traditional Business Model for Public Sector

• Partners
• Suppliers
• Agencies
• Service Providers

• Customers
• Citizens
• Students

Administrators
6
Public Sector and e-Government Today
Semi-Manual Transactions

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

Electronic Transactions

• Customers
• Web Store
• Kiosks

• Administrators
• ERP Applications

Mostly Paper-based
7
Challenges with Legacy Applications

• The world speaks relational
• Desktop tools and COTS packages do not support
  ADABAS
• Difficult end-user or web access
• OLTP-oriented ADABAS file designs do not suit
  business intelligence apps
• Ongoing cost of ownership

8
Leading to

• Non-scalable in-house or purchased solutions
• Complex architecture with add-ons to give partial
  relational-like use
• ETL vendors need bolt-ons because they dont
  know ADABAS
• Middleware masquerading as ETL
• Non-standard SQL implementations
• The dirty read problem

• Suspect data in BI systems
• Scheduling, performance and maintenance issues

9
Oracle / Treehouse Solutions
10
Treehouse Products

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

11
tRelational / DPS Advantages

• A native ADABAS solution
• ETL CDC capability
• Support for complex modeling and transformations
• High-performance, fully-scalable architecture
• Native, direct Oracle support

12
tRelational / DPS Features

• Metadata repository
• PREDICT integration with FDT conflict resolution
• ADABAS file analysis tools for modeling
  decision-making
• ORACLE schema auto-generation
• ORACLE DDL generation
• Complex modeling and mapping

• Automatic datatype mapping/transformation
• GUI modeling environment
• Materialization (ETL) produces native output for
  SQL loader utility
• Propagation (CDC) produces native output for SQL
  processing utility
• ADABAS PLOG Consolidation (APC)
• Intelligent handling of primary keys

13
tRelational Data Analysis and Modeling
14
tRelational Statistical Analysis
This screen shows descriptor/superdescriptor
usage statistics to determine candidate Primary
Keys and indexed columns.
15
tRelationalPC - Auto Generation Example
Five tables with Primary Key and Foreign Key
constraints, and the added DPS Sequencer (MU
or PE occurrence).
16
DPS Materialization (ETL)
17
DPS Propagation (CDC)
18
tRelational / DPS is the Answer

• Maximum performance
• Reliability through static data sources
• Extensible architecture
• Zero impact on ADABAS databases
• No change in technology
• TSI 20 years of ADABAS/NATURAL product
  development expertise
• tRelational/DPS Available and advancing since
  1995

19
tRelational / DPS - The Benefits

• Ability to leverage your operating data in ADABAS
  with Oracles Data Warehousing and Business
  Intelligence solutions
• Offers both ETL and CDC capabilities to migrate
  and/or propagate ADABAS data without impacting
  performance
• Capability to add new and powerful applications
  that can coexist with your current operating
  environment
• Allows safe migration from your existing custom
  applications to Oracles packaged Applications

20
Oracle Public Sector e-GovernmentOverview
21
11i Transforming into e-Government
22
Fragmented Point Systemsto 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
E-Business Intelligence Suite 11i
Business Intelligence Portal
Organizational Planning
LOB Decision Maker
Agency Analyst
27
Oracle Balanced Scorecard
Balanced View of Measures of Government
Performance
28
Public Sector e-Business Architecture
Administrator Portal
Citizen Portal
29
Oracle Public Sector IntelligenceOverview
30
Oracle Solutions e-Government Intelligence

• Provide Tools and Applications that are
• Complete
• Integrated
• Scaleable
• High Availability
• Secure
• Standards based

31
Data Warehousing andOrganizational Intelligence
?
Cobol or NATURAL Application
Ad Hoc Query
Treehouse Software
OLAP
ADABAS
Data Mining
RDBMS
Data Warehouse
Intelligence
Transactional Data Applications
32
Oracle9i Business Intelligence Platform

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

33
(No Transcript)
34
(No Transcript)
35
Platform for Business Intelligence ETL
Oracle9i
36
Platform for BI OLAP
Oracle9i
37
Platform for Organizational IntelligenceData
Mining
Oracle9i
38
Platform for Organizational IntelligenceData
Warehousing
Oracle9i
39
Oracle Organizational IntelligenceSummary

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

40
Why Should You Take Action?

• Leverage your operating data in ADABAS with
  Oracles e-Business and Business Intelligence
  solutions
• Offers both ETL and CDC capabilities to migrate
  and/or propagate ADABAS data without impacting
  performance
• Capability to add new and powerful applications
  that can coexist with your current operating
  environment

41
Q

A
Q U E S T I O N S
A N S W E R S
42
Contact Information

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