Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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