Perceptive Search has the ability to index data from a variety of SQL data sources, including desktop databases such as Microsoft Access, Paradox, dBASE, and FoxPro. Data from relational database servers (RDBMS) such as Microsoft SQL Server, Sybase and MySQL can be indexed via ODBC.
This interface assumes that you have some knowledge of relational database concepts. It lets you nominate fields to be indexed, in what order they should appear, which subset of records should be included and how records are identified. Any number of data sources may be defined for each index.
You can relationally join several tables together and index them as a single entity within Perceptive Search. For example, you might have a DOCTOR table that contains a list of doctor ID codes, names and addresses. You might also have a HOSPITAL table that contains hospital names and addresses, as well as the ID code of the chief surgeon. Using Perceptive Search, you could index just the DOCTOR table or just the HOSPITAL table or you can join the two together and index a composite view, showing hospital name (from the hospital table), chief surgeon name and phone number (from the doctor table).
The details of what SQL data is to be indexed is stored in the ISYS.SQL file, which resides alongside your ISYS.CFG file, one per index. Indexing and retrieval on SQL data is done in the usual way.
You can create or modify your email indexing rules by selecting Tools > Active Index > Indexing Rules from the menu and select SQL Rules.
Wizard Steps