How do I access the result data in the Custom Output of the Query Database Smart Service?

Question

I want to access sql result data in Custom Output of Query Database Smart Service, but I get an error. 
 I would like to access the ResultSets, like in the Execute Stored Procedure Smart Service if possible, can I achieve the same operation in the Query Database?

Stefan Helzle · Accepted Answer

I highly recommend to use the latest Data Fabric features and synced records to implement complex queries.

Sanchit Gupta (Xebia) · Answer

Just out of curiosity, any specific reason for using Query Database node instead of a!queryentity() ? this is very rarely used and other options should be considered first. 
 Still, if you want to index the result sets, you need to store them in a pv! and index those pv! in a script task next to this node.

Harshit Bumb (Appyzie) · Answer

Use records and record relationships. They were designed for connecting data, and aggregating them while keeping the maximum performance.

Sanchit Gupta (Xebia) · Answer

Query entities are best when you are querying data from a RDBMS. If the data is complex then a DB view can act as a DSE or as you said procedures can also be used. But as Harshit said, using Records with relationships is considered more preferable and recommended solution to the underlying condition these days.

How do I access the result data in the Custom Output of the Query Database Smart Service?

Top Replies