cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Poseidon Visitor
Visitor

Re: Connect to OBIEE RPD using ODBC Connection

@arify have we got any updates on this one? We really need this RPD connection to work.

Azharuddin Frequent Visitor
Frequent Visitor

Re: Connect to OBIEE RPD using ODBC Connection

Visit here to get the information to connect OBIEE RDP usind ODBC Connection.

anitaberg Regular Visitor
Regular Visitor

Re: Connect to OBIEE RPD using ODBC Connection

Hi! Did anyone manage to get this working. Using Oracle BI Server ODBC connection and then displaying the tables after expanding a subject area?

 

I have installed a complete Oracle OBIEE test environment on my PC. The last step is to get this to work. The workaround

 

let
Source = Odbc.DataSource("dsn=#YOURDSNNAME#", [HierarchicalNavigation=false])
in
Source

 

is not a good workaround in a self service perspective, the main goal would be for user to see available subject areas and then see the available tables to connect to.

 

 

alexrz Frequent Visitor
Frequent Visitor

Re: Connect to OBIEE RPD using ODBC Connection

I anm trying to run that script from Advanced Options => SQL Statement:

 

let
Source = Odbc.DataSource("dsn=OBIPRD", [HierarchicalNavigation=false])
in
Source

 

But receive Unable to Connect error: Details: "ODBC: ERROR [HY000] [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 27002] Near <Source>: Syntax error [nQSError: 26012] .
"

Please advise

anitaberg Regular Visitor
Regular Visitor

Re: Connect to OBIEE RPD using ODBC Connection

Hi! I spent a lot of time struggling to get everything around Oracle to work. One thing that was not obvious was that Microsoft for example did not like the syntax of tnsnames.ora file, It wanted the syntax there exactly as in example on microsoft documentation.

 

Also I made sure I tested user access and roles in SQL Developer before using it i Power BI.

alexrz Frequent Visitor
Frequent Visitor

Re: Connect to OBIEE RPD using ODBC Connection

Thank you to your responce: but I have all the necessary connections and roles. I added this script trying to fix the problem that is the main subject all this long discussion: When I open OBIEE RPD in PowerBI - I cannot drill off a Subject Level. I can use Select query as a data source & Power BI  run it (i.e it finds all the necessary tables & columns from the physical Model) , but when open RPD itself I cannot click and expand any subject area.

This topic is discussed and somebody earlier  suggested to add script

 

let
Source = Odbc.DataSource("dsn=OBIEE Analytics", [HierarchicalNavigation=false])
in
Source

 

 to the Advanced Connection: I added it to the SQL Box of Advane Option and got connection error. So my question was : Have I added it to the proper place and if so - what may be wrong?

Appreciate any help

Anonymous
Not applicable

Re: Connect to OBIEE RPD using ODBC Connection

This thread seems to have died  ....

To be clear. This is for the OBIEE BI Server ODBC connection not the Oracle DB connection.

 

The BI Server hosts a meta data model over one or more physiucal data stores eg DBs, Excel, WS, etc. The ODBC driver provides a SQL interface that model.

 

We can use the driver to execute logical SQL against the BI Server model. However, what is more desirable is to be able to select 'tables' from the model and load those into PBI. As has been noted elsewhere, we can see all of the subject areas in the model when we just connect to the BI Server ie no SQL in the Advanced box. But we can not see any lower to be able to select whole tables.

 

Using the Advanced editor script noted in other posts with the Dec 2018 release.

I can see all the meta data about the tables in the model. 

There is a table column. If Iselect a specific row in the data set (for a given table) and then expand the table field. I then get all of the columns in that table. However, all I then get is a single row of data with null values.

 

It would be good even if this process worked but its not. The desirable behaviour is to select whole tables in the UI.

 

Thanks

 

Tim

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 302 members 2,867 guests
Please welcome our newest community members: