Direct virtualized SQL access to mainframe data sources
Supports SQL statements and stored calls
Driven by metadata that contains a mapping of physical databases and files to logical relational tables, mainframe data appears to be one relational database and supports SELECT, INSERT, UPDATE, and DELETE SQL statements and stored procedure calls.
Dynamic data access and integration
InfoSphere Classic Federation Server for z/OS can access data stored in VSAM, IMS, CA-IDMS, CA-Datacom, Software AG Adabas, and Db2® UDB for z/OS® databases by dynamically translating JDBC and ODBC SQL statements into native read/write APIs. It also supports dynamic integration of z/OS sequential file data for ETL processing with no need to unload or FTP files to the ETL (InfoSphere DataStage) platform.
Extends visual metadata management
Helps automate the creation of metadata for more users and extend visual metadata management to more complex scenarios thereby, improving the usability of the tool while enabling more rapid metadata creation and management.
Platform and performance optimization
Simplifies the management of the operational platform and performance optimization processes by providing an interactive view of the actual settings as well as a means for temporarily and permanently changing configuration settings.
Db2 data access
InfoSphere Classic Federation Server for z/OS includes Db2 data access performance, 64-bit client platforms, enhanced automation of support for redefined data, as well as improved flexibility in handling IMS PCB selection.