topic Re: Calling Teradata Stored procedure inTalend in Talend Studio

Calling Teradata Stored procedure inTalend

BA621858188 — Fri, 15 Nov 2024 22:01:02 GMT

Hi All,

I am using a Teradata stored procedure in Talend. I am using tdbrow to call the stored procedure statement. I have one OUT parameter, which I again need to use for further flow in the job.

How do I get the value of the OUT parameter from a stored procedure? Can anyone help here?

Thanks in advance.

Re: Calling Teradata Stored procedure inTalend

BA621858188 — Fri, 10 Mar 2023 02:34:22 GMT

Hi @Shicong Hong ,

can you please help here?

Re: Calling Teradata Stored procedure inTalend

Anonymous — Fri, 10 Mar 2023 04:37:57 GMT

Hello,

As we don't have any specific tTeradataSP component in talend. You are able to use tDBSP component using generic JDBC connection. In jdbc conn you need to specify drivers and driver class specific to Teradata db. Passed input parameters using tfixedflowinput and cached output parameter using tJavaRow.

Feel free to let us know if it helps.

Best regards

Sabrina

Re: Calling Teradata Stored procedure inTalend

BA621858188 — Fri, 10 Mar 2023 05:15:10 GMT

@Xiaodi Shi

How can I cache the output parameter? You mean I can directly use the OUT parameter name and store it in context?

Re: Calling Teradata Stored procedure inTalend

Anonymous — Fri, 10 Mar 2023 06:22:32 GMT

Hello,

Yes you can use tDBSP to run the stored procedure and can store the result in output parameter and write the values in the next component.

For retrieving result set from a stored procedure, please try to link tDBSP to a tParseResultSet component, define a column with object type on schema of tDBSP.

Best regards

Sabrina

Re: Calling Teradata Stored procedure inTalend

BA621858188 — Fri, 10 Mar 2023 09:35:21 GMT

Hi @Xiaodi Shi ,

My IN parameter is coming from context value not from any schema.

How can I do now?

Re: Calling Teradata Stored procedure inTalend

Anonymous — Fri, 10 Mar 2023 09:54:24 GMT

Hello,

Would you mind posting your job design screenshots here so that we could get more detailed information and workflow about your current situation.

Please mask your sensitive data if needed.

Best regards

Sabrina

Re: Calling Teradata Stored procedure inTalend

BA621858188 — Fri, 10 Mar 2023 10:00:37 GMT

Hi @Xiaodi Shi

I won't be able to give you the design here because it's in another VM.

It seems that before tDBSCP, I need to use tfixedflowinput to store that context value as a column and then pass to the procedure.

Please correct me if I am wrong.