Mike,
Our RPG2SQL Integrator software could be used to gather or push data from/to the SQL Server from an RPG program.
This would provide real-time access to the SQL Server from an RPG batch or interactive job.
Food for thought.
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: 1
date: Wed, 25 May 2011 11:14:35 -0500
from: Mike Wills <mike@xxxxxxxxxxxx>
subject: [WEB400] Getting Data From Intranet (i) to Internet (MS SQL
Server)
Okay, here is an interesting one and I am hoping someone has a better idea of where to take this.
We will be writing an eCommerce application on the internet in ASP.NET. We have are a local government org that sells licenses, permits, and of course has utility bills. We currently take utility bills; but because of the timeframe of getting it live, we duplicated an old method of completely rebuilding the internet database nightly and collecting the transactions nightly from a dump from the SQL server. I would like to get rid of many of the layers of potential problems (FTP, multiple servers, multiple dump jobs) and go as directly from the i to MS SQL as possible. MS SQL cannot see the i, but the i can see the MS SQL server.
We will be collecting data from many tables and getting that customer data on the SQL server. My idea is to put a trigger on each table we want to track and log all transactions into one table. From there, have a .NET application poll this table and process all new transactions. This table would have a system key (to determine the set of tables), the system's primary key, and what action was performed (add, change, delete).
On the other side, we'll have the transaction table that holds all of the payments made. I am unsure about any other data that needs to be processed.
I realize this would probably be a prefect use of web services on the i. But we would prefer to not punch a hole through the firewall from the internet side (DMZ) to the intranet side if possible. Or can this be done securely and avoid the possible problems with holes into our internal network?
Any thoughts?
--
Mike Wills
http://mikewills.me
As an Amazon Associate we earn from qualifying purchases.