Siebel Analytics Installation and Configuration Guide > Localizing Siebel Analytics Deployments > Process of Maintaining Translation Tables for Analytics >

Externalizing Metadata Strings


This task is part of the Process of Maintaining Translation Tables for Analytics.

Metadata Strings are loaded by the Siebel Analytics Server from a database table. In the case of Siebel Analytics applications, this table is S_MSG in the Siebel transactional database. The initialization block Externalize Metadata Strings loads the strings for the Server. It is recommended that you run a test to make sure that this initialization block runs successfully. An example of the translation table is shown in Table 45.

Table 45.  Example of S_MSG Translation Table
MSG_NUM
MSG_TEXT
LANG_ID

CN_Customer_Satisfaction

Customer Satisfaction

ENU

CN_Customer_Satisfaction

Kundenzufriedenheit

DEU

CN_Customer_Satisfaction

Satisfação do cliente

PTB

By default, the Siebel Analytics repository is configured to run in English only. To deploy in any other language, you must externalize the metadata strings, as described in the following procedure.

To externalize metadata strings in the Siebel Analytics repository

  1. Stop the Siebel Analytics Server.
  2. Open SiebelAnalytics.rpd using the Server Administration Tool in offline mode.
  3. Select the entire Presentation layer and right-click the mouse to display the menu.
    1. From the pop-up menu, select Externalize Display Names. A check mark appears next to this option the next time you right-click on the Presentation layer.

      NOTE:  When Externalize Display Names is checked, all metadata strings are read from an external Siebel transactional database, specifically from the S_MSG table.

    2. Unselect the Presentation layer.
  4. In the Physical layer, select the Externalized Metadata Strings database icon.

    Expand the tree.

  5. Double-click Internal System Connection Pool. The Connection Pool window opens.

    In the General tab, the field Data source name should point to the Siebel operational application database.

  6. Click OK and exit the Server Administration Tool.
  7. Restart the Siebel Analytics Server.
Siebel Analytics Installation and Configuration Guide