I am trying to implement a solution as below:
tJava --> tMSSQLRow (Which calls "exec <Stored Procedure> <input parameter>") --> tParseRecordSet --> tJavaFlex
The same SP works fine on Management Studio, as well as, Talend Sandbox; and returns the data.
But, somehow, it's not working in Talend Open Studio. And it's returning null.
Could someone provide some solution to that?
Why do you use tMSSQLRow instead of tMSSqlSP to call the procedure?
Based on your job, the design should be:
tJava --> tMSSqlSP --> tParseRecordSet --> tJavaFlex
tMSSqlSP schema must have a column of datatype "Object".
Why does it works using Talend Big Data Sandbox? That is the question.
Sorry for responding very late.
Thanks TRF for response.
That worked in both the ways (using MSSQLRow as well as MSSQLSP components).