topic Re: PL-SQL postgres in Talend Studio

PL-SQL postgres

Anonymous — Mon, 12 Mar 2018 10:37:59 GMT

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

Re: PL-SQL postgres

manodwhb — Tue, 13 Mar 2018 05:33:13 GMT

you should use tPostgresqlSP coustom component or tJDBCSP.

Re: PL-SQL postgres

Anonymous — Sat, 17 Mar 2018 22:54:50 GMT

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

Re: PL-SQL postgres

manodwhb — Mon, 19 Mar 2018 07:05:05 GMT

which version of Talend are you using?

Re: PL-SQL postgres

Anonymous — Mon, 19 Mar 2018 08:36:14 GMT

Talend Open Studio for Data Integration 6.4

Re: PL-SQL postgres

Anonymous — Tue, 20 Mar 2018 02:53:45 GMT

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

Re: PL-SQL postgres

manodwhb — Tue, 20 Mar 2018 04:46:14 GMT

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

Re: PL-SQL postgres

Anonymous — Tue, 20 Mar 2018 10:01:27 GMT

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

Re: PL-SQL postgres

manodwhb — Tue, 20 Mar 2018 10:27:33 GMT

I belive some how your missing jars.

Re: PL-SQL postgres

Anonymous — Tue, 20 Mar 2018 10:29:06 GMT

What can I add as jars !

Re: PL-SQL postgres

mat2121 — Tue, 20 Mar 2018 13:50:55 GMT

Class name is not the name of your SP or the name of your job.

It is the name of the java class (Driver) specific to postresql.

In your case the class name should be :

org.postgresql.Driver