How can I extract data from DB2 (on IBM iSeries) to the data warehouse via Datastage as the ETL tool. I mean do I first need to use ODBC to create connectivity and use an adapter for the extraction and transformation of data? Thanks so much if anybody could provide an answer.

Interview Candidate
Oct 13th, 2005
5
4091

Showing Answers 1 - 5 of 5 Answers

Madhav

Oct 24th, 2005

From db2 stage, we can extract the data in ETL

Ravi Kiran

Oct 25th, 2005

You would need to install ODBC drivers to connect to DB2 instance (does not come with regular drivers that we try to install, use CD provided for DB2 installation, that would have ODBC drivers to connect to DB2) and then try out

kalyan

Oct 28th, 2005

How Can I connect directly to the DB2 from DataStage

Sharanu Patil

Feb 28th, 2006

U can use DB2 stage to implement this

sekr
Profile Answers by sekr Questions by sekr

Apr 13th, 2006

if ur system is mainfarmes then u can utility called load and unload ..
load will load the records into main farme systme from there u hv to export in to your system ( windows)