insert row into table

[Anonymous]

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 

[manodwhb]

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

[Anonymous]

@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

[manodwhb]

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

[Anonymous]

not solved yet...

[akumar2301]

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 )