topic Re: How to call stored Procedure /Function from Talend job ? in Talend Studio

How to call stored Procedure /Function from Talend job ?

Anonymous — Mon, 06 Mar 2017 20:47:05 GMT

In Talend Job how to call stored Procedure or Function ?

Re: How to call stored Procedure /Function from Talend job ?

vapukov — Mon, 06 Mar 2017 21:09:50 GMT

You can use special component for this tSP - change for proper, as example - https://help.talend.com/search/all?query=tOracleSP&content-lang=en
or as usual - from SQL command

Re: How to call stored Procedure /Function from Talend job ?

Anonymous — Mon, 06 Mar 2017 21:52:33 GMT

Thank you very much. The link for document is very helpful -- Thanks again

Re: How to call stored Procedure /Function from Talend job ?

Anonymous — Tue, 07 Mar 2017 20:15:59 GMT

Thank you very much vapukov, Unfortunately, we are using Postgress sql as our db-- Is there any documentation or any other way we can call Functions /SP from Postgress SQL db ?-- Thanks In advance

Re: How to call stored Procedure /Function from Talend job ?

vapukov — Tue, 07 Mar 2017 20:24:54 GMT

Thank you very much vapukov, Unfortunately, we are using Postgress sql as our db-- Is there any documentation or any other way we can call Functions /SP from Postgress SQL db ?-- Thanks In advance

You can use tPostgresqlRow for call any SQL code, do it same as PostgreSQL console - plain SQL code

Re: How to call stored Procedure /Function from Talend job ?

Anonymous — Tue, 07 Mar 2017 20:32:20 GMT

So you are saying Past Function in Query area of tPostgresqlROW_1 ?