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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Difference between tMysqlBulkexec and tMysqlOutputBulkExec

Hi Team

 

Can you please explain what is the difference between 

tMysqlBulkexec  and tMysqlOutputBulkExec.

 

Thanks in Advance

 

Deepthi

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hello,

The tMysqlOutputBulk and tMysqlBulkExec components are used together in a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT statement used to feed a database.

These two steps are fused together in the tMysqlOutputBulkExec component, detailed in a separate section. The advantage of using two separate steps is that the data can be transformed before it is loaded in the database.

Let us know if it is OK with you.

Best regards

Sabrina

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hello,

The tMysqlOutputBulk and tMysqlBulkExec components are used together in a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT statement used to feed a database.

These two steps are fused together in the tMysqlOutputBulkExec component, detailed in a separate section. The advantage of using two separate steps is that the data can be transformed before it is loaded in the database.

Let us know if it is OK with you.

Best regards

Sabrina

Anonymous
Not applicable
Author

Hello,

Feel free to let us know if it is OK with you and post your issue here.

Best regards

Sabrina