You can create queries using data from different data sources in a single report. For example, you could create a master query using data from and Oracle data source, and a detail query using data from an SQL Server data source.
When you use multiple data sources in a single report, the data source type must be the same. For example, you can create a report with queries from more than one ODBC data source. Or, you can create a report with queries from more than one DDO data source. You cannot, however, create a report with one query from an ODBC data source and one query from a DDO data source.
Supported ODBC data sources include:
Oracle
SQL Server
Sybase
DB2
Informix
Supported DDO data sources include:
JDBC
SAP R/3
SAP BW
Essbase
MS-OLAP
XML
CSV
To select which data source to connect to, select a data source on the Connection tab in the Query Builder.
For example, you could create a master query and select Informix on the Connection tab. When you create a detail query, the Query Builder is displayed again. This time you could select Sybase on the Connection tab.
Note:
You cannot use different data sources for a single query. You can only use different data sources for multiple queries within a single report.