Hi all,
Two years ago I had the same problem. I had a Lotus Notes DB which I wanted
to
import to a new --enterprise level-- Oracle host.
I tried Notes Pump, ODBCs, direct API... The only way I found effective and
the one I used was this one:
1.- Create the normalized table structure you want in your database
(remember that Notes is doc based, not relational).
2.- Using LotusScript, export the data following the tables structure.
3.- Create the PL/SQL to read the files and insert them into the database
(in my case, I work with Oracle).
This process is hard and long, but it runs.
Just my two cents,
Albert.
-----Mensaje original-----
De: Rif Kiamil [mailto:[EMAIL PROTECTED]]
Enviado el: jueves, 17 de mayo de 2001 19:10
Para: CF-Talk
Asunto: RE: CF-Notes database connection
If there is a OBDC driver for Notes then you can uses MD SQL DTS to import
the data into MS SQL
Rif
-----Original Message-----
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2001 20:00
To: CF-Talk
Subject: RE: CF-Notes database connection
I haven't delt w/ Domino 5. I would think that ya should be able too...
But dammed if I know how, and the general consensus seems to be
problematic.
At 03:47 PM 05/17/2001 +0100, you wrote:
>Surely with Domino 5 and it's flashy wizzy web side you must be able to
>build a web intermediary between Notes an CF.
>
>-----Original Message-----
>From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
>Sent: 17 May 2001 17:43
>To: CF-Talk
>Subject: Re: CF-Notes database connection
>
>
>
> Well, in Notes you can use LotusScript. Out of Notes... I'm not
sure.
> I had a neat little application working that allowed users to register
>from the web. It created their user accounts in a secondary name address
>book, and added them into the valid groups to the primary address book. I
>think that Lotus provided a template similar to that.
>
>At 07:43 AM 05/17/2001 -0500, you wrote:
> >I know I came in at the tale end of this thread, but can you tell me if
> >there's any scripting language that will write to NPAB? Note that the
same
> >scripting language does not need the capability to read from Any sort of
> >database.
> >
> >Thanks,
> >Tony Hicks
> >----- Original Message -----
> >From: <[EMAIL PROTECTED]>
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Sent: Thursday, May 17, 2001 7:28 AM
> >Subject: CF-Notes database connection
> >
> >
> > >
> > >
> > > Thanks to everyone who responded. It is disappointing that no one has
>had
> >any
> > > success in doing what we are needing to do, which is exchanging data
> >between
> > > Notes and our SQL Server database. We just wanted to get names,
> >addresses,
> > > phone numbers, etc. out of our db and into the Notes Personal Address
>Book
> >for
> > > our sales people to download into their Palms. Sounds like a simple
> >thing, but
> > > I guess we'll have to wait for Bill to buy and kill Notes before we
can
> >get this
> > > app written.
> > >
> > > If anyone has any other ideas, we'd like to hear them. BTW, I did
hear
> >about
> > > ZMerge and have downloaded an eval. If it works I'll repost and let
> >everyone
> > > know about it.
> > >
> > > Thanks again,
> > >
> > > Loyd Campbell
> > >
> > > Bank One International Corp.
> > >
> > >
> > >
> > > Archives: http://www.mail-archive.com/[email protected]/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > >
> >
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
