Siebel Business Analytics Applications Installation and Administration Guide > Localizing Siebel Business Analytics Deployments > Process of Maintaining Translation Tables for Analytics >

Upgrading Siebel Business Analytics Seed Data for Non-English Locales

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

If Siebel Business Analytics data in your deployment is to be viewed in a language other than English, you must also import Locale seed data into the Siebel transactional (OLTP) database. This data allows the Analytics applications metadata to be viewed in non-English languages. Because this seed data is normally part of the Siebel operational application suite, you would have loaded part of this data when you installed the Siebel operational application. The additional task described in Importing Locale Seed Data into the Siebel Transactional Database updates the seed data and makes it current for the Siebel Business Analytics Applications. This process must be performed once for each language in which your data is to be viewed.

During the Siebel Business Analytics installation, a folder named $INSTALLDIR\SeedData was created, which contains a subfolder for each language. Within each language subfolder is a .dat file (the data to be imported) and an .inp file (the WHERE clause governing the import). For more information about these files, see the topic Importing Siebel Financial Services Metadata Files.

Importing Locale Seed Data into the Siebel Transactional Database

If the primary language being used is not English, you may have to import additional locale seed data (depending on the number of languages you use) as shown in the following procedure.

NOTE:  This procedure can be performed only by a Siebel Applications Administrator.

To import Locale seed data into the Siebel transactional database

1. Open a command window and navigate to SINSTALLDIR\SeedData\bin folder.
2. Run the import command in Step 3 after replacing the connection parameters shown in the following table with the values appropriate to your database environment.

   Import parameters:
   UserName
   Password
   ODBCDataSource
   DatabaseOwner

3. Run the import command:

   $INSTALLDIR\SeedData\bin\dataimp /u $UserName /p $Password /c "$ODBCDataSource" /d $DatabaseOwner /f $INSTALLDIR\SeedData\<XX>\analytics_seed_<XXX>.dat /w y /q 100 /h Log /x f /i $INSTALLDIR\SeedData\<XX>\metadata_upgrade_<XXX>_<DBPlatform>.inp /l metadata_upgrade_<XXX>.log

   NOTE:  Replace the XX with the Siebel Business Analytics two-letter language code (_fr, _it) and the XXX with the Siebel Systems three-letter code (FRA, ITA).

4. When you have finished importing the Locale seed data into the OLTP database, configure database connectivity to the machine on which the Siebel Analytics Server resides.

   Siebel Analytics Server uses the Siebel transactional database in order to read the metadata translations. Configure the database connectivity on the Siebel Analytics Server machine to the OLTP database, so that the server can load the appropriate translations for the languages you are using.

   NOTE:  Unicode connectivity can be used to access databases that do not support Unicode.