如何使用 .Net 应用程序和 SQL 查询访问大型机数据？
我们使用 VSAM 文件将大量数据存储在 IBM 大型机上。每天晚上，大量数据以文本文件的形式传输到网络上，进行处理并转储到 FoxPro 和 SQL Server 数据库中。还有许多由自定义应用程序每晚生成的文本文件，这些文件会上传到大型机以保持所有内容同步。
至少可以说，保持一切同步是非常棘手的。我们不会很快摆脱大型机，我们希望用实时访问大型机数据来取代所有夜间批处理。
我们希望能够：
- 直接从主机读取数据并根据其生成报告。可能使用 SQL 查询。
- 从自定义 .Net 应用程序读取和写入数据。
我们并不是在寻找像 Information Builders 提供的与大型机交互的新平台。我们不想使用新的“商业智能”工具构建应用程序模块或报告。我们已经知道如何使用 SQL、.Net、Visual Studio 等生成报告和编写自定义应用程序。我们所需要的只是某种适配器来连接到我们的大型机数据。
任何想法表示赞赏。
编辑：
Microsoft 的主机集成服务器 是否允许连接到大型机？ HIS 的用途是什么？
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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
听起来您只需要 VSAM 文件的 SQL 接口，例如 Connx 或 < a href="http://www.attunity.com/vsam_data_access" rel="nofollow noreferrer">Attunity 提供。
It sounds like you just need a SQL interface to your VSAM files like maybe Connx or Attunity provides.
我曾经为这些人工作过，产品简单而且非常有效。我与该公司不再有任何联系。 http://www.datadirect.com/产品/大型机集成/shadow-rte/zdirect/data/index.ssp
I used to work for these guys and the product is simple and very effective. I have no link to the company any more. http://www.datadirect.com/products/mainframe-integration/shadow-rte/zdirect/data/index.ssp
如果大型机上有 CICS，则可以使用 CICS Web 服务 (SOAP) 或 CICS Web 支持 (REST) 以访问您的 VSAM 文件。这需要在 COBOL，C/C++, PL/I, 汇编器、或 Java.这将使您免于购买成本高昂的产品。
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.
有许多 SQL 到 VSAM 产品。 IBM 有他们的 Classic Federation，Neon 有一个，等等......
There are a number of SQL to VSAM products. IBM has their Classic Federation, Neon has one, et al...