Re: DB2 to MySQL

Hi Doug,

Am 26.08.2024 um 18:38 schrieb DEnglander--- via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx>:

Does anyone have any references as to how to set up an RPG program that
can send DB2 data to a MySQL database on a remote server?

No, I don't - and JDBC seems to be the only viable solution, if you want to replace the Java program 1-to-1.

MySQL has no DRDA connections AFAIK (Oracle has one, MS-SQL too) - that would be too easy.

Any resources anyone has to help would be great. Can this be done in
embedded SQL somehow, or is JDBC my only option?

I would try to think outside the box - maybe without complex programs, by setting up a form of "pipeline".

1st Idea: Using a ETL solution as a "middleware"

There are some open source ETL solutions available - creating a pipeline shouldn't be so hard.

2nd Idea: Exporting and importing

Use a flat file, XML or JSON to export the data you want - and setup an import "job" on the MySQL side - this could be a simple command called by CRON, which grabs the IFS file and imports it.

3rd Idea: using DB2 as backend for MySQL

You can use DB2 tables as MySQL backend on IBM i - means, your RPG program can simply INSERT the data into a regular table, that is also available as a table in MySQL on IBM i.

If you want to offload the data, setup MySQL data replication from IBM i to the non-IBM-I MySQL server.

Just some ideas - there are (probably) better ones.

HTH
Daniel