I found this thread when searching http://www.mail-archive.com/[email protected]/msg97604.html
Timothy Sipples Thu, 25 Jun 2009 21:55:02 -0700 In my answer I'm assuming the VSAM is on z/OS rather than z/VSE. Here are some IBM options, not necessarily in order: 1. IBM InfoSphere Classic Federation Server for z/OS http://www.ibm.com/software/data/infosphere/classic-federation-server-z/ Classic Federation Server provides both JDBC and ODBC access to VSAM (and other z/OS-based data stores, both IBM and non-IBM). It installs directly on z/OS, so there are no extra boxes to install, manage, backup, secure, or otherwise worry about. Just connect directly from whatever reporting tool, desktop tool, etc. you want to use. (Including Cognos for System z.) 2. IBM Scalable Architecture for Financial Reporting (SAFR) http://www.ibm.com/systems/z/advantages/dataserving/solutions/safr/ Despite the "F" in SAFR, it doesn't have to be financial information. SAFR aggregates reporting requests and screams through VSAM and other data stores (including tape archives!) on z/OS once, answering scores or hundreds of report requirements. If you're not just worried about access but also want business answers, I'd look at SAFR. (Possibly in combination with Classic Federation Server.) 3. CICS VSAM Transparency (plus DB2 for z/OS) http://www.ibm.com/software/htp/cics/vt/ CICS VT allows you to move all your data from VSAM into DB2 without changing any of your application code. Whereupon you can directly access DB2 from your favorite reporting tool(s), desktop tool(s), etc. 4. As a side note, if you were wondering about writing Java code that accesses VSAM, you can do that directly on z/OS at no additional charge using the Java SDK for z/OS (and specifically the JRIO methods, which are part of JZOS). - - - - - Timothy Sipples IBM Consulting Enterprise Software Architect Based in Tokyo, Serving IBM Japan / Asia-Pacific E-Mail: [email protected] Re: VSAM Query Product Dave Roeser Re: VSAM Query Product Richard Pace Re: VSAM Query Product Richard Pace Re: VSAM Query Product Timothy Sipples -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Mark Regan Sent: Friday, August 23, 2013 5:53 AM To: [email protected] Subject: Any z/OS product support to access VSAM data via JDBC? Does IBM have a z/OS product that allows access to VSAM data via JDBC? A Google search has turned up several ISV products, but nothing really that I could find about an IBM product. Thanks, Mark Regan <>< ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
