ERP Integration

Article View: borland.public.cppbuilder.database.multi-tier

Article #614

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#614

From: mpowell
Date: Thu, 03 May 2001 16:03

16 lines
1727 bytes

We have an Oracle ERP database that we would like to integrate with using
MIDAS. The integration will (probably?) occur at the server level and tie
across (possibly with master/detail relationships?) to our InterBase
database.

I need to determine if this is feasible (e.g. without having to update our
IB database) by simply referencing across to the Oracle DB. If so how might
this be accomplished? Are any special drivers or other considerations
necessary to provide this degree of support from a MIDAS server application?
The most obvious consideration is the possibility of needing to have an ODBC
(dialect 3) driver available for the IB database. How good is MIDAS at
enforcing data integrity across databases (e.g. at the server level) using
master/detail relationships?

Thanks in advance!

Technical Details

Message-ID: <3af18275_1@dnews>

Path:

arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out-sjo.usenetserver.com!feed2.onemain.com!feed1.onemain.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,bff872ff95ea9d77,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-05-03 09:40:06 PST
From: "mpowell" <mike.powell@transcore.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: ERP Integration
Date: Thu, 3 May 2001 10:03:04 -0600
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 198.59.170.194
Message-ID: <3af18275_1@dnews>
X-Trace: dnews 988906101 198.59.170.194 (3 May 2001 09:08:21 -0700)
Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out-sjo.usenetserver.com!feed2.onemain.com!feed1.onemain.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews