Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use xls/xml files in Repository as DSN on OBIEE Linux?

Raluca Balan-OracleApr 16 2014 — edited Apr 16 2014

Hi,

I have a VirtualBox image on Linux that has installed OBIEE and Oracle Database 11g.

I have an Excel file that has several sheets, each sheet represents a table that should be embedded inside my RPD that runs on Linux.

I am working on a new project that consists on adding a MS Excel file as data source as a new connection source inside the repository.

On Windows environment, I can embed the Excel file using an ODBC Driver for Excel, but since my OBIEE is running on Linux VBox, I would like to proceed in the same way on Linux.

If you have encountered something similar and embedded an Excel file(or other formats) inside the RPD within an Linux Environment, could you please advice on how should I proceed?

How can I add as DSN format files such as xls, xml etc from Linux and use inside the RPD opened with Administration Tool from my Windows host?

Thanks!!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 14 2014
Added on Apr 16 2014
#business-intelligence-applications, #file, #linux, #obiee, #odbc, #repository
2 comments
1,517 views