John Apps HP Strategic Planning and Architecture ... O

1
Enabling OpenVMS for Data Application
Integration
John Apps HP Strategic Planning and
Architecture Mark Peterson Valassis Senior
Database Analyst Richard Thomas Attunity
Engineer Terry Layo, VP of North American Sales

www.attunity.com
November 30, 2005
2
Agenda

• Webinar overview Terry Layo, Attunity
• HP introduction John Apps, HP
• Technical story Mark Peterson, Valassis
• Technical presentation
• Enabling OpenVMS for Modern, Standards-Based
  Data Application Integration

3
About Attunity

• Attunitys is an information integration vendor.
• We eliminate the barrier to enterprise
  dataperiod.
• On-Demand access to any data source
• Enable Real-Time business initiatives
• Enable the organization to view information from
  multiple sources
• Exposing legacy data to web services and SOA
• Long history with DEC - Compaq - HP
• Support for Integrity Servers
• QUICK ROI ON EXISTING INFORMATION ASSETS

4
Attunity Connect Key Capabilities

• Standard Access via SQL, Java, .NET, XML Web
  Services
• Single, Unified Model for Data Access
• Relational, Non-Relational
• Procedures, Transactions, 3GL code
• Full Read/Write and Transaction Support
• Virtual Data Models and Data Access Services
• Robust Security, Scalability, Performance
• Easy to Use

5
Data Federation using Attunity Federate

• Single, integrated views of heterogeneous data
• Distributed query optimization and execution at
  the source, read/write capable queries
• Create simplified data models using Virtual Data
  Base
• Simplify system migration and consolidation

Virtual Federation will augment BI data
architecture. Mature vendors of data integration
and adapter technology such as Attunity have
possessed virtual data federation capabilities
for some time. (Gartner)
6
Enable OpenVMS for any Data Integration
Client Platform
OpenVMS
ODBC Driver
Attunity ConnectServer
RMS
JDBC Driver
Java
OLE/DB Provider
ADO Provider
SQLEngine
NativeAdapter
Microsoft
ADO.NET Provider
RDB
IntegrationBrokers
XMLEngine
XML Client (HTTP)
Portals
COM Client
Metadata
.NET Client
COBOL
Reporting
JCA 1.0 Client
Transaction Mgmt
JCA 1.5 Client
ETL / BI
Security
Event Adapter
Web ServicesGateway
WebServices
Other 3GL
Event Router
3GL Client
7
Attunity Federate Functional Architecture
Portals
Business Intelligence
Composite Applications
Distributed Federation Engine
SQL and XML Interfaces
Metadata
Distributed Transaction Mngr
Virtual DB Federated DB Segmented DB
Adapters
Relational / DW
Legacy
Apps
8
Federating Data - Remotely
Client Application
Federation Engine
Server
Data Access
Data Access
ISAM 30M Records 50GB
Relational 10M Records 15GB
9
Federating OpenVMS Data - Locally
Client Application
Server
Federation Engine
Data Access
Data Access
ISAM 30M Records 50GB
Relational 10M Records 15GB
10
Data Federation _at_ ValassisMark Peterson, Senior
Database Analyst

• Single Enterprise Views
• Simplified Data Model
• Superior Performance

Single Views
Virtual DB
Sales Information
Accounting
Marketing Programs
SQL Server
RMS
Rdb
11
On Demand Data Access _at_ Accuweather.com

• Real-time Access to Weather Data
• 90 Meteorologist updating the system
• 65,000 paying customers in media, business and
  government with different views
• Data Server RMS on OpenVMS Cluster
• Backend systems of Open/VMS with difficult RMS
  file structures
• Server stability questionable with the move to
  .NET
• Web Server IIS on Windows Farm
• 10M Visitors Daily,50M calls to Attunity
  Connect
• Results
• Forecast updates now take 1 minute from 3 hours

12
Questions?
John Apps HP Strategic Planning and
Architecture Mark Peterson Valassis Senior
Database Analyst Richard Thomas Attunity
Engineer Terry Layo- Terry.layo_at_attunity.com 78
1-213-5209
www.attunity.com