How work with non Lotus Notes databases?

HCL Domino Domino Forum
1

We have customers with different non Notes databases. Is there same “universal” way how to work with them? (read, may be write access)

2

Subject: you’re extremely vague

Do you mean relational databases? Lotus provides their own branded versions of DataDirect ODBC drivers, plus two different data access libraries (LS:DO and LC LSX). You can use other database access layers, as well, such as native DB2, SQL Server or Oracle libraries, JDBC, OLE DB, or even plain text links.

If you can tell us what you’re actually trying to connect to and what you hope to achieve when you do, maybe someone could help. :slight_smile:

3

Subject: some comparison?

At this moment we need connect to SQL, MySQL, DB2 and several exotic databases. As you wrote - there are many technologies or utilities (ODBS, JDBS, LEI, DECS, web services?, DB2 Connect etc.). Do you know about some comparison with criteria like:- direction of data exchange (from/to/both Lotus)

  • based on server/desktop

  • cost

  • real-time / batch oriented

  • with transactions (ROLLBACK)

  • encryption

  • authentication

  • platforms

  • speed

  • availability (view, document, prompts-dialogs)

  • data type (text, XML, binary)

  • perspective / obsolete (especially from IBM’s strategy point of view)

  • etc. :slight_smile: