IBM Open Data Analytics for z/OS is a data service tool that helps users access and analyze data on z/OS.
This IBM Open Data Analytics for z/OS Version 1 Release 1 User's Guide (SC27-9034-00) presents the information needed to get SQL access to mainframe data using the Data Service Studio, an Eclipse-based user interface that communicates with the Data Service server. It is intended for system and database administrators. The guide explains how to open the Data Service perspective, connect to the Data Service server, and create server metadata such as virtual source libraries, virtual tables and virtual views.
The chapters cover virtual tables for Adabas, Db2 for z/OS, CA IDMS, IMS, IBM MQ, sequential, VSAM/VSAM CICS/IAM, and zFS/HFS data, plus Db2 user-defined table functions, generating and executing SQL queries, generating code from SQL, accessing IT Operational Analytics and DB2 unload data, Server Trace, and the Data Service preferences pages.
| Program number | 5655-OD1 |
|---|---|
| Version | Version 1 Release 1 |
| Document number | SC27-9034-00 |
| Supported mainframe data sources | Adabas, Db2 for z/OS, CA IDMS, IMS, IBM MQ, Sequential, VSAM/VSAM CICS/IAM, zFS and HFS |
| Supported off-host data sources | Oracle, Microsoft SQL Server, and Db2 for LUW |
| User interface | Eclipse-based |
| Intended readers | System and database administrators |
It is intended for system and database administrators.
It is used to create metadata objects on the host Data Service server, such as virtual source libraries, virtual tables and virtual views.
It is a Data Service server access method that accesses Db2 data by reading the data in the underlying Db2 VSAM linear data sets directly.
The document number is SC27-9034-00.