Re: Pick D3 to Oracle connectivity

Hi

If the databases are on separate boxes, then the *best* way to do it (my view !!) is via a TCP/IP based client/server link. The Oracle API is well documented, and you can either use OSFI or a custom protocol (yawn - but it works) to access data.

I would advocate OSFI if you have someone who can cut the driver layer for D3 - retrieval of D3 data from Oracle is more moot - I can see a mechanism but it's awkward to cut although **quite smart** in use & I like it. (Something I talked over with Rudge Bowen *ages* ago before I joined up with Unidata / Ardent).

The mechanism involves a technique known as SPOOFING applied to TCP listening sockets - it's a way of hiding REAL databases behind interpretation layers without anyone else knowing or seeing the real format. Otherwise known as - THERE AIN'T NO-ONE HERE BUT US CHICKENS - HONEST!! All it requires is a database which supports networked file systems and a little knowledge of howe these systems work - some general & some specific..... Are you listening Andy Ludgate - you know what I mean !

Can anyone cast more light on the Oracle --> D3 side of the link as an OSFI integration alternative though?

Regards

John Jenkins

On Tue, 03 Mar 1998 21:14:51 -0600, Prashant Sahgal <psahgal_at_nojunk.mediaone.net> wrote:

>I am trying to create a real-time database link between a Pick D3 (7.0)
>database and an Oracle (7.1) database. Both are running on IBM RS/6000s.
>Has anyone done this? If so, how did you do it?
>
>My current options are:
>
>1) Write Unix flat files from both sides and create listeners/servers on
>both databases.
>
>2) Put a PC in the middle running ODBC connections to each side with a
>VB program providing the glue.
>
>3) Write a C program on the Unix side which opens both databases and
>exchanges fields.
>
>Thanks for any help you can give me.
>
>Prashant Sahgal
>psahgal_at_nojunk.mediaone.net (remove nojunk)
>
Received on Wed Mar 04 1998 - 00:00:00 CET