Transcript CDC Webinar

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
1
www.attunity.com
November 30, 2005
Agenda
 Webinar
 HP
overview – Terry Layo, Attunity
introduction – John Apps, HP
 Technical
story – Mark Peterson, Valassis
 Technical
presentation:
“Enabling OpenVMS for Modern, StandardsBased Data & Application Integration”
2
About Attunity
Attunity’s is an information integration vendor.
“We eliminate the barrier to enterprise
data…period.”






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
3
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
4
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)
5
Enable OpenVMS for any Data Integration
Client Platform
OpenVMS
ODBC Driver
JDBC Driver
Java
OLE/DB Provider
ADO Provider
Microsoft
ADO.NET Provider
Integration
Brokers
XML Client (HTTP)
Portals
COM Client
.NET Client
Reporting
RMS
SQL
Engine
Native
Adapter
XML
Engine
RDB
Metadata
JCA 1.0 Client
Transaction Mgmt
JCA 1.5 Client
Security
ETL / BI
Web
Services
Attunity Connect
Server
COBOL
Event Adapter
Web Services
Gateway
Other 3GL
Event Router
3GL Client
6
Attunity Federate – Functional Architecture
Portals
Business
Intelligence
Composite
Applications
Distributed
Federation Engine
SQL and XML
Interfaces
Distributed
Transaction Mngr
Metadata
Adapters
Legacy
Virtual DB
Federated DB
Segmented DB
Relational / DW
Apps
7
Federating Data - Remotely
Client Application
1
2
3
Submit Query
Break to Sub-queries
Return Result Set
(1MB)
Federation Engine
5
Join and Filter
4
Retrieve the Data
Data Access
ISAM
30M Records
50GB
Server
Data Access
Relational
10M Records
15GB
8
Federating OpenVMS Data - Locally
Client Application
1
Submit Query
2
Break to Sub-queries
3
Retrieve the Data
Data Access
ISAM
30M Records
50GB
5
Return Result Set
(1MB)
Join and Filter
Federation Engine
4
Server
Data Access
Relational
10M Records
15GB
9
Data Federation @ Valassis
Mark Peterson, Senior Database Analyst
 Single Enterprise Views
 Simplified Data Model
 Superior Performance
Single Views
Virtual
DB
Sales
Information
RMS
Accounting
SQL
Server
Marketing
Programs
Rdb
10
On Demand Data Access @ 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
•
•

Web Server – IIS on Windows Farm
•

Backend systems of Open/VMS with difficult RMS file structures
Server stability questionable with the move to .NET
+10M Visitors Daily,+50M calls to Attunity Connect
Results
•
Forecast updates now take 1 minute from 3 hours
11
Questions?
*John Apps – HP Strategic Planning and Architecture
*Mark Peterson – Valassis Senior Database Analyst
*Richard Thomas – Attunity Engineer
*Terry Layo- [email protected]
781-213-5209
12
www.attunity.com