Execute .sql file in talend

[Anonymous]

How to execute .sql file in talend when i run a job?

for example:

    If i run a job in talend the file(.sql) which i  placed in desktop should be triggered and it should affect in  mysql database  

   The .sql file may contain any qurey like create table or update or insert etc........

[Anonymous]

Hi
You can use a tsystem to execute a command to execute the .sql file like you do it from CMD.

Regards
Shong

[Anonymous]

hi,

  can you please explain me how we can do it in tsystem component

Thanks

[PhilHibbs]

You should be able to do it by reading the file into a string with a tFileInputRaw component, write the contents into the globalMap, and use the globalMap entry as the Query in a tMysqlRow component.

[Anonymous · Accepted solution]

Hi 

Set the Use Home Directory to <Mysql installation directory/bin>, and execute the command like

"cmd /c mysql -uUsername -pPassword -DDatabaseName <D:/files/in.sql"

[PhilHibbs]

I can just see the expression on our security manager's face. "That's a password... in plain text... in a Talend job... you're fired!"

[Anonymous]

hi shong,

  Thanks now it is working