Create the SQL Content Source

About

A Content source Content Sources do the following: Receive data from the Source System via the Connection, Filter the data it receives, Provide the results to the Target, Define the specific search index that contains the content you wish to index (and later search). determines the data that can be retrieved using an SQL connection Connection defines the how Connectivity Hub connects to your Source System (which contains your documents, graphics, etc.,). Your Connection includes identifying elements such as: URL of the BA Insight web service connector you are using, (File Share connector, SharePoint Online connector, etc.), Authentication mode, User Accounts and Credentials, Database information (for database connectors). 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 A Target is a "pointer" to a specific instance of a search application, such as Elasticsearch. - (A Search application instance has one or more indexes): 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 Enumerate Items to Index.

  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 Contains data from your source system. Your search application instance (Elasticsearch, SharePoint Online, etc.) contains the search indexes. One search index per content source. per item. By default, this setting is set to 1000000 characters.

  10. Property Prefix: Enter a prefix for the metadata Provides context with details such as the source, type, owner, and relationships to other data sets. Metadata provides details around the item being crawled by Connectivity Hub. 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.