DSXchange

Hi,

In our project we have requirement to extract data from Lotus notes. We do not have ODBC driver installed for lotus notes. In this case, is there any possibility to extract data from lotus notes and put into oracle (may not use data stage). I do not know any thing about lotus notes.

Please do help me in this regard.

Thanks in advance.

The simple answer is No. Get an ODBC driver for Lotus Notes. Even then it's not the easiest thing in the world to configure.

An alternative strategy is to have some external process dump whatever it is you need from Lotus Notes into a text file format of some kind, and process that with DataStage.

Right - the alternate is something like 'Notes Pump' - a product that will push Notes data elsewhere, like a database staging table where you can then process it from there.