Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
31
Views
6
Comments
User_15J6I
User_15J6I Rank 5 - Community Champion

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

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • 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]
    [Deleted User] Rank 2 - Community Beginner

    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
    User_15J6I Rank 5 - Community Champion

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

  • 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
    User_15J6I Rank 5 - Community Champion

    ok, thanks