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

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
11
Views
2
Comments
Vamsi Rampalli
Vamsi Rampalli Rank 4 - Community Specialist
edited Aug 13, 2024 5:48PM in Oracle Analytics Cloud and Server

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.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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:

    pastedImage_0.png

  • 842395
    842395 Rank 3 - Community Apprentice

    OBIEE supported Vertical and horizonatl fedarartion query reports geneated