creating mapping

[Anonymous]

hi floks,
i am new to talend and i want to run a sql procedure in talend,
can you suggest how can i do that?

[Anonymous · Accepted solution]

You Can use "t Oracle SP" or t My_sql SP components for 

• Calling a function without input parameters

• Calling a function with input parameters

• Calling a stored procedure without parameters

• Calling a stored procedure with parameters

Please go through the below link:

https://help.talend.com/reader/ezE005k1syi0pq3WAU8WyA/Or3iSV87d~xx6xzHYrUnLA

[iamabhishek]

@Moe - Your question title and your actual question differs - they are no way similar would recommend you to edit your question to garner more views.

If you mean Microsoft Sql Server (MSSQL) as sql then you could use tMSSqlSP component to call your procedure or function (to invoke function or if you want result to be returned then check the box - "Is Function").

[Anonymous]

Hi Mouryas,

If the answer worked.Kindly accept it as solution

[Anonymous]

since my procedure contains upsert operation can i achieve it with any alternative

[Anonymous]

Use tdb_row and write your query.(db can be mysql or redshift or oracle)

If you have any date column in your table then it will be easier.

or else

you can use tdboutput and use update and insert in action on data.