Forum Discussion
Connect to OBIEE RPD using ODBC Connection
Has anyone found a solution for this?
I'm experiencing the same issue. Here is a bit of background:
We have been using OBIEE for more about 8 years and have built all of our business models, dashboards and anlaysis using OBIEE. We are now at a point we are looking at other analytics tools to either replace or suplement OBIEE. However, we don't want to lose all of the phsycial and busienss models that we created over that time. Recently we have looked at Tableau and Microsoft Power BI as possible alternatives. As such, I have downloaded desktop versions of each applciation to test.
- I setup an ODBC connection using the Oracle BI Server driver to point to the Presentation Layer Subject areas of OBIEE. The ODBC driver successfully displays the Subject areas.
- In Tableau I connect to the ODBC data source and it allows me to view the OBIEE Subject Area and all of the tables and columns (data objects) within the Subject Area. It also allows me to pull data data models into Tableau for reporting.
- In Power BI I connect to the ODBC data source and it dispalys my subject areas (similiar to the discussion and images contained in this stream). However, when I click on one of the Subject areas it does not expand to show me the tables and columns within the Subject area (per the discussion and images here). I do not get any messages other than no data available.
I would appeciate any suggestinos in solving this issue and guideance for integrating the OBIEE models into Power BI. In addition, if there is a tool for migrating OBIEE RPD metadata into Power BI that would be very usefull as well.
Thanks...
Hi wbsissonii,
Please make sure you installed the latest version (that got released a few days ago) and then do this workaround:
Go to Get Data > Blank Query > (In the query editor) Advanced Editor > Paste this:
let
Source = Odbc.DataSource("dsn=YOURDSN", [HierarchicalNavigation=false])
in
SourcePlease let me know how it went.
Thanks