>Haven't tried it myself, but you may be able to connect the DB2 database >to your PostgreSQL cluster using this FDW module: >https://github.com/wolfgangbrandl/db2_fdw >Looks like db2_fdw is DB2 LUW only though, so you might be out of luck >if your DB2 is on IBM i (or z ;-) As the thread indicates, I am using DB2 Linux. I used Carto one with ODBC and it is just not production ready. Found two bugs within days of testing. I have created bugs in the github. >Then you could just use INSERT INTO ... SELECT statements to do the ETL >process with the necessary type conversions and whatnot. I am currently using Unix pipes to export data from DB2 and concurrently load it to PG via COPY. It saves nearly half the time of exporting first to file and then loading it.
