Execute postgress function from Talend

[Anonymous]

Do we have component to call postgress function?

[Théo_Cap]

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.

[Anonymous]

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

[Anonymous]

Hi,

in which way I call the procedure inside tPostgresqlRow?

[Anonymous]

Hello,

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

Best regards

Sabrina