Re: Lotus Notes/Oracle compatiblity?

The answer is yes.

You can do it via both the Notes client and a web browser if the backend is running Domino. It works because Notes is ODBC compliant, both in reading external data in and in allowing access to data from external sources.

You have the choice of using Notes as a temporary "cache" or transferring the data straight into the Oracle database without storing it in Notes. It works because by using Notes LS:DO (LotusScript Data Object), direct access to ODBC compliant databases can be achieved.

If you use Notes as a temporary "cache" then you write the information to a Notes database and the responsibility is upon the Oracle database to come and get that information from the "cache", deleting it when it has successfully stored it in the Oracle database. Sort of like a two-phase commit. This method works for both online and mobile applications. The mobile applications work because as soon as the mobile is connected to the server replication of all inserts, updates, and deletions takes place between the server and the mobile user. As the Oracle database will be configured to read from the "cache" on the server, it gets all the mobile updates at this time too.

If you want to write to the Oracle database immediately then you have to use the LS:DO to access the Oracle database as soon as the data is entered. The data need never stored in a Notes database. This is particularly true is you are running an Intranet/Extranet/Internet site using Domino. Notes Agents running on the server can provide real time validation and data access control to any ODBC database.

Hope this has been useful

Ade Atobatele
webmaster_at_nigeria.net

Courtney wrote in message ...
>Is it possible to have a user interface supplied by Lotus Notes that
>accepts entered data, then to have an Oracle database retrieve that data
>for storage?
>
>I guess the question is: are the two compatible at that level?
>
>If anyone could respond via email, it would be *much* appreciated!
>
>
>Thanks,
>
>Courtney
>
>
>
Received on Sat Feb 28 1998 - 00:00:00 CET