You do this via federated queries, we call them Sub Queries in Yellowfin.
Sub Queries allow you to query two or more data sources that return different data sets and combine them at the report level.
For example, you can source product information from one database, and take financial information from another, and combine them both into a single report easily.