Analytics Software

Hello All,

Will “Direct Database Request” feature helps to connect to two connection pools at a time?

Report output is based on UNION of two select statements coming from two schemas, two connection pools are created to connect to two Schemas

First select statement is coming from one schema and second select statement is coming form the other

Select column1, column2, column3 from A, B, C
UNION
Select column4, column5, column6 from X, Y, Z

A, B, C tables are coming from first schema and X, Y, Z are coming from the other

How to get the above out put using “Direct Database Request” feature

Regards,
SMA