We require to use an Excel spreadsheet as a data source for OBIEE. The instance is deployed on a remote Linux server and the rpd is developed locally on a Windows machine. I can connect fine locally but I'm not sure what connection information (ODBC/JDBC etc) is necessary when I load the rpd up to the Linux server - the spreadsheet will also be stored on the Linux box.
Please can you advise what I need to do in order to connect to the excel datasource in Linux?
1. Try to see if the Linux version you have has a CSV connector (in which case you use CSV format for the excel file). This depends on your linux versions etc.
2. Probably best if you write a script to copy from Excel to a table that is used by the Linux server
3. Consider using XML format as a source