topic Re: creating procedure in mysql in Talend Studio

creating procedure in mysql

Anonymous — Thu, 03 Sep 2015 20:47:02 GMT

Hello guys!
Could you please help me to figure out if it's possible or not to create stored procedure within a Talend Job? and i am using MySQL server as back end ,in my job i used tsqlscriptparser component is iterated to tmysqlrow component and i fail to create stored procedure in MySQL DB,please help me, I'll be very grateful for an example.
Thank you a lot in advance!!!

Re: creating procedure in mysql

Anonymous — Fri, 04 Sep 2015 08:23:16 GMT

hi,
create strored procedure it's not the job of Talend (even if you can by using mysqlRow)
https://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
But Talend can easely use them :
https://help.talend.com/search/all?query=Calling+a+stored+procedure+or+function&content-lang=en
example on Oracle DB but the same for Mysql
hope it helps
regards
laurent
ps : why do you say : " i fail to create stored procedure in MySQL DB" ??
what do you mean ?

Re: creating procedure in mysql

Anonymous — Fri, 04 Sep 2015 19:01:06 GMT

Hey Thanks for the reply,
I have writen Mysql statement script that create procedure i want to know which component should i use in talend.

Re: creating procedure in mysql

Anonymous — Mon, 07 Sep 2015 09:13:25 GMT

mySqlSP (as Stored Procedure)
https://help.talend.com/search/all?query=tMysqlSP&content-lang=en
regards