PL-SQL postgres

Highlighted
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
Forteen Stars

Re: PL-SQL postgres

you should use tPostgresqlSP coustom component or tJDBCSP.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six 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
Forteen Stars

Re: PL-SQL postgres

you should use tPostgresqlSP coustom component or tJDBCSP.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
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
Forteen Stars

Re: PL-SQL postgres

which version of Talend are you using?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
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.
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
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

 

Forteen Stars

Re: PL-SQL postgres

I belive some how your missing jars.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: PL-SQL postgres

What can I add as jars !
Six 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

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now