topic Re: I have a Stored Procedure in SQL Server... How can I call it in Talend? in Talend Studio

I have a Stored Procedure in SQL Server... How can I call it in Talend?

EvoticTalend — Fri, 15 Nov 2024 23:59:53 GMT

I have a Stored Procedure which calls another in my DDBB in SQL Server. How can i call him to be executed automatically in the flow of the job?

Re: I have a Stored Procedure in SQL Server... How can I call it in Talend?

gjeremy1617088143 — Wed, 30 Jun 2021 07:29:10 GMT

Hi, you can use the TDBSP component ,

https://help.talend.com/r/jomWd_GKqAmTZviwG_oxHQ/Y4ldtMoTiuC0d9L2HNRqzw

Send me Love and Kudos

Re: I have a Stored Procedure in SQL Server... How can I call it in Talend?

EvoticTalend — Wed, 30 Jun 2021 08:41:07 GMT

Thank you for telling me the component gjeremy :)!

I have a doubt, mmmm... I have a flow thand sends excels to a DB.

Now I want to only execute my PROCEDURE IN SQL SERVER (the procedure creates and inserts a new table in my SQL Server DB), how would be connected with the other components? Running the job like this (putting the TDBSP alone and running it, doesn't work)

Re: I have a Stored Procedure in SQL Server... How can I call it in Talend?

Anonymous — Wed, 30 Jun 2021 11:55:00 GMT

If you don't want other components to run, you can deactivate the subjobs. To do: right click the first component of subjob, and select 'deactivate the whole subjob' option.

Re: I have a Stored Procedure in SQL Server... How can I call it in Talend?

gjeremy1617088143 — Wed, 30 Jun 2021 12:37:20 GMT

have you read the scenario on the link i send you ? There is an example of how to use it, you have to use a TParseRecordSet to read the return of the SP.

You can also use a tDBRowComponent and write in directly the transact sql you want to execute.

Send me Love and Kudos

Re: I have a Stored Procedure in SQL Server... How can I call it in Talend?

EvoticTalend — Fri, 02 Jul 2021 11:47:40 GMT

Hi gjeremy, thanks. Yes, I reviewed the example but I dont know if it's the same as I want.

In my SQL Server procedure I have a SELECT and an INSERT in a new table.

The problem is I don't know what schema I have to put in the TDBSP component and the TParse. The schema of the new table created?

Thank you.

Re: I have a Stored Procedure in SQL Server... How can I call it in Talend?

gjeremy1617088143 — Fri, 02 Jul 2021 13:20:47 GMT

you have to set the result of the stored procedure, if it's just intern sql and not a request to get data , in general it return a boolean wich represent the succes of the execution.