使用 SimbaServer 中间件连接到 Informix 3.30
我有一个客户，我正在尝试从旧的路由统计系统中进行一些数据迁移。该系统有一个 Informix 3.30 数据库，其上有 SimbaServer 中间件。据我所知，直到版本 5.x 才将 ODBC 和 JDBC 支持添加到 Informix，所以这已经不存在了。另外，我一直无法找到 SimbaClient ODBC 或 JDBC 驱动程序来连接到 SimbaServer 中间件。
我正在尝试使用 JasperSoft 的 JasperETL 连接到该数据库。有人对我如何实现这一目标有任何想法吗？
I have a client that I'm trying to do some data migration out of an old route-accounting system for. The system has an Informix 3.30 database with SimbaServer middleware sitting on top of it. From what I gather, ODBC and JDBC support was not added to Informix until version 5.x, so that's out. Also, I have been unable to find the SimbaClient ODBC or JDBC driver to connect to the SimbaServer middleware.
I'm trying to get connected to this database with JasperETL from JasperSoft. Anybody have any thoughts on how I might be able to accomplish this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您真的想要 Informix 3.30 吗？如 2014 年 3 月 30 日？例如，上次发布于 1986 年的产品？它时不时地从木制品中爬出来，但现在已经好几年没有这样做了。这是 SQL 之前的产品，数据库字典（目录）位于文件“database.dbd”中，数据位于“table.dat”等文件中，索引位于“table.idx”等文件中？
如果是这样，则极不可能有任何 ODBC 或 JDBC 驱动程序连接到它。
但是，您应该直接与我联系 - 请参阅我的个人资料页面 - 我们可以讨论您有哪些选择。可以说我仍然可以访问源代码，并且我知道如何从系统中获取数据。我需要更多地了解您的环境以及您是否还有任何 Informix 3.30 软件仍在运行等。（我在 MacOS X 10.6.2 上运行 Informix 3.30，以 64 位模式编译，如果这样可以放心的话）但我认为这只是一个笑话。）
如果您没有“.dbd”等文件，那么您（可能）就没有 Informix 3.30。我们还需要讨论您所拥有的。
我想您已经找到了 Simba 以及他们对 DSI（数据存储）的讨论接口）技术。 3.30 数据库是否仍在使用中，或者这是一次性数据传输？根据适用情况，您的选择会有所不同。
如果是一次性迁移，那么我们可以使用我在 1986-1996 年期间（大约）组装的工具包来完成这项工作；结果将是 ASCII 文件，其格式可以加载到您选择的 DBMS 中。
如果这是一个持续的操作 - Informix 3.30 数据库尽管已经超出其正常寿命，但仍在生产使用中 - 那么您应该查看 Simba 提供的服务以及自定义 DSII（DSI 实现）。
Informix 3.30 附带了 ALL（应用程序语言库），您可以使用它来访问 C（以及 C++）代码中的数据。您可以使用它来获取您实现的 DSII 模块中的数据 - 或者找到其他人已经实现的数据。
Are you serious about meaning Informix 3.30? As in, 3.30.14? As in, a product that was last released in 1986? It creeps out of the woodwork every so often, but hasn't done so for quite a few years now. This is the pre-SQL product, with the database dictionary (catalog) in a file 'database.dbd' and the data in files such as 'table.dat' and the indexes in files such as 'table.idx'?
If so, then there are extremely unlikely to be any ODBC or JDBC drivers to connect to it.
However, you should contact me directly - see my profile page - and we can discuss what options you have. Suffice to say I still have access to the source code, and I know how to get data out of the system. I'll need to know a lot more about your environment and whether you have any of the Informix 3.30 software still running, etc. (I have Informix 3.30 running on MacOS X 10.6.2, compiled in 64-bit mode, if that reassures you at all. But I thought it was just a joke.)
If you don't have files such as the '.dbd' and so on, then you (probably) don't have Informix 3.30. We'll also need to discuss what you do have.
I presume you've found Simba and their discussion of their DSI (Data Store Interface) technology. Is the 3.30 database still in active use, or is this a one-time data transfer? Your options will be somewhat different depending on which applies.
If it is a one-time transfer, then we can do the work with a tool kit I assembled over the period 1986-1996 (approximately); the result will be ASCII files in a format that can be loaded into the DBMS of your choice.
If it is an ongoing operation - the Informix 3.30 database is still in production use despite being somewhat beyond the end of its normal life - then you should be looking at the services Simba provides, and a custom DSII (DSI Implementation).
Informix 3.30 comes with the A.L.L (Application Language Library) that you can use to access the data from C (and hence C++) code. You'd be using that to get to the data in the DSII module that you implement - or find someone else has already implemented.