creating mapping

Five Stars

creating mapping

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?

 


Accepted Solutions
Six Stars

Re: creating mapping

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


All Replies
Six Stars

Re: creating mapping

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

Nine Stars

Re: creating mapping

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

Six Stars

Re: creating mapping

Hi Mouryas,

If the answer worked.Kindly accept it as solution

Five Stars

Re: creating mapping

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

Re: creating mapping

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.