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" <email@example.com To: <firstname.lastname@example.org> 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 email@example.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: DOMINO400firstname.lastname@example.org 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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.