Execute postgress function from Talend

Four Stars

Execute postgress function from Talend

Do we have component to call postgress function?
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.

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.
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 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

Talend Cloud Developer Series – Fetching Studio License

This video will help someone new to using Talend Studio get started by connecting to Talend Cloud and fetching the Studio License

Watch 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