Connect to Lotus Domino

[Former Member]

Hi,

I need to load data from Lotus Notes. Until now, I achieved this using sql server or a csv file where I previously loaded data from Notes and later readed from SAP.

Now, I would like to do this without using an intermediate database. I think an option would be to create a db connect in bw which connect to Notes, for example, using the Notessql driver but, I have not found information ralated to this.

Can anybody help me?

Thanks in advance.

Regards.

[colm_boyle · Accepted solution]

Hi David,

can you please take a look at the following note which details that you need  "Lotus Connector for SAP R/3" to fix this issue...

691500 Lotus Support Queue (BC-CI-LSX)

Solution

Because of Support process guidelines, please contact the IBM support

directly. Please submit your problem directly at

http://www-3.ibm.com/software/support/probsub.html                  or

call your local support centre at

http://techsupport.services.ibm.com/guides/cnts_emea.html Please note,

that Lotus has discontinued the support for the "LSX for SAP R/3"

31.12.2002. For the integration of SAP R/3 and Lotus Domino, the

supported product is the "Lotus Connector for SAP R/3", including the

LCLSX  for SAP R/3, the Mail Transfer Agent and the Access to SAP

Business Workflow.

I hope this helps,

thanks,

Colm

[Former Member · Accepted solution]

Thanks Colm for your help.

I think I'm going to create an ODBC connection to Lotus Notes using SQLNotes driver and from this odbc I suppose it would be possible read data from Lotus.

Regards.

[former_member182470 · Accepted solution]

Missed my latest reply?

[former_member182470]

The backend database system is DB 400 right? Why don't you connect to that with DB Connect?

Search in google with " Connect Lotusnotes to BW" .

[Former Member]

No. The lotus database is not based on DB 400 system. In fact, it is not a relational database, it is more similat to a system with flat files....

[former_member182470]

Ohh, thanks for the clarification. But there must be some database system behind lotus notes, right? Try to find out that and see where it fits with SAP standard connectors?

I have come across this interesting link. It will give you great insight.

http://scn.sap.com/thread/382814