https://community.qlik.com/t5/Talend-Studio/Migrate-data-from-AS400-to-SQL-server-TDBOutputBulkExe-does-not/m-p/2366839#M130278 <P>TDBOutputBulkExe has the option to connect to DB2 but not to AS400.</P><P>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).</P><P>How should I connect to AS400 and bulk upload data to SQL server if it is not through TDBOutputBulkExe?</P> Fri, 15 Nov 2024 21:07:29 GMT ROpp1680418792 2024-11-15T21:07:29Z https://community.qlik.com/t5/Talend-Studio/Migrate-data-from-AS400-to-SQL-server-TDBOutputBulkExe-does-not/m-p/2366839#M130278 <P>TDBOutputBulkExe has the option to connect to DB2 but not to AS400.</P><P>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).</P><P>How should I connect to AS400 and bulk upload data to SQL server if it is not through TDBOutputBulkExe?</P> Fri, 15 Nov 2024 21:07:29 GMT https://community.qlik.com/t5/Talend-Studio/Migrate-data-from-AS400-to-SQL-server-TDBOutputBulkExe-does-not/m-p/2366839#M130278 ROpp1680418792 2024-11-15T21:07:29Z https://community.qlik.com/t5/Talend-Studio/Migrate-data-from-AS400-to-SQL-server-TDBOutputBulkExe-does-not/m-p/2366840#M130279 <P>Hello,</P><P>It does not appear that there is a dedicated bulk component for AS400.</P><P><span class="lia-inline-image-display-wrapper" image-alt="069U1000001w9jvIAA.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156168i6AAFBA246E2B9FAD/image-size/large?v=v2&amp;px=999" role="button" title="069U1000001w9jvIAA.png" alt="069U1000001w9jvIAA.png" /></span>You could use Talend to generate the load file, and then invoke the IBM tool using tSystem component:&nbsp;<A href="https://www.ibm.com/docs/en/spss-modeler/saas?topic=node-bulk-loader-programming" alt="https://www.ibm.com/docs/en/spss-modeler/saas?topic=node-bulk-loader-programming" target="_blank">https://www.ibm.com/docs/en/spss-modeler/saas?topic=node-bulk-loader-programming</A></P><P><A href="https://help.talend.com/r/en-US/8.0/system/tsystem" alt="https://help.talend.com/r/en-US/8.0/system/tsystem" target="_blank">https://help.talend.com/r/en-US/8.0/system/tsystem</A></P><P>Feel free to let us know if it helps.</P><P>Best regards</P><P>Sabrina</P> Fri, 12 Jan 2024 04:15:57 GMT https://community.qlik.com/t5/Talend-Studio/Migrate-data-from-AS400-to-SQL-server-TDBOutputBulkExe-does-not/m-p/2366840#M130279 Anonymous 2024-01-12T04:15:57Z