Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-07-19 06:30 PM

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

 

Labels (2)
Labels
285 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2019-07-25 06:15 AM
Author

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

285 Views
0 Likes