Lotus Notes db to DB2 using DataStage

remotementor · Post by **remotementor** » Thu Feb 24, 2011 2:48 am

Hi all,

We're final year engineering students and currently working on a project which takes a Lotus Notes DB as input and loads it into tables in DB2 with some data transformation between these stages.

We tried to fetch the Notes data using the Web Services pack. However even though the job ran successfully, data wasn't fetched from Notes. We aren't able to detect the error and not sure how to proceed further.

Are we following the right approach by using Web services pack or is there any other way to fetch notes db into DS.

Any suggestions/comments will be appreciated

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Thu Feb 24, 2011 3:31 am

Welcome aboard.

While it might be possible to use the Web Services pack, it's not something I've done. You can also use an ODBC driver for Lotus Notes.