We have a large amount of data stored on an IBM mainframe using VSAM files. A lot of this data is dropped on the network every night in the form of text files to be processed and dumped into FoxPro and SQL Server databases. There are also many text files produced nightly by custom applications that get uploaded to the mainframe to keep everything in sync. Keeping the everything in sync is very tricky, to say the least. We are not getting rid of the mainframe any time soon and we would like to replace all the nightly batch processing with real time access to the mainframe data. We would like to be able to: Read data directly from the mainframe and produce reports based on it. Possibly using SQL queries. Read and Write data from custom .Net applications. We are not looking for a new platform to interface with the mainframe like Information Builders offers. We don't want to build application modules or reports with new "Business Intelligence" tools. We already know how to generate reports and write custom applications using SQL,.Net, Visual Studio, etc. All we are looking for is some sort of adapter to connect to our mainframe data. Any ideas are appreciated. EDIT: Would Microsoft's Host Integration Server allow connectivity to the mainframe? What is HIS meant for?

Reputation: 3276

How can I access mainframe data with .Net applications and SQL Queries?

We have a large amount of data stored on an IBM mainframe using VSAM files. A lot of this data is dropped on the network every night in the form of text files to be processed and dumped into FoxPro and SQL Server databases. There are also many text files produced nightly by custom applications that get uploaded to the mainframe to keep everything in sync.

Keeping the everything in sync is very tricky, to say the least. We are not getting rid of the mainframe any time soon and we would like to replace all the nightly batch processing with real time access to the mainframe data.

We would like to be able to:

Read data directly from the mainframe and produce reports based on it. Possibly using SQL queries.
Read and Write data from custom .Net applications.

We are not looking for a new platform to interface with the mainframe like Information Builders offers. We don't want to build application modules or reports with new "Business Intelligence" tools. We already know how to generate reports and write custom applications using SQL,.Net, Visual Studio, etc. All we are looking for is some sort of adapter to connect to our mainframe data.

Any ideas are appreciated.

EDIT:

Would Microsoft's Host Integration Server allow connectivity to the mainframe? What is HIS meant for?

Upvotes: 2

Answers (4)

cschneid

Reputation: 10765

If you have CICS on the mainframe, you could use CICS Web Services (SOAP) or CICS Web Support (REST) to access your VSAM files. This would necessitate writing CICS application programs in COBOL, C/C++, PL/I, Assembler, or Java. It would save you from purchasing a product, which may be cost-prohibitive.

Upvotes: 1