How to Transfer Data From AS400 to BW Using DB Connect
This document describes how to use DB Connect to connect AS400 system to BW system running on MSSQL. A logistic application runs on a system based on a AS400 DB2 database. To be able to analyze data for the logistic application, the data must be loaded into a BW system that is based on a DBMS MSSQL. DB Connect allows to connect the DBMS for the logistic application, and to extract data from the database tables or views and transfer it to the BW system. DB Connect specifically deals with AS400 and BW running on MSSQL. However, we can use the same steps when primary database ( i.e the data base on which BW has been installed ) is different from the Source Database system.