×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hi hoteltravelfundotcom,
We use Scott Klement's JDBCR4 service program.
http://www.scottklement.com/presentations/External%20Databases%20from%20RPG.pdf
I've actually written a wrapper around it to do a number of things (log, report, embed error catching logic into the incoming SQL to run). Scott's utility has really been indispensable and has really opened up many possibilities.
Why do we return data to SQL Server? The part of our business that provides web-based tools to our clients primarily uses SQL Server as the database so we need to pass along any pertinent information to the SQL Server database for our clients. There are parts of our web system that directly hits the Power system, but it's not common.
-Kurt
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hoteltravelfundotcom
Sent: Wednesday, May 29, 2013 7:38 AM
To: Midrange Systems Technical Discussion
Subject: Performance question and SQL SERVER
Has anyone ever ported AS400 data to a SQL Server? Why would you do that, because of the company having some extra servers that can be used as either Replication, or to use for reporting tools based in Windows.
If so, are there tools or products for this or something one can do on their own.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
