topic creating mapping in Talend Studio

creating mapping

Anonymous — Mon, 09 Jul 2018 12:40:59 GMT

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?

Re: creating mapping

Anonymous — Mon, 09 Jul 2018 12:52:28 GMT

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

Re: creating mapping

iamabhishek — Mon, 09 Jul 2018 13:06:05 GMT

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

Re: creating mapping

Anonymous — Mon, 09 Jul 2018 15:12:53 GMT

Hi Mouryas,

If the answer worked.Kindly accept it as solution

Re: creating mapping

Anonymous — Thu, 12 Jul 2018 07:37:17 GMT

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

Re: creating mapping

Anonymous — Thu, 12 Jul 2018 09:43:54 GMT

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.