SQL Automation

Highlighted
Four Stars

SQL Automation

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

 

Tags (2)
Moderator

Re: SQL Automation

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Talend Studio Improvements for API Services

Take a look at the Talend Studio improvements for API Services

Watch Now

Data Integration Success Stories

Take a look at some Data Integration success stories

Read