1. Configuring Siebel Business Applications
  2. Overview of the Case Insensitivity Wizard

Overview of the Case Insensitivity Wizard

The Case Insensitivity Wizard is a tool you can use to configure a column to support a CIAI query. This wizard does the following work:

  • If you use an input file, then validates the format of all records in the input file. For more information, see Input File You Can Use with the Case Insensitivity Wizard.

  • Validates that all tables and columns are eligible for CIAI configuration. For more information, see How the Case Insensitivity Wizard Verifies Eligibility.

  • For each eligible base column, defines a new CIAI column and a CIAI index in the Siebel repository. The CIAI column contains data in the base column. The wizard converts this data to uppercase. For more information, see Index Strategy Variable of the Case Insensitivity Wizard.

  • Sets the Default Insensitivity property for the base column to DB Case & Accent. You can run the Case Insensitivity Wizard in a special mode to set the Default Insensitivity property on columns that do not contain an index.

  • Sets flags and does other configuration operations in the Siebel repository that Siebel CRM requires to support a CIAI query.

Siebel Tools does not create columns or indexes in the Siebel database until you compile the Siebel repository.