Show/Hide Toolbars

Additional Resources

Introduction > Integration with Microsoft SharePoint > Thereforeā„¢ Connector for Microsoft SharePoint

Configuration of the SharePoint integration

Scroll

The configuration of the integration between Thereforeā„¢ and the Microsoft SharePoint Server takes place in the Thereforeā„¢ Solution Designer. The configuration allows multiple connections to on-premise Microsoft SharePoint systems as well as Microsoft SharePoint Online. For each connection, one or more profiles can be configured. Configurations for each tenant within multi-tenant systems are possible. The profiles are processed by the service Thereforeā„¢ Crawler for Microsoft Sharepoint.

 

1.In the Thereforeā„¢ Solution Designer, navigate to the Integrations node. Right-click on the Microsoft SharePoint node and select New Connection.

SP_SharePoint2010_ConfigureCrawler_001a

2. In the SharePoint Connection Properties dialog, specify the Site Collections URL and the Connection Name. If required, specify a Username and Password which is used to connect to Microsoft SharePoint. For connections to Microsoft SharePoint Online, Username and Password are mandatory.

SP_SharePoint2010_ConfigureCrawler_003c

info

The Connection Name can be chosen freely.

 

3.  Open the context menu of the created SharePoint Connection node and select New Profile.

SP_SharePoint2010_ConfigureCrawler_004a

4.  In the New Profile dialog, specify the required options in the Properties tab. To start processing the profile using the Crawler, Enable Profile must be selected.

SP_SharePoint2010_ConfigureCrawler_005a

Please find a list of the various options that can be entered into the profile below.

 

Crawler Direction

Description

Send to Thereforeā„¢

The Crawler processes documents from SharePoint to Thereforeā„¢

Send To SharePoint

The Crawler processes documents from Thereforeā„¢ to SharePoint

 

Operation Mode

Description

Copy

Documents will be duplicated from the source system to the target system.

Move

Documents will first be copied to the target system. After successful processing in the target system they will be deleted in the source system.

 

Document Conversion

Description

Original

During document processing the original type of the document will be preserved.

JPEG

During processing, the document will be converted from its original type into a JPEG image.

Multipage PDF

During processing, the document will be converted from its original type into a PDF file.

Multipage TIFF

During processing, the document will be converted from its original type into a TIFF image.

Searchable PDF

During processing, the document will be converted from its original type into a PDF file. Full-text information will be added to the PDF.

Searchable PDF/A

During processing, the document will be converted from its original type into a standard PDF/A file.

 

SharePoint Site

Description

Sample: /Legal

Specify the full path to the SharePoint site you wish to use.

 

SharePoint Document Library

Description

Sample: Contracts

Specify the SharePoint Document Library you wish to use.

 

Thereforeā„¢ Category

Description

Sample: Contracts

Specify the Thereforeā„¢ Category that you wish to use

 

5.  You need to specify how the metadata for the document is transferred from the source system to the target system. To do so, you need to specify which metadata field of the source system will be transferred to which field in the target system. This is called Index Data Field Matching and it is configured under the Index Data Field Matching tab of the New Profile dialog.

 

 In the table, specify the matching pairs between SharePoint metadata fields and Thereforeā„¢ index data fields. The mandatory fields of the target system are automatically filled in the matching pair list and need to be properly associated with the field from the source system. If possible, the Crawler tries to convert between different data types of source and target fields (for example: source is a date and target is a text field).

 

 By clicking Add Association, you can specify additional matching pairs between source and target system.

SP_SharePoint2010_ConfigureCrawler_006a

Document Selection/Update:

For the Query and Update statement, the field names must be enclosed in brackets.

 

 The Query Statement is used to distinguish which documents are going to be processed by the crawler.

 

info

Multiple statements must be separated by semicolons.

 

 The Update Statement is used to update documents that have already been processed by the crawler.

 

info

For example, the source system contains the field 'Copied' and the default value 'false'. After successful processing, the crawler will set this field to 'true'.

If the Operation Mode is set to copy, this statement is mandatory to prevent repeated processing of the same documents.

Ā© 2024 Therefore Corporation, all rights reserved.