Siebel Smart Answer Guide > Installing and Administering Siebel Smart Answer > Running the Command Line Administration Tutorial >

Configuring Siebel Smart Answer to Synchronize with Siebel Catalogs


By default Siebel Smart Answer assumes that the Siebel Database is named SIEBEL if the type of the database is Oracle. It assumes it is dbo, if the database is MSSQL. These default names are set at installation time. Your database name might not match these default names.

To configure Siebel Smart Answer to synchronize with Siebel Catalogs

  1. Navigate to the smart_answer_server\scripts directory.
  2. Open the file metaserver.config in Notepad or the editor of your choice.
  3. Add the parameters as described in the following table.
    Parameter
    Value

    siebel.query.catalog = SELECT ROW_ID FROM [DBNAME].S_CTLG WHERE NAME = ?

    Replace [DBNAME] with the name of your database.

    siebel.query.categories = SELECT ROW_ID, NAME, PAR_CAT_ID, RESP_THRESHOLD FROM [DBNAME].S_CTLG_CAT WHERE CTLG_ID =?

    Replace [DBNAME] with the name of your database.

Siebel Smart Answer Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.