Best Practices

Database Query

Provide a valid SQL query that works in your database application. Read: SQL Query for Database Collection
Map a unique ID to the uid field. This is required for successful indexing.
Map a relevant field as the title to display in search results.
If no unique field exists, create a view with a unique field or a combination of fields and use it in the SELECT query.

Enter valid settings for the database.
Provide either the database settings or the full database URL string, depending on the selected database type.
Test the SQL query and database settings by clicking Test SQL on the Database Collection Settings page. Ensure it is successful before indexing.

Set a schedule for indexing according to how often the collection should be reindexed.
The minimum schedule interval is Daily. If indexing all records takes more than 24 hours, use a longer interval (e.g., every 2 or 4 days).
After indexing completes, reindexing will follow the specified schedule.
To check the status of records indexed please go to index.log in the path<SEARCHBLOX_INSTALLATION_PATH>/webapps/ROOT/logs and look for entries under the database collection name.