Paul,

We have an order management system that makes calls to the AS/400 in two
ways.  We make direct calls for inventory, vendors, etc., anything that is
a direct data retrieval.  This is done with calls from within the order
application, the data is not stored into a Notes db.  We also use one of
the Domino Connectors any time we need processing done by the ERP system,
pricing, credit, etc.  The direct calls are ofcourse faster as there are
less steps in the process.

We also have applications that pull data from the ERP into Domino
databases, however, these are for reporting use, Sales History, Customers,
etc.  I would not look at moving data into a Domino db for a
live/interactive application as being a best case solution.

Brian Mangels
Account Executive
X1 Solutions
www.x1solutions.com
Office 229 249-0921
Cell 678 522-0921
Fax 253 541-9007



                    "Paul Nelson"
                    <p_nelson-br@pop.i        To:     <domino400@midrange.com>
                    nil.com>                  cc:
                    Sent by:                  Subject:     Need advice
                    domino400-admin@mi
                    drange.com


                    06/25/2002 03:53
                    PM
                    Please respond to
                    domino400





This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I've got a client who is in the process of developing a purchasing
application in Domino. The discussion they are now having relates to
performance.

Their RPG programmer thinks that they will get acceptable performance by
doing lookups of vendors, G/L account numbers, etc., by passing these
parameters to the accounting system machine and getting responses back.

The Domino programmer is saying that they need to have "duplicate"
databases on the accounting system machine and the Domino machine, and then
just keep them in synch.

When these master files are updated on the accounting system machine, a
program can be written to push this data into work files that can then be
retrieved by the Domino machine using an agent that runs on a frequent
basis.

I'd be interested to hear about similar experiences both ways.

Thanks,

Paul Nelson
Braxton-Reed, Inc.
630-327-8665 Cell
708-923-7354 Home
pnelson@braxton-reed.com
--

_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list
To post a message email: DOMINO400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/domino400
or email: DOMINO400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.







As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.