SQL Automation

[Anonymous]

Hi

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.

Thanks

[Anonymous]

Hello,

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.

Best regards

Sabrina