MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

RE: replicating an I-series home-grown application to a .net platform



fixed

1.) Why are you replicating data ? Why not use it live ? If replicating for read-only keep it as dumbed down as possible.

2.) Suited for the old days :-)

Feel free to give Bill Whalen a call. He can set us up to talk with your .Net team if there's any desire.

We do a ton of .Net and iSeries integration work in our products and for customization.

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
------------------------------

message: 5
date: Fri, 5 Oct 2012 14:25:37 +0000
from: "Stone, Joel" <Joel.Stone@xxxxxxxxxx>
subject: replicating an I-series home-grown application to a .net
platform

My company is replicating our I-series home-grown application to a .net platform for read-only. This .net app will provide customers with a typical web-based myAccount view as seen on many websites.

I have two questions for this forum:


1) For the read-only mirrored version on .net, does it make sense to have referential integrity (RI) constraints on file relationships? Either from a purist database design standpoint or from a common business rules standpoint? It seems to me that one HAS to assume that the source app has R-I that is intact, and it seems to be asking for trouble and headaches to try to enforce RI on a mirrored system that is read-only. This will require file loads and updates in a certain sequence, which could be problematic IMO.


2) Do other companies try to replicate an app onto another platform in almost real-time? It seems that it would be SOoooo much simpler to read the Iseries DB directly. Is this replication a common practice today? Or is it more suited to the 1990's?







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact