Create the SQL Content Source

About

A Content source determines the data that can be retrieved using an SQL connection. For this reason, you must configure your SQL connection before you add a content source. This section explains the configurations that are available when you perform one of the following:

  • Create a connection to a new content source

  • Edit an existing content source.

The content repository connection information is available within the Content Info tab on the SQL Content page. Other tabs on the SQL Content page let you refine some of this information. When you set up your content source, there are multiple components, displayed as pages, to configure:

  1. Content Source

  2. Item Enumeration

  3. Item Definition

  4. Security Mappings

  5. Dataset Mappings

  6. Advanced Settings

Set Up the Content Source

To set up the content source, follow these steps:

  1. Open Connectivity Hub and click on Content Sources.

  2. Click on New… > SQL content to create a new content source or click on an existing one to edit it.

  3. The SQL Content page appears.

  1. Target: Select your desired target form the drop-down.

  2. Connection: Enter an SQL connection, such as SQL Server connector. All of the configured SQL connections should be available.

  3. Title: Enter a title for this content source.

  4. Crawl Start Date: Leave the default entry 1/1/1990 or enter another date for the using the MM/DD/YYYY format. This is the earliest date for items that are returned by the crawl operation.

  5. Max Paging Size: Select the page size to be used during item enumeration. While indexing, SharePoint processes each page of items before requesting the next page.

  6. Max Paging Size and Crawl Start Point only function when the SPW_LASTUPDATE or SPW_LASTUPDATEUTC column is used in the item enumeration query. For more information, see Filters.

  7. Content Localization: This value identifies the locale of the content for SharePoint. Leave the default setting 1033 (English) or see the link on the page for other options.

  8. Max File Size: Enter the maximum file size, in megabytes, that you want to index.

  9. Max size of extracted text: This specifies the maximum number of characters that are stored in the search index per item. By default, this setting is set to 1000000 characters.

  10. Property Prefix: Enter a prefix for the metadata property titles. The default is “ESC_”.

  11. Click Save now or when you have made all of your changes to the information in all of the accessible tabs on this page.