Configuration of excel as a datasource in obiee 12c for linux

User_15J6I

Could somebody share with me a manual or reference for configuration of excel as a datasource in obiee 12c for linux, thanks!

[Deleted User]

This is a question we often get here in the forum and the answer is always the same:

You need to buy an ODBC driver for Excrl on Linux. There isn't a free one.

Gianni Ceresa

More widely I believe it's worth to think about your "need" from a global point of view. OBIEE as an enterprise wide analysis and reporting platform based on Excel file sources? It's probably easier and safer to get the Excel into a database first and use a proper database.

DV can use Excel as source, but it has been created with a different target in mind, allowing self-service, which is the use case involving Excel files as sources in general.

[Deleted User]

Very true. It's important to point out though that DV is a component which has to be licensed in addition to OBI. So it's a trade-off between "how much does which part cost" and "what functionality A vs B offers and what of that functionality will I use".

User_15J6I

Thanks for your answer Gianni, what do you mean with DV?

Gianni Ceresa

Data Visualisation (the old name was Visual Analyser).

It's part of OBIEE 12c, but as Christian said you better make sure you have the right license for using it.

User_15J6I

ok, thanks