Re: lotus notes

[Ray Ontko <rayo@ONTKO.COM>]

Howdy,

Thank you all for your response to my Lotus Notes question.
I also got a private reply which the author agreed to let me
repost here:

> Ray,
>
> 1.   There is an ODBC driver for Lotus Notes available at the   Lotus Web
> Site  http://www.lotus.com. We do not use it at this time.  It is free.  I
> would think that you could use SQR to join Oracle and Notes via separate
> queries
>
> 2.   What we are doing is using a product called Replic-Action from
> http://www.casahl.com  that sychronizes Data between Notes and Oracle using
> ODBC.  This product allows us full two-way synchronization of data but is
> pretty pricey. (10K).
>
> 3.   Within Lotus Notes you can embed ODBC to bring Oracle into Notes but I
> have not worked with that at all.
>
> 4.   Other interesting and cheaper solutions may be using Lotus Approach
> with both Oracle and Notes.
>
> Hope this helps.
>
> -Ben Burkland
> BBurklan@erim-int.com
>
> >Howdy,
> >
> >Is anyone out there using SQR as a reporting tool for
> >a Lotus Notes database?  If so, how do you do it?
> >Can SQR (with ODBC) be used directly against a Lotus
> >Notes database?  Does Lotus have an export function that
> >we could use to readily load the data into an Oracle
> >database?
> >
> >Ray

Ray
----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Time for a new signature line."
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/