Re: JDBC vs DB2 Connect

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.