Lotus Notes Database as source system for BW

[Former Member]

I need to extract data from a Lotus Notes Database into a BW system.

I found a driver called "NotesSQL". This is a free ODBC driver available from IBM.

Can this driver be used by BW to access the data in the Lotus Notes database?

If so, how? Which source system type would be used?

Please advise, thanks.

Kevin

[dennis_scoville4 · Accepted solution]

The two options that I'd look at are DB Connect or Flat File. My knowledge of Domino is limited, so I'm not sure of it's capabilities. If you can create a view of the table, or joined tables, that you want to extract out of Lotus Notes, you can format to SAP recognized formats pretty easily and then just pull that view in through DB Connect. Otherwise, the other option would be to create and schedule an extract on the Domino server to create a comma-delimited (*.csv) file and then import that through the File DataSource interface in BI.

[Former Member · Accepted solution]

I am trying for a fully automated approach, so I prefer the "DB Connect" option, but this is the crux of my question.

The documentation for the NotesSQL ODBC driver states that it presents the domino database as a relational database to an ODBC-enabled tool so that SQL can be used to retrieve the data.

If I choose the source system type "DB Connect", what database type would I select? The choices are limited.

[dennis_scoville4 · Accepted solution]

I would try setting up the connection as Oracle, since that too would be an ODBC connection between SAP and the RDBMS.

[Former Member]

Hi Keven,

Get your data in the format you need - fast. No steep learning curve - no complicated software to drive. When over 95% of data applications support the import of CSV and delimited text files why complicate things. With this easy-to-use tool anyone can, install and start exporting Lotus Notes information in minutes. Export to CSV and text delimited format. Then simply import into any other format required

And use the flat file source system to extract this data.

Edited by: sasidhar vangara on Jun 4, 2009 11:40 AM