topic Re: insert row into table in Talend Studio

insert row into table

Anonymous — Tue, 12 Mar 2019 10:46:09 GMT

Hey guys, i'm a beginner Talend user, so, if you know guys how to insert a row into a data base please get me notified

In fact, i want to insert a new row to a data base table of Microsoft SQL server every time i excute , a new line will be create in the table, which component should i use?

the problem here that i need some variables from a tmap that i've created,

and i can't link tmap with a trowgenerator,

here is the request i want to execute
"INSERT INTO [dbo].[CHOIXEXT]
([YX_TYPE]
,[YX_CODE]
,[YX_LIBELLE]
,[YX_ABREGE]
,[YX_LIBRE])
VALUES
(<LA2, nchar(3),>
,< LCW_CodeCHOIXEXT_LA2, nvarchar(17),>
,< MershSubGroupName, nvarchar(105),>
,< MershSubGroup, nvarchar(17),>
,< nv, nvarchar(35),>)
GO"

*"LA2" static String
*"LCW_CodeCHOIXEXT_LA2" request1 result (mentionned in the screenshot below)
*MershSubGroupName form "INV_Product" database
*MershSubGroup form "INV_Product" database
*"nv" static String

thank you for advance guys

Re: insert row into table

manodwhb — Tue, 12 Mar 2019 11:11:57 GMT

@9allel22 ,if you wan to execute the insert query ,you can use tDBRow, as part of flow you were getting data and want to insert you can use tDBOutput.

Re: insert row into table

Anonymous — Tue, 12 Mar 2019 11:57:00 GMT

@manodwhb

thank's for the feedback,

i've tried to put tdbRow, but my problem is how to put values in my request (insert) from my tmap

here is screenshots of my job to let you understand more the stuff

MY REQUEST

THE VALUES THAT I WANT TO RECOVER FORM THE TMAP

THE LINK BETWEEN TMAP AND TDBROW

Many regards

Re: insert row into table

manodwhb — Tue, 12 Mar 2019 12:26:27 GMT

@9allel22 ,form tmap you can connect to tOracleoutput.

Re: insert row into table

Anonymous — Tue, 12 Mar 2019 16:17:12 GMT

not solved yet...

Re: insert row into table

akumar2301 — Tue, 12 Mar 2019 22:50:24 GMT

hello ,

can you please explain

which columns are not defined using tMap and why you need trowgenerator for them ?

could you populate those also in tmap?

if yes , you can connect tmap result (rowinsert)

to tdboutput directly ( or tdbrow if you are building insert query )