The generic discovery process uses built in function calls in the JDBC driver (or the ODBC driver through the WhereScape JDBC-ODBC bridge) to obtain all information with regards to tables and columns.
Generic discovery:
- is appropriate in most situations
- is faster than other discovery processes on most database types
- should be run in the first instance
Note
JDBC drivers are (in most cases) supplied by the database vendor. Some have complete implementations of all functions and properties, others do not. In a few cases, missing functionality will result in incomplete discovery. To restore the JDBC drivers, select File and then Restore JDBC drivers, as shown in the following screenshot:
REPLACE WITH THIS IMAGE: Images/discovery/restorejdbc.png