Named query from multiple datasources

Is it possible to to have named query that gets data from more than 1 datasource/gateway database? Do I just need to explicitly specify the datasource name in front of the table name?

If this is not possible, what the best way to combine data like this onto a single report?

I don’t think you can hit up more than one data source in a Named Query. You would have to script it together.

1 Like