Preparing Databases for Full-Text Search - Advanced Design and Setup - Foundation 23.2 - Foundation 23.2 - Ready - Content Composer - external

Content Composer Advanced Design and Setup

Platform
Content Composer
Product
Advanced Design and Setup
Release
Foundation 23.2
License

Oracle

The required Oracle Text index is part of a standard Oracle configuration.

Depending on the operating system in use, it might be necessary to add an appropriate XPS extension.

SQL Server

Check the availability of the SQL Full Text index on your system.

Information on full-text search can be found here:

http://msdn.microsoft.com/en-us/library/ms403375%28SQL.90%29.aspx

http://technet.microsoft.com/en-us/library/ms142497.aspx

http://technet.microsoft.com/en-us/library/ms142499.aspx

IFilters

The search inside binary files requires IFilters, for example for .PDF and MS Office files:

Adobe PDF IFilter 9 (64-bit) Link: ftp://ftp.adobe.com/pub/adobe/acrobat/win/9.x/

File name: PDFiFilter64Installer.zip

Microsoft Office 2010 Filter Packs http://www.microsoft.com/download/en/details.aspx?id=17062
Microsoft XPS Viewer (Windows 7, Windows 2008 Server) Make sure the MS XPS Viewer is installed or, in Windows 2008 R2, the corresponding feature is enabled.
  1. Download and install the appropriate filters.

  2. Execute this code on your SQL Server:

    exec sp_fulltext_service 'load_os_resources', 1;
    exec sp_fulltext_service 'verify_signature', 0;
    go
    
  3. Restart SQL server and check if IFilters are installed, for example .PDF and .DOCX.

    exec sp_help_fulltext_system_components 'filter';

XPS Extension

Depending on the operating system in use, it might be necessary to add an appropriate XPS extension.