AnsweredAssumed Answered

How to maintain session in teradata DB connection? & How to configure connection pool in boomi like webMethod properties have?

Question asked by iamshinde on May 23, 2017
Latest reply on May 23, 2017 by jason_r_walsh667087

We have a requirement where Storeprocedure will execute first then we need to fetch the data from parent table then based on parent table value again we need to query to child table for getting whole records.

 

summery:

SP CALL => Parent Table call to get the record for child table => child Table call to get records

 

 

Currently this is working perfectly in webMethod but when we are trying to execute the same scene here in Boomi it's not working just because of session.

 

 

Current connector configuration at WebMethod end which is working for this requirment:

 

boomi has limited properties could you please help here to configure such thing in boomi?

 

Thanks,

Sandeep

Outcomes