Very Computer

Can anyone give any advise on how to go about performing a one off import
from a Lotus Notes database into a SQL server database for us in a product
we're developing?

I have limited knowledge of the inner workings of Lotus Notes/Domino so I'm
not aware of what kind of export facilities it has.

What I was thinking of is some kind of export facility that sticks the data
"as is" into an intermediate format (or maybe straight into a SQL server
DB). We will then write an import script/program to take this intermediate
format and convert it into the format that our program uses.

Thanks, Rob.

AFAIK - Lotus created an ODBC driver for Notes that kind of stinks for
updating Notes db's using ODBC, but is ok for reading.  You may want to look
at Lotus' web site for it.
--
HTH,
David Satz
Principal Software Engineer
Hyperion Solutions
->Using SQL Server 7.0 SP3/6.5 SP5a/Cold Fusion 4.5.1 SP2/VSS
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------

Quote:> Can anyone give any advise on how to go about performing a one off import
> from a Lotus Notes database into a SQL server database for us in a product
> we're developing?

> I have limited knowledge of the inner workings of Lotus Notes/Domino so
I'm
> not aware of what kind of export facilities it has.

> What I was thinking of is some kind of export facility that sticks the
data
> "as is" into an intermediate format (or maybe straight into a SQL server
> DB). We will then write an import script/program to take this intermediate
> format and convert it into the format that our program uses.

> Thanks, Rob.

Quote:> AFAIK - Lotus created an ODBC driver for Notes that kind of stinks for
> updating Notes db's using ODBC, but is ok for reading.  You may want to
look
> at Lotus' web site for it.

Ahh yes - I found it. Notes SQL ODBC driver. Unfortunately, this kind of
assumes you have Lotus Domino Server which we don't....

But fortunately, Lotus offer a 90 day trial which is downloading now...

This does look like the best solution as we can use our normal tools (even
our own app) to suck the data out of the Notes database directly into SQL
server in the right format.

Thanks, Rob.

Quote:> updating Notes db's using ODBC, but is ok for reading.  You may want to

look

And fortunately, we only want to read it.

Cheers, Rob.

Otherwise, there are people here that use LEI -
http://www.lotus.com/homepage.nsf/(search)/search?OpenDocument&lei - to move
data from Notes to SQL.

Quote:> > AFAIK - Lotus created an ODBC driver for Notes that kind of stinks for
> > updating Notes db's using ODBC, but is ok for reading.  You may want to
> look
> > at Lotus' web site for it.

> Ahh yes - I found it. Notes SQL ODBC driver. Unfortunately, this kind of
> assumes you have Lotus Domino Server which we don't....

> But fortunately, Lotus offer a 90 day trial which is downloading now...

> This does look like the best solution as we can use our normal tools (even
> our own app) to suck the data out of the Notes database directly into SQL
> server in the right format.

> Thanks, Rob.