1 / 12

Enabling OpenVMS for Data & Application Integration

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. Agenda.

paloma
Download Presentation

Enabling OpenVMS for Data & Application Integration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 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

  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 XMLEngine IntegrationBrokers XML Client (HTTP) Portals COM Client Metadata .NET Client COBOL Reporting JCA 1.0 Client Transaction Mgmt JCA 1.5 Client Security ETL / BI 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 Legacy Relational / DW Apps

  8. 1 5 Return Result Set (1MB) Submit Query 2 4 Break to Sub-queries Join and Filter 5GB 1GB 3 Retrieve the Data Federating Data - Remotely Client Application Federation Engine Server Data Access Data Access ISAM 30M Records 50GB Relational 10M Records 15GB

  9. 1 5 Return Result Set (1MB) Submit Query 4 Join and Filter 3 2 Retrieve the Data Break to Sub-queries 5GB 1GB Federating OpenVMS Data - Locally Client Application Federation Engine Server Data Access Data Access ISAM 30M Records 50GB Relational 10M Records 15GB

  10. Data Federation @ 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 @ 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@attunity.com 781-213-5209 www.attunity.com

More Related