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

Raluca Balan-Oracle

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!!

Sh!va

Well i am not OBIEE resource to flash more spotlight on this issue/concern.

But below links may help you..

https://community.oracle.com/thread/1101999?start=0&tstart=0

Setting Up Data Sources on Linux and UNIX - 11g Release 1 (11.1.1)

Configuring Oracle Business Intelligence Enterprise Edition

Hope this helps!

Cheers!

Sh!va

Raluca Balan-Oracle

Hi,

I just wanted to know if someone succeeded to use a static file ( MS Excel, XML, CSV etc) inside Linux environment as data source inside OBIEE repository.

I can only open the repository with the Administration tool from my windows host machine and I don't know how to point to my static file that exists on my Linux VM and use it as datasource.