Linked Server: Use SQL Server as a Query Tool to AS400/iSeries/DB2 (pt.1)

In the data world, being able to work from a familiar platform sourcing data from a third-party system is gold. This is why most data warehousing tools operate from a chosen database system. In this article, we will focus on getting connected to a iSeries/AS400/DB2 environment, via a Linked Server on SQL Server, all this through the Microsoft OLEDB provider for DB2. This provider is widely reported as being faster for data transfer.

Read the rest of the article here.


This entry was posted in Business Performance Warehouse (BPW), Implementation, iSeries/DB2, SQL Server, Tips. Bookmark the permalink. Comments are closed, but you can leave a trackback: Trackback URL.

One Trackback