PL-SQL postgres

Four Stars

PL-SQL postgres

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


Accepted Solutions
Twelve Stars

Re: PL-SQL postgres

you should use tPostgresqlSP coustom component or tJDBCSP.

Manohar B
Five Stars

Re: PL-SQL postgres

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

 


All Replies
Twelve Stars

Re: PL-SQL postgres

you should use tPostgresqlSP coustom component or tJDBCSP.

Manohar B
Four Stars

Re: PL-SQL postgres

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
Twelve Stars

Re: PL-SQL postgres

which version of Talend are you using?

Manohar B
Four Stars

Re: PL-SQL postgres

Talend Open Studio for Data Integration 6.4
Moderator

Re: PL-SQL postgres

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

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

Re: PL-SQL postgres

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

Manohar B
Four Stars

Re: PL-SQL postgres

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

 

Twelve Stars

Re: PL-SQL postgres

I belive some how your missing jars.

Manohar B
Four Stars

Re: PL-SQL postgres

What can I add as jars !
Five Stars

Re: PL-SQL postgres

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