topic Execute .sql file in talend in Talend Studio

Execute .sql file in talend

Anonymous — Sat, 16 Nov 2024 04:01:16 GMT

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........

Re: Execute .sql file in talend

Anonymous — Tue, 26 Nov 2019 07:55:22 GMT

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

Regards
Shong

Re: Execute .sql file in talend

Anonymous — Tue, 26 Nov 2019 10:14:44 GMT

hi,

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

Thanks

Re: Execute .sql file in talend

PhilHibbs — Tue, 26 Nov 2019 10:41:26 GMT

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.

Re: Execute .sql file in talend

Anonymous — Wed, 27 Nov 2019 03:09:56 GMT

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"

Re: Execute .sql file in talend

PhilHibbs — Wed, 27 Nov 2019 09:44:57 GMT

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!"

Re: Execute .sql file in talend

Anonymous — Wed, 27 Nov 2019 12:36:50 GMT

hi shong,

Thanks now it is working