I am mainly interested in workflow automation. I 100s of sql scripts that move data between tables within the same database and other databases. I am tired of babysitting them in MYsqlworkbench and using other tools for analysis along the way. I know the order they need to run and I have the sql already written.
I feel like I am spending a bunch of time learning the OpenStudio GUI and not focusing on right issues first, which are simply automating my queries then playing with some of the other tools.
Please have a look at this component:TalendHelpCenter:tMysqlRow which executes the stated SQL query on the specified MySQL database.
Here is a related topic:https://community.talend.com/t5/Archive/resolved-Execute-simple-SQL-script/m-p/173374
Let us know if it helps.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Read about some useful Context Variable ideas