https://community.qlik.com/t5/Talend-Studio/Talend-Auto-commit-for-MySql-Connections/m-p/2277652#M53357 Hi <BR />Without using an existing connection, the data will be commit automatically every N rows, this parameter can be configured in the advanced panel of tMysqlOutput. <BR />If you want to use an existing connection, you should use a tMysqlconnection to create a DB connection and use tMysqlCommit to commit the changes. <BR />Regards <BR />Shong Wed, 19 Oct 2016 03:44:24 GMT Anonymous 2016-10-19T03:44:24Z https://community.qlik.com/t5/Talend-Studio/Talend-Auto-commit-for-MySql-Connections/m-p/2277651#M53356 Hi,&nbsp; <BR />I would like to know how i can commit after loading data into a DB. <BR />Currently I am loading data from a file to MySql but after the data load the data is not committing. <BR />I have used mySqlCOmmit component but the Component List is empty with no values.&nbsp; <BR />Thanks &amp; Regards, <BR />Srivignesh KN Wed, 19 Oct 2016 00:50:07 GMT https://community.qlik.com/t5/Talend-Studio/Talend-Auto-commit-for-MySql-Connections/m-p/2277651#M53356 Anonymous 2016-10-19T00:50:07Z https://community.qlik.com/t5/Talend-Studio/Talend-Auto-commit-for-MySql-Connections/m-p/2277652#M53357 Hi <BR />Without using an existing connection, the data will be commit automatically every N rows, this parameter can be configured in the advanced panel of tMysqlOutput. <BR />If you want to use an existing connection, you should use a tMysqlconnection to create a DB connection and use tMysqlCommit to commit the changes. <BR />Regards <BR />Shong Wed, 19 Oct 2016 03:44:24 GMT https://community.qlik.com/t5/Talend-Studio/Talend-Auto-commit-for-MySql-Connections/m-p/2277652#M53357 Anonymous 2016-10-19T03:44:24Z