IDT & UDT - SQL Difference

[Former Member]

IN BI4.0 - When we build the universe in IDT there is different SQL option for Single source and Multi Source.

Single source - Database specific SQL Syntax

Multi Source - Standard SQL-92 and SAP Business Objects SQL functions

What is the difference between this two?

[Former Member]

Multi Source in IDT, it will allow to connect to 2 different DB (Oracle/SQL Server) or data sources and build the universe.

Previous versions of BI (3.1 or before)  you cannot build the universe with only one DB or data source. BI 4.0 will allow to connect to multiple Data sources.