topic Re: How to run plpgsql to load data into postgresql server in Talend Studio

How to run plpgsql to load data into postgresql server

Anonymous — Sat, 16 Nov 2024 14:17:42 GMT

by using tSystem component i could execute my PHP script, which executes the DB connection with postgresql & loads the data(from input file) into DB.
now am trying to execute plpgsql script to get the data from the postgresql table(which is been loaded by the PHP script) & wanted to load the data into a different DB schema which is in the same postgresql server.
The aim to do this is, from diferent departments the input files will be coming to the main server. From the server we are using TOS to parse the file by using PHP & loads the data into Postgresql DB(as a temporary). after this we wanna consolidate the data. so from the temporary tables, we are moving the data to the data warehouse.
to move the data from temporary table to datawarehouse, am using plpgsql. but i dont know how to do this in TOS. can i use the plpgsql directly in any coponent? i hope it'd mess up the job design. so is there any component to run a whole plpgsql script? i need to do this after my PHP script loads the data successfully. please tell me some solution to do this.

Re: How to run plpgsql to load data into postgresql server

Anonymous — Sat, 19 Jul 2008 13:13:21 GMT

There is no tPostgresqlSP (Stored Procedure) component yet (TOS 2.4), but you can call your PL/PgSQL function directly from a tPostgresqlRow. The only drawback is that you won't get the return values of the stored procedure.

Re: How to run plpgsql to load data into postgresql server

Anonymous — Mon, 21 Jul 2008 11:12:26 GMT

Hi Plegall,
i referred the topic about Postgresql Stored procedure under this link https://community.talend.com/t5/Design-and-Development/tPostgresqlSP/td-p/73179. so is the component been updated?

Re: How to run plpgsql to load data into postgresql server

Anonymous — Mon, 21 Jul 2008 12:15:46 GMT

Hi Plegall,
i referred the topic about Postgresql Stored procedure under this link 2512. so is the component been updated?

The component tPostgresqlSP is available in the Ecosystem : tPostgresqlSP.

Re: How to run plpgsql to load data into postgresql server

Anonymous — Mon, 21 Jul 2008 12:29:48 GMT

Thanks plegall..

Re: How to run plpgsql to load data into postgresql server

Anonymous — Mon, 21 Jul 2008 12:57:53 GMT

hello guys,
i s there any topics about "how to import external components"?

Re: How to run plpgsql to load data into postgresql server

Anonymous — Mon, 21 Jul 2008 13:03:09 GMT

sorry guys.. i got the topic about that.. thanks for guidance.

Re: How to run plpgsql to load data into postgresql server

Anonymous — Thu, 24 Mar 2011 09:34:08 GMT

is possible to obtain a version of tPostgresqlSP running under tos 4.1 ?
or if someone can give me help to make a porting on TOS 4.1