Does OBIEE support connection to Microsoft SQL Server to use as a Data source for dashboard? — 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

Does OBIEE support connection to Microsoft SQL Server to use as a Data source for dashboard?

Received Response
1
Views
2
Comments
Arfeen
Arfeen Rank 3 - Community Apprentice
edited Aug 13, 2024 5:55PM in Oracle Analytics Cloud and Server

Hi Guys,

   My company is evaluating Business Intelligence tools. We have Oracle EBS v 12.1.2 and Some customized modules with MS SQL server database. my question is as follows..

Q. Does OBIEE support connection to Microsoft SQL Server to use as a Data source for dashboard

Regards

Arfeen Mushtaq

Answers

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Please check the certification matrix on http://www.oracle.com/technetwork/middleware/fmw-122130-certmatrix-3867828.xlsx

    (Sheet Database, select Oracle Business Intelligence Enterprise Edition as Product Offering)

    This matrix states that the following data sources are certified to work with OBIEE as Application Datasource:

    • Microsoft SQL Server 2012
    • Microsoft SQL Server 2014
    • Microsoft SQL Server 2016
    • Microsoft SQL Server Analysis Services 2012
    • Microsoft SQL Server Analysis Services 2014
    • Microsoft SQL Server Analysis Services 2016
  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    If you have EBS you might also want to look into OBIA for BI against EBS financials / HR etc with predeveloped data warehouse, ETLs, subject areas, dashboards etc etc