Manage mapping crawled to managed properties (FAST Search database connector)
Applies to: FAST Search Server 2010
Once you have run the FAST Search database connector, crawled content will show up in the crawled properties in the Microsoft SharePoint Server 2010 Central Administration. All crawled properties in the JDBC category are searchable by default. To make the properties appear in the search result, they must be mapped to managed properties. No properties are mapped by default for JDBC content.
Columns or aliases from the SELECT statement are available as crawled properties.
Beware that some databases return column names in uppercase, while the index profile only accepts lower case letters. In such cases you can use aliases in order to lower case the column names. For example:
SELECT ID as “id”, NAME as “name”, ADDRESS as “address” FROM table
How to map a crawled to a managed property
To open the Managed Properties page:
On the Central Administration page, select General Applications Settings.
On the General Application Settings page, under Search, select Farm Search Administration.
Select Search Service Application, and select your Query Search Service Application (for example, fastsearchquery).
Select FAST Search Administration from the menu on the left.
On the FAST Search Administration page, under Property Management, click Managed Properties.
To add a crawled property to a managed property:
On the Managed Properties page, click Crawled Properties Categories.
On the Crawled Property Categories page, find the JDBC category and click it.
On the Crawled properties page, click the crawled property name that you want to edit.
On the Edit Crawled Property page, in the Mappings to managed properties section, click Add Mapping.
In the Select managed properties to map to dialog box, configure the settings. In the Available managed properties list, search for or select a managed property, and then click Add. Repeat if you want to add more managed properties to the same crawled property. Click OK.
On the Edit Crawled Property page, if you want to include values for the crawled property in the search index, select the Include values for this property in the search index check box.
Select the check box to enable querying against the values of this crawled property. This will place these values in the search index. For example, if the crawled property is "author," simple queries such as "Smith" will return both items that contain the word "Smith" and items whose author property is "Smith." When unchecked, users will have to query against the managed property "author:Smith" to find the same items. Including unnecessary properties may have a negative effect on search relevance and performance.
Rerun the connector for the changes to take effect.