We are experimenting with using the MS Excel 2010 Database wizard with Oracle ODBC to query custom views of data in our S3 database tables. We are able to see the non-materialized views, but the materialized views are not visible for selection. We are using Oracle 11gR2 for our database.
Any suggestions on what to do to make the materialized views visible for selection would be greatly appreciated.
Thank you.
Have you considered using Microsoft Acces to query off your Oracle tables? I actually use both Microsoft Access and Oracle SQL Developer to connect to our S3 database and create queries. Oracle SQL Developer is a free download form Oracle's website. If you do not have admin rights to your database while using Oracle SQL Developer, you won't be able to save user defined functions, but it will allow you to save any queries you create. Hope this helps.
*When viewing the Oracle SQL Developer directory tree for your database, you will see a folder named "Materialized Views".