Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ROpp1680418792
Contributor
Contributor

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

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?

Labels (1)
  • Other

1 Reply
Anonymous
Not applicable

Hello,

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

069U1000001w9jvIAA.pngYou 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