平台之间的数据库集成 [英] Database Integration Between platforms

问题描述

大家好，有人知道DB2和MSSQL之间采用哪种软件或应用程序数据库集成技术吗?

我正在寻找第三方软件/应用程序，以处理从AS400文件到SQL Server表的预定数据传输.它将数据从AS400提取到SQL Server2005.此外，我还可以访问，插入数据以及将数据更新到SQL Server表.它使用行业标准的插件，并且可以轻松地与第三方接口集成.轻松与其他应用程序或中间件集成.我们也希望能够在SQL Server数据库中使用此数据，因此我们希望每晚从AS400更新到SQL表以同步数据.关于aleesya

Hi guys, did anybody know what kind of software or application database integration techniques between DB2 and MSSQL??

I''m looking for third-party software/application to handle a scheduled data transfer from an AS400 file to a SQL Server table. It pulled data from AS400 to SQL Server 2005. Beside I also can access, insert and update data to a SQL server table. It uses industry standard plug-ins and can easily integrate with third party interfaces. Easily integrates with other applications or middleware. We would like to be able to use this data in a SQL Server database as well, so we''d like to have nightly updates from the AS400 to our SQL table to synch up the data. Regards aleesya

推荐答案

您好，

我们在公司中与AS400广泛合作，我只是将SSIS与iSeries数据传输选项和rxferpcb.exe(例如C:\ Program Files \ IBM \ Client Access \ rxferpcb.exe)结合使用.
RXFERPCB详细信息 [ http ://blog.stevienova.com/2009/05/20/etl-method-fastest-way-to-get-data-from-db2-to-microsoft-sql-server/ [ ^ ]

Hi,

We work with AS400s extensively in our company, I just use SSIS in conjunture with the iSeries data transfer options and rxferpcb.exe (e.g C:\Program Files\IBM\Client Access\rxferpcb.exe)

RXFERPCB details[^]

You can use standard SSIS, but we found that performance is much better when using RXFERPCB

Basically, you extract data from your AS400 using RXFERPCB to create a local .CSV file. Then, you can use standard SSIS text transform to move the data into SQL Server. This is by far the fastest method of AS400 -> SQL Server ETL we have found

Nice article here

http://blog.stevienova.com/2009/05/20/etl-method-fastest-way-to-get-data-from-db2-to-microsoft-sql-server/[^]

这篇关于平台之间的数据库集成的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！