There are two ways to introspect and use Microsoft Excel files. The method used depends on whether the TDV Server you are working with is hosted on a Windows operating system or UNIX operating system:

In both cases the Microsoft Excel files must be locally accessible to the TDV Server on a mapped or mounted drive. Flat files do not expose a JDBC interface, so direct (mapped or mounted) LAN access to those flat files is required.

If you want to introspect Excel documents that contain non-US characters, you should use the Non-ODBC Excel data source.

Note: Excel files are loaded into managed memory. If managed memory is insufficient, the introspection fails.