Creating a Collector archive

A Collector archive is used to store output documents and related metadata to be accessed from StreamStudio Collector.

You can either create the Collector archive directly in Control Center, or you can generate the database scripts in Control Center and then run the scripts using an external tool. For example, if the company security policy prevents Control Center from connecting to the database, or if you want to have full traceability of the repository creation.

Prerequisites

•	Microsoft SQL Server and Oracle Database can be used for the Collector archive.

•	The Collector archive must use the same database vendor as StreamServe Enterprise Repository and the runtime repository.

•	The Collector archive can be created in any reachable database – either in the same database as the runtime and web content repositories or on a separate database server. The fact that the Collector archive may contain large amounts of data must be considered.

Post requisites

The created Collector archive is sufficient for development and testing purposes. In a production environment, you must adjust the archive to fit the actual conditions (for example, configure filegroups, size and file growth parameters, etc). You can adjust the repository using an external tool.

Improve search performance by using indexes By indexing the metadata used in Collector searches, search performance can be improved. For more information, see the OpenText StreamServe Database Guidelines for your database vendor. Note that increasing the number of indexes may have negative effect on the insert performance.

In this section

•	Adding and configuring a Collector archive

•	Creating a Collector archive from Control Center

•	Creating a Collector archive manually

Related documentation

•	OpenText StreamServe Microsoft SQL Server Database Guidelines

•	OpenText StreamServe Oracle Database Database Guidelines

The documents are available at OpenText Knowledge Center.