Sqloutput ... HELP!

Four Stars

Sqloutput ... HELP!

Hi all, I am using Talend to input my records in my SQL although the operation is successful it does not insert any record into the specified MySQL table. Someone enlighten me please! 

Sixteen Stars TRF
Sixteen Stars

Re: Sqloutput ... HELP!

Hi,
Are you using autocommit or explicit tMySQLCommit? Else your transaction will not be commited and you will not retrieve the records in the target database.

TRF
Four Stars

Re: Sqloutput ... HELP!



Sixteen Stars TRF
Sixteen Stars

Re: Sqloutput ... HELP!

You can also catch the rejected rows from tMySQLOutput. Refer to the documentation to learn how to.

TRF

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend Cloud Developer Series – Defining Metadata

This video focuses on different methods of adding metadata to a job in Talend Cloud

Watch Now

Talend Cloud Developer Series – Updating Context Variables

This video will show you how to add context parameters to a job in Talend Cloud

Watch Now

Talend Cloud Developer Series – Deploying First Job to Cloud

This video will show you how to run a job in Studio and then publish that job to Talend Cloud

Watch Now