PL-SQL postgres

[Anonymous]

Hello everybody,

I just get started with Talend as ETL, I’m on a new project where I need to execute a PL-SQL code on postgres

I don’t know which component I can use for that (I tried tPostgresqlRow but it did not work )! Could anyone help me!

Thank you

[manodwhb · Accepted solution]

you should use tPostgresqlSP coustom component or tJDBCSP.

[Anonymous]

Thank you for your response
It did not work for me, I did not find the component tPostgresqlSP and tJDBCSP could not find the class and I don t know why!
I solved the problem by using a trigger
But I need to know how we could use Stored procedure in Talend
Do you have any examples!
Thank you so much again

[manodwhb]

which version of Talend are you using?

[Anonymous]

Talend Open Studio for Data Integration 6.4

[Anonymous]

Hello,

Are you able to find tJDBCSP component in your studio? So far, there is no an official tPostgresqlSP component from talend.

Best regards

Sabrina

[manodwhb]

@Hanine1 @xdshi Since I was using TOS DI 6.3.1,there i could find the tJDBCSP component.please find below screenshoot.

[Anonymous]

First of all, thank you so much for replying 

It s tPostgresqlSP that I did not find 

For tJDBCSP it gives me an error such as it did not find the class

[manodwhb]

I belive some how your missing jars.

[Anonymous]

What can I add as jars !