tMySQLOutput Update Table

One Star

tMySQLOutput Update Table

I haven't been able to find any good examples of how to update a table using tMySQLOutput.
I have a database of addresses. I am trying to update the data with a Latitude and Longitude field.
Source CSV file has UniqueID, Latitude, Longitude.
Destination MySQL table has InternalID (auto-increment value), UniqueID, Latitude, Longitude.
In this initial load, the UniqueID is truly unique. In subsequent loads, the update will need to consider logically deleted values (which is why UniqueID is not the auto-increment value) for when a customer's address was changed.
My flow goes from tFileInputDelimited -> tMap -> tMySQLOutput
tMySQLOutput has "Action on data" set to "Update"
In Advanced Settings, "Use field options" is checked and the UniqueID is set as the UpdateKey.
It processes all the records, but gets hung up when trying to commit to the database. It just hangs, doesn't freeze, and I have to Kill the process.
Any help on how to do the update is appreciated.
Four Stars

Re: tMySQLOutput Update Table

Hi,
Have you checked following link?
https://help.talend.com/search/all?query=tMysqlOutput&content-lang=en
Can you use tPreJob-->tMySQLConnection (enable autocommit)
YourJob-->tlogrow (to verify output if coming before and after the tmysqlOutput (select existing connection checkbox))
Check the records if updated...
Keep very few records in csv file and check the output, this may give you some idea...
Hope this will help you to identify problem with your job...
Thanks
Vaibhav

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now