Re: syncing data between Iseries and SQL -- MIDRANGE-L

Subject: Re: syncing data between Iseries and SQL
From: Daniel Gross <daniel@xxxxxxxx>
Date: Mon, 14 Apr 2025 20:51:05 +0200
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

Hi Gavin,

Am 14.04.2025 um 20:37 schrieb Gavin Inman <midrangelist@xxxxxxxxxxxxxx>:

We currently use a solution of Qlik (formerly Attunity) to real time replicate data between Iseries DB2 and SQL.

With "SQL" you mean Microsoft SQL-Server?

If yes, there is an DRDA option for SQL-Server that allows "native" access to IBM i tables from SQL-Server.

We think we've reached a point where we're outgrowing this solution.

In what way? Doesn't it perform well? Does it only go into one direction?

We're looking to see if there are any alternatives by IBM or another vendor that anyone knows of or has experience with.

The biggest question is still - why is the replication necessary anyway?

Kind regards,
Daniel

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: syncing data between Iseries and SQL , Patrik Schindler

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