#1 2012-05-24 13:03:35

silpa09
New member
Registered: 2012-05-14
Posts: 8

Stored Procedure

Hi Everyone,


                  I have created Stored Procedure on Entity and retrieving the Value of attribute.
   But using connector in workflow , im not able to get the values as list. Im able to retrieve only first value from Procedure.
   
               Please, Can anyone help me How to retrieve list of values of attribute from stored procedure using workflow (stored Procedure connector) ?
                     Can we do in Custom Forms?


Thanks,
Silpa.

Offline

#2 2012-05-24 14:33:28

janhess
Member
Company: Newcastle University
Registered: 2009-05-19
Posts: 1137

Re: Stored Procedure

connect the tDatabasetypesqlSP to tParseRecordSet. Define the schema of the returned data in the tParseRecordSet.
The output of the SP should be 1 column of type recordset.

Offline

#3 2012-05-24 16:18:55

silpa09
New member
Registered: 2012-05-14
Posts: 8

Re: Stored Procedure

Hi  janhess,

Thanks for quick reply..
But for this we did need do DI Job.
But our requirement is using TalendMDM Search Procedure Connector in Workflow..

Can we do that?

Offline

#4 2012-07-16 11:28:02

rodhia
Member
Registered: 2011-01-18
Posts: 11

Re: Stored Procedure

Hi All

Did any one have reply for the above said requirement. Please reply soon.


Regards
Rodhia

Offline

Board footer

Powered by FluxBB