Can you bring data from 2 different sources oracle and sql server and create a report in OBIEE

Question

Hi All,

can you bring data from 2 different sources oracle and sql server and create a report in OBIEE 12c.

I have only windows authentication to SQL server DB.   If that work ? Can I import tables from SQL server using windows authentication ? If not any work around for this ?

Please suggest.

842395 · Answer

OBIEE supported Vertical and horizonatl fedarartion query reports geneated

[Deleted User] · Answer

What you are describing is basically the reason for OBIEE's existence and why the guys from nQuire wrote it in the 1990s: querying from heterogeneous data sources.

Have you ever looked at a SampleApp repository? It showcases exactly that in many places with many sources. Oracle DB, Essbase, Hadoop, XML files...

A whole Business model is dedicated to showcasing just that: