Shadow z/Direct mainframe does support SQL via industry standard drivers

DataDirect's Shadow z/Direct for Data

Shadow z/Direct provides direct SQL access to mainframe data via industry-standard client drivers – –ODBC, ADO.NET and JDBC.

For high performance, scalable access to mainframe data - DB2, IMS/DB, VSAM, and ADABAS – you need only to make a routine SQL call through Shadow z/Direct and receive a result set back in a SQL relational format. Result sets can then be employed by distributed applications exactly as those same systems employ data on locally available relational databases.

Shadow z/Direct provides you with a high-performance set of call-level interfaces to data on the mainframe. Data definitions and schema information can be extracted from a variety of places to create standard relational metadata maps. All of the underlying mapping is transparent to the developer who simply codes standard SQL calls. At runtime, this mapping capability translates the standard SQL into the appropriate calls for the underlying database.

Key Features
Shadow z/Direct extends the Shadow mainframe integration suite to provide high-performance integration with mainframe data sources. It supports service-oriented host integration architectures and the latest database versions.

  • Metadata Support — Full relational metadata support for dynamic integration with development environments and business intelligence tools
  • Dynamic-to-Static SQL Conversion — When using ODBC or ADO.NET drivers, this unique, non-invasive feature converts dynamic SQL to higher-performing static SQL. It can improve performance up to 70 percent, plus it enhances and simplifies application administration. Shadow performs similar conversions for SQL.
  • Transactional Support — Full XA two-phase commit (2PC) support for transactions via Shadow Enterprise Transactions. Transactional access to the data subsystem is achieved via the Resource Recovery Services (RRS)-enabled RRS Attachment Facility (RRSAF) interface
  • XML Support — In conjunction with the Shadow JDBC client driver, information from data sources can be returned to the calling application in XML format
  • VSAM/QSAM Support — Shadow can be extended to provide high-performance integration with mainframe VSAM and QSAM sequential files, with or without CICS - update access is delivered via Shadow support inside CICS where organizational data integrity policy insists on CICS ownership of VSAM data

Features for Native ADABAS

  • Optimal application performance - Shadow exploits native ADABAS performance features, including ADABAS syntax, file level security, database constructs and operations, data types, and file security
  • Support for ADABAS SAF Security — To reduce the complexity of integrating ADABAS security with standard mainframe security products, Shadow provides features that simplify the use of RACF, ACF2, and CA-Top Secret in an ADABAS environment

Features for DB2
Shadow z/Direct allows you to exploit the new capabilities available in DB2 Version 8, including:

  • Extended limits for names, columns, and tables
  • 2 MB, BLOCK FETCH/INSERT SQL and INSERT within a SELECT statements
  • Performance enhancements such as DYNAMIC SQL caching
  • 64-bit virtual storage support
  • Extension of Shadow systems management to support GET DIAGNOSTICS facility

Make the Most of Your Mainframe-Based Data Resources
Shadow z/Direct lets you leverage your mainframe data resources in new ways that do not compromise the transaction capacity and reliability of your legacy database environments. Its ease of installation, configuration, and use can save you time and expense. Shadow z/Direct delivers high-volume scalability and reliability features such as 2PC and advanced diagnostics and controls, while giving you the high-level security you've come to expect from your mainframe systems.

More Information
SOA enablement of mainframe business logic
SOA enablement of mainframe data
SOA enablement of mainframe screen process
Shadow Advanced Features
Web Enablement
Real Time Events
Direct SQL Access
Mainframe Consumption of Web Services