SQL Automation

Anonymous — Sat, 16 Nov 2024 05:13:18 GMT

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

Re: SQL Automation

Anonymous — Thu, 25 Jul 2019 10:15:58 GMT

Hello,

Please have a look at this component:TalendHelpCenter:tMysqlRow which executes the stated SQL query on the specified MySQL database.

Let us know if it helps.

Best regards

Sabrina

topic Re: SQL Automation in Talend Studio

SQL Automation

Re: SQL Automation