AnsweredAssumed Answered

How to send Query Dynamically to database?

Question asked by mounika on Mar 16, 2018
Latest reply on Mar 16, 2018 by dcollins724067

Hi All,

If Sender system is sending the SQL Query To Boomi -> Boomi need to call the database with that Query-> get the response data from database and send the database response to Sender system. 

The Query will change in each request so every time we need to pass SQL Query dynamically to database.

The Query contains getting the data from multiple tables , usage of joins etc., in single database.

so what are the possible ways to send SQL Query(containing multiple tables from same database) dynamically to database?

Please Help!

 

Regards,

Mounika.

Outcomes