Re: Replication to SQL

SQL Server itself has SSIS, which can do change tracking and replication from a remote server (the IBM i in this case). Very powerful, usually wants TIMESTAMP_LAST_CHANGED column but supposedly can be set up to handle things if you don't have that on an IBM i table/file. Recommended by my colleague here to set up an SSIS task for each table.

On 8/11/2015 8:40 AM, Kirk Goins wrote:

To clarify... I need a way that when record in physical file on the iSeries
is changed, created deleted... it is immediately sent to SQL Server.

On Tue, Aug 11, 2015 at 6:21 AM, Andrew Lopez (SXS US) <
Andrew.Lopez@xxxxxxxxxxxxxxxxxx> wrote:

Anyone aware of a product that will 'replicate' data as it is changed

to a SQL DB much like HA software like iTERA or MIMIX does between iSeries?

I'm not sure from that description what the destination is: another SQL
DB or an iSeries. Either way, Magic xpi is an option (
http://www.magicsoftware.com/magic-xpi-integration-platform).

We recently implemented this for a Salesforce/JD Edwards integration and
couldn't be happier.

_____________________________________________________________________
Spirax-Sarco Engineering Plc. This e-mail has been scanned for viruses by
Verizon Business Internet Managed Scanning Services - powered by
MessageLabs. For further information visit
http://www.verizonbusiness.com/uk
--
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.