John, Here are some more suggestions, in no particular order:
1. IBM InfoSphere Classic Federation Server for z/OS provides JDBC, ODBC, and DRDA access to VSAM data (and other types of data): https://www.ibm.com/us-en/marketplace/infosphere-classic-federation-server Microsoft Excel understands how to connect via ODBC. 2. You can install the IBM z/OS Platform for Apache Spark, then connect Microsoft Excel to Spark (using various methods): https://www.ibm.com/us-en/marketplace/real-time-analysis-on-z-systems Spark provides a lot of features that data scientists and actuaries are bound to like and even prefer, beyond Microsoft Excel. Apache Spark runs almost entirely on zIIP engines, if you have one or more of them. I think it's orderable from IBM Shopz at no additional charge. (Optional IBM support is chargeable, and there are bigger/larger function sets that are chargeable.) 3. Query Management Facility (QMF): https://www.ibm.com/us-en/marketplace/db2-qmf Despite its name ("DB2 QMF"), QMF also supports VSAM and other data sources. -------------------------------------------------------------------------------------------------------- Timothy Sipples IT Architect Executive, Industry Solutions, IBM z Systems, AP/GCG/MEA E-Mail: sipp...@sg.ibm.com ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
