RE: Synchronize SQL Server Tables from AS400

We use Scott Klement's JDBCR4 to connect to SQL Server, which allows you to use JDBC from RPGLE to access SQL Server. We push data to SQL Server both real-time (async) and at scheduled intervals. For the real-time, we use update triggers that write entries to a data queue, and another program monitors that data queue and does the I/O to SQL Server. The scheduled exports are just scheduled jobs that either add to, or replace, existing data.

This assume you don't actually have an AS400. If you do, I can't say what, if any, of this would work on such ancient hardware.



-----Original Message-----
From: john art [mailto:jhon_art@xxxxxxxxxxx]
Sent: Friday, May 05, 2017 2:20 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Synchronize SQL Server Tables from AS400

Hi all


In our Ibm i we have some table that should be replicated/syncronized to our SQL server ; we are at v6r1.
Can some one help us to find some solution ? any suggestion would be greatly appreciated.
Keep in mind that
1- only some colunms / fiels should replicated (Db2 Sql table are not specular)
2- we are looking for free solution or something to write in home

Thanks