× 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 Mike

Our solution does require a middleware PC - so does IBM's InfoSphere Federation Server, by the way - used to be WebSphere - yikes!! More name changes!

I'm inclined against pull methodologies, if possible - I prefer to have whatever modifies the data, push the data wherever it needs to be. This is not because of our product, RPG2SQL, but in general. JMHO

Vern

On 8/23/2011 10:41 AM, Mike Wills wrote:
There is a vendor that can do this, but it appears like it requires
another PC in the mix, they can correct me if I am wrong. Personally,
I like to have as few steps as possible to what needs to be done. The
JDBC solution works.

We usually just write a middle-ware .NET app that pulls data from the
i and puts it on the SQL Server. But we have the .NET experience to do
that.

--
Mike Wills
http://mikewills.me



On Tue, Aug 23, 2011 at 10:20 AM, Michael Ryan<michaelrtr@xxxxxxxxx> wrote:
I hear a verndor coming...

On Tue, Aug 23, 2011 at 10:58 AM, Gary Thompson<GThompson@xxxxxxxxxxx> wrote:
I am working on a project where we need to read and write data between our
System i
and a 3rd party MS SQL Server database.

Data volume will not be large, but will be frequent and must be very
reliable and
respond within a few seconds.

An additional concern is ease of use for legacy RPG skill sets.

I am currently setting up to test Scott Klement's JDBCR4 service progarm
and
Jon Juracich's example that accesses MS SQL Server.

I welcome any comments that help us select the better solution, or
that suggest another.
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2024 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.