Migrate data from AS400 to SQL server. TDBOutputBulkExe does not connect to AS400.

[ROpp1680418792]

TDBOutputBulkExe has the option to connect to DB2 but not to AS400.

When trying to connect with DB2 it requests 2 different jars (db2jcc_license_cisuz.jar, db2jcc_license_cu.jar) that are from mainframe and not from iSeries (AS400).

How should I connect to AS400 and bulk upload data to SQL server if it is not through TDBOutputBulkExe?

[Anonymous]

Hello,

It does not appear that there is a dedicated bulk component for AS400.

You could use Talend to generate the load file, and then invoke the IBM tool using tSystem component: https://www.ibm.com/docs/en/spss-modeler/saas?topic=node-bulk-loader-programming

https://help.talend.com/r/en-US/8.0/system/tsystem

Feel free to let us know if it helps.

Best regards

Sabrina