Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    How to create more than one different Oracle Database connection (different owners) but with the same Oracle Database service with Power BI?

    Vote (1) Share
    Anderson Oliveira's profile image

    Anderson Oliveira on 20 Jun 2018 19:46:14

    I need to make two distinct queries that are in tables of different owners, but they are in the same database and I can not have a master user that can access the tables of the two owners in question.

    Comments (1)
    Anderson Oliveira's profile image Profile Picture

    Anderson Oliveira on 05 Jul 2020 23:24:00

    RE: How to create more than one different Oracle Database connection (different owners) but with the same Oracle Database service with Power BI?

    Well, I was with a certain urgency, I created two connections (TNSNAMES.ora) to be able to use two owners of the same database, but I believe that I can have a better solution !!!

    SRVCO_ORACLE =
    (DESCRIPTION =
    (ADDRESS_LIST = (LOAD_BALANCE=on)(FAILOVER=ON)
    (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE1.srvcdb.br)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE2.srvcdb.br)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE3.srvcdb.br)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = SRVCO_ORACLE)
    )
    )

    SRVCO_ORACLE2 =
    (DESCRIPTION =
    (ADDRESS_LIST = (LOAD_BALANCE=on)(FAILOVER=ON)
    (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE1.srvcdb.br)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE2.srvcdb.br)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE3.srvcdb.br)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = SRVCO_ORACLE)
    )
    )


    exemple:
    conn USER1/USER1@SRVCO_ORACLE
    conn USERXPTO/USERXPTO@SRVCO_ORACLE2