Execute postgress function from Talend

Highlighted
Four Stars

Execute postgress function from Talend

Do we have component to call postgress function?
Highlighted
Six Stars

Re: Execute postgress function from Talend

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.

Highlighted
Moderator

Re: Execute postgress function from Talend

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

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

Re: Execute postgress function from Talend

Hi,

 

in which way I call the procedure inside tPostgresqlRow?

Moderator

Re: Execute postgress function from Talend

Hello,

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

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.

2019 GARTNER 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

Talend Cloud Developer Series - Introduction

The Talend Cloud Developer Series was created to give you a solid foundational understanding of Talend’s Cloud Integration Platform

Watch Now

Talend Cloud Available on Microsoft Azure

An integration platform-as-a-serviceto help enterprises collect, govern, transform, and share data from any data sources

Watch Now

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now