Title: Jerry Held
1Treehouse 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.
2Agenda
- 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
3Treehouse 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.
4Oracles 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
5Traditional Business Model for Public Sector
- Partners
- Suppliers
- Agencies
- Service Providers
- Customers
- Citizens
- Students
Administrators
6Public 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
7Challenges 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
8Leading 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
9Oracle / Treehouse Solutions
10Treehouse Products
- tRelational
- Data Modeling and Mapping
- Data Propagation System (DPS)
- Extract, Transform, and Load (ETL)
- Change Data Capture (CDC)
11tRelational / DPS Advantages
- A native ADABAS solution
- ETL CDC capability
- Support for complex modeling and transformations
- High-performance, fully-scalable architecture
- Native, direct Oracle support
12tRelational / 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
13tRelational Data Analysis and Modeling
14tRelational Statistical Analysis
This screen shows descriptor/superdescriptor
usage statistics to determine candidate Primary
Keys and indexed columns.
15tRelationalPC - Auto Generation Example
Five tables with Primary Key and Foreign Key
constraints, and the added DPS Sequencer (MU
or PE occurrence).
16DPS Materialization (ETL)
17DPS Propagation (CDC)
18tRelational / 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
19tRelational / 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
20Oracle Public Sector e-GovernmentOverview
2111i Transforming into e-Government
22Fragmented Point Systemsto Integrated Suite
Goal
Oracle Solution
- Oracle Applications 11i
- Complete e-Business Suite
- Runs entirely on the Internet
Seamless Integration
23From 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
24From 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
25From Local to Global
Goal
Oracle Solution
- Oracle Applications 11i
- Real-time information
- Better decision-making
- Lowers cost
Single source of Enterprise-wide information
26E-Business Intelligence Suite 11i
Business Intelligence Portal
Organizational Planning
LOB Decision Maker
Agency Analyst
27Oracle Balanced Scorecard
Balanced View of Measures of Government
Performance
28 Public Sector e-Business Architecture
Administrator Portal
Citizen Portal
29Oracle Public Sector IntelligenceOverview
30Oracle Solutions e-Government Intelligence
- Provide Tools and Applications that are
- Complete
- Integrated
- Scaleable
- High Availability
- Secure
- Standards based
31Data Warehousing andOrganizational Intelligence
?
Cobol or NATURAL Application
Ad Hoc Query
Treehouse Software
OLAP
ADABAS
Data Mining
RDBMS
Data Warehouse
Intelligence
Transactional Data Applications
32Oracle9i Business Intelligence Platform
- Single business intelligence platform
- Reduce administration and implementation costs
- Faster deployment
- Improved scalability and reliability
33(No Transcript)
34(No Transcript)
35Platform for Business Intelligence ETL
Oracle9i
36Platform for BI OLAP
Oracle9i
37Platform for Organizational IntelligenceData
Mining
Oracle9i
38Platform for Organizational IntelligenceData
Warehousing
Oracle9i
39Oracle Organizational IntelligenceSummary
- Provide Organizational Intelligence
- Technology and Applications
- that are
- Complete
- Integrated
- Scaleable
- High Availability
- Secure
- Standards based
40Why 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
41Q
A
Q U E S T I O N S
A N S W E R S
42Contact Information
- To schedule an on site appointment, call
- Mitch Doricich
- National Sales Manager, Treehouse Software
- (412) 741-1677 ext.226
- mdoricich_at_treehouse.com