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 i create connection pool from BI admin to connect on SQL server database

Received Response
3
Views
5
Comments
Karim Aboul Kassem
Karim Aboul Kassem Rank 1 - Community Starter
edited Aug 13, 2024 6:02PM in Oracle Analytics Cloud and Server

Hi,

please i need create connection pool from BI admin to connect on SQL server database

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Open the BI Administration tool, open the RPD:

    option A: right click in the physical layer > new database, right click > new connection pool

    option B: File > Import metadata, follow the steps

    Your SQL Server connection is there.

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Thought I saw a BIAPPS on PaaS tag in the original question. But now it looks like it has been removed. If it is the cloud solution, I do not think you can use SQL server, but if it is on-premise Gianni already has given you the steps. Documentation is here.

    https://docs.oracle.com/middleware/1221/biee/BIEMG/datasource.htm#BIEMG1213

  • Karim Aboul Kassem
    Karim Aboul Kassem Rank 1 - Community Starter

    Hi Gianni Ceresa

    i know to create connection pool, but my question is can i create connection pool to connect on Microsoft SQL SERVER  database?

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

    Yes.

    pastedImage_0.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    If you ask things in the right way you get the right answers.

    And what I posted earlier works for SQL Server as well as Christian screenshot show.

    OBIEE support many kind of sources, SQL Server is one of them like documentation, certification matrix and many other official resources say.