What are the mandatory values required for indexing database tables?

The following are the mandatory values to be entered for indexing database tables in database collection:

Note: This is applicable for indexing databases like MySQL, Oracle and SQL Server

Path Tab
* query

Settings Tab
* Database Driver Class
* Database Type
* Host IP/Name
* Database Name
* DB User Name
* DB Password

To learn more on database collection settings read: Database Collection Connection Settings