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.