Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

BI publisher data connection. ODBC

Received Response
12
Views
3
Comments
Tony_OAS_Apex_User
Tony_OAS_Apex_User Rank 5 - Community Champion
in Oracle Analytics Forum


I am trying to create ODBC on DV data connection.

image.png


for DSN should I put a entry from TNSNAMES.ora?

let me know.

Answers

  • Brendan T
    Brendan T Rank 6 - Analytics & AI Lead

    the DSN field or Connection String field requests the full connection descriptor from the tnsnames.ora file

  • Gianni Ceresa
    Gianni Ceresa Mod

    An ODBC connection is usually not an Oracle Database connection (you have dedicated connection types for that), therefore the tnsnames.ora isn't involved.

    What are you trying to connect to?

  • Tony_OAS_Apex_User
    Tony_OAS_Apex_User Rank 5 - Community Champion
    edited Feb 11, 2026 8:47PM

    Thanks for your answers..

    i just want to create odbc connection to oracle database to create dataset. so I can use it on BI publisher.

    I am having some issue that data columns dosn't come up in BI Publisher as regular user.

    It doesn't have to be odbc connection within DV, but i already have connection to Oracle database.

    image.png

    As a BI admin group user I could see all the columns and data but as a regular user can't.
    What permission control that? We don't want to give a admin role to the regular user.


    Which permission let you see and work with it?

    image.png