Execute postgress function from Talend

Four Stars

Execute postgress function from Talend

Do we have component to call postgress function?
Six Stars

Re: Execute postgress function from Talend

Hello,

 

Unfortunatelyn there is no component for postgres like "tMySqlSP" (Stored Procedure).

But you can call your procedure via a "tPostgresqlRow".

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Moderator

Re: Execute postgress function from Talend

Hello,

So far, there is no official tPostgresqlSP component in Talend. Feel free to create a new feature on talend bug tracker.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: Execute postgress function from Talend

Hi,

 

in which way I call the procedure inside tPostgresqlRow?

Moderator

Re: Execute postgress function from Talend

Hello,

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

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.