Re: syncing data between Iseries and SQL

Hello Daniel,

Am 14.04.2025 um 20:51 schrieb Daniel Gross <daniel@xxxxxxxx>:

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

Can you elaborate, please?

I'm only aware of MS Host Integration Server providing a solution to access SQL Server from IBM i through DRDA, but I could not to get it to run with 7.2 back in the day. Failed early with the APPN connection over EE not being established with incomprehensible error messages. I have a dim memory that according to documentation it is not very flexible, because you can shove data back and forth from/to MS SQL only through stored procedures in MS SQL being called from IBM i.

Then, there is a feature in MS SQL Server called "linked server", where you install the IBM i ODBC driver on the MS SQL server machine and access data from IBM i through MS SQL. Have only second hand information about that. Is said to work okay, but the configuration effort on MS SQL is substantial. As far as I've understood, this directly allows e. g. JOINs over tables located on the remote machine.

Third is the opposite, ARDGate from Dieter Bender. Install the desired RDBMS' JDBC driver on IBM i, and you can access data on a remote machine.

None of them provide syncing services out of the box which the OP asked for, though.

:wq! PoC