Bookshelf Home | Contents | Index | PDF     

Siebel Data Warehouse Installation and Administration Guide > Installing the Usage Accelerator >

Installing the Usage Accelerator

The Usage Accelerator installation process consists of installing the Usage Accelerator application and importing seed data into the transactional database.

You install the Usage Accelerator application using the standard Siebel Analytics Installer. The installation options that are available to you depend on the license key you enter.

To install the Usage Accelerator application

  1. In the Siebel Analytics Installer, click Next in the Welcome screen.
  2. Accept the terms of the license agreement.
  3. Browse for the appropriate license key file.
  4. Select the Usage Accelerator installation option.

    The Installer installs the application on your machine.

  5. Import new transactional database schema definitions required for running the ETL process for the Usage Accelerator.
    1. Copy the following file:
      Copy
      From
      To

      SRW_753_77_Plus_UA.sif

      SiebelAnalytics\dwrep

      \tools\objects
    2. Open Siebel Tools and point to the development database.
    3. Navigate to Repository > Import from Archive, and select the file SRW_753_77_Plus_UA.sif.
    4. Click Open.

      The Import Wizard—Preview screen appears, listing the Analytics Bridge tables.

    5. Click Next.

      NOTE:  All the objects imported in this process should be new to your repository; therefore, there should be no conflict due to an import. In case of conflict, in the Conflict Resolution area, select the option Merge the object definition from the archive file with the definition in the repository.

    6. A dialog box appears, informing you that the operation will modify your repository and asking if you want to proceed. Click Yes.
    7. The Import Wizard — Summary screen appears, showing a summary of the .sif changes to the repository files. Click Finish.
  6. Apply the new schema definitions to the transactional database:
    1. In Siebel Tools, go to the Table screen. Enter the following search string:

    S_ETL_PARAM or S_ETL_SRC_TABLE or S_NQ_ACCT or S_NQ_JOB or S_ETL_R_IMG_* or S_ETL_D_IMG_* OR S_ETL_I_IMG_*

    You should see the following tables:

    • S_ETL_D_IMG_1
    • S_ETL_D_IMG_10 to S_ETL_D_IMG_13
    • S_ETL_D_IMG_133 to S_ETL_D_IMG_139
    • S_ETL_D_IMG_14
    • S_ETL_D_IMG_140 to S_ETL_D_IMG_147
    • S_ETL_D_IMG_15 to S_ETL_D_IMG_19
    • S_ETL_D_IMG_2
    • S_ETL_D_IMG_20 to S_ETL_D_IMG_29
    • S_ETL_D_IMG_3
    • S_ETL_D_IMG_30 to S_ETL_D_IMG_39
    • S_ETL_D_IMG_4
    • S_ETL_D_IMG_40 to S_ETL_D_IMG_49
    • S_ETL_D_IMG_5
    • S_ETL_D_IMG_50 to S_ETL_D_IMG_59
    • S_ETL_D_IMG_6
    • S_ETL_D_IMG_60 to S_ETL_D_IMG_69
    • S_ETL_D_IMG_7
    • S_ETL_D_IMG_70 to S_ETL_D_IMG_79
    • S_ETL_D_IMG_8
    • S_ETL_D_IMG_80 to S_ETL_D_IMG_83
    • S_ETL_D_IMG_9
    • S_ETL_I_IMG_1
    • S_ETL_I_IMG_10 to S_ETL_I_IMG_13
    • S_ETL_I_IMG_133 to S_ETL_I_IMG_139
    • S_ETL_I_IMG_14
    • S_ETL_I_IMG_140 to S_ETL_I_IMG_147
    • S_ETL_I_IMG_15 to S_ETL_I_IMG_19
    • S_ETL_I_IMG_2
    • S_ETL_I_IMG_20 to S_ETL_I_IMG_29
    • S_ETL_I_IMG_3
    • S_ETL_I_IMG_30 to S_ETL_I_IMG_39
    • S_ETL_I_IMG_4
    • S_ETL_I_IMG_40 to S_ETL_I_IMG_49
    • S_ETL_I_IMG_5
    • S_ETL_I_IMG_50 to S_ETL_I_IMG_59
    • S_ETL_I_IMG_6
    • S_ETL_I_IMG_60 to S_ETL_I_IMG_69
    • S_ETL_I_IMG_7
    • S_ETL_I_IMG_70 to S_ETL_I_IMG_79
    • S_ETL_I_IMG_8
    • S_ETL_I_IMG_80 to S_ETL_I_IMG_83
    • S_ETL_I_IMG_9
    • S_ETL_R_IMG_1
    • S_ETL_R_IMG_10 to S_ETL_R_IMG_13
    • S_ETL_R_IMG_133 to S_ETL_R_IMG_139
    • S_ETL_R_IMG_14
    • S_ETL_R_IMG_140 to S_ETL_R_IMG_147
    • S_ETL_R_IMG_15 to S_ETL_R_IMG_19
    • S_ETL_R_IMG_2
    • S_ETL_R_IMG_20 to S_ETL_R_IMG_29
    • S_ETL_R_IMG_3
    • S_ETL_R_IMG_30 to S_ETL_R_IMG_39
    • S_ETL_R_IMG_4
    • S_ETL_R_IMG_40 to S_ETL_R_IMG_49
    • S_ETL_R_IMG_5
    • S_ETL_R_IMG_50 to S_ETL_R_IMG_59
    • S_ETL_R_IMG_6
    • S_ETL_R_IMG_60 to S_ETL_R_IMG_69
    • S_ETL_R_IMG_7
    • S_ETL_R_IMG_70 to S_ETL_R_IMG_79
    • S_ETL_R_IMG_8
    • S_ETL_R_IMG_80 to S_ETL_R_IMG_83
    • S_ETL_R_IMG_9
    • S_ETL_PARAM
    • S_ETL_SRC_TABLE
    • S_NQ_ACCT
    • S_NQ_JOB
    1. Select all these tables, and click Apply at the top of the screen.
    2. In the Apply Schema dialog box, under the entry Tables, select Current Query from the dropdown list.
    3. Under the subsequent entries, enter the connection parameters for the development database. (Your connection information will vary depending on your particular database platform and on the configuration of your particular database environment.)
    4. Click Apply.
  7. Import repository objects to enable embedded Analytics.

    NOTE:  This step is required only if are planning to use the Usage Accelerator in an integrated environment with a Siebel eBusiness application version 7.5.3.

    1. Lock the following projects:
      • Analytics
      • ERM
      • Siebel Field Service
      • Siebel Marketing Enterprise
      • Siebel Channel
      • Siebel Sales Enterprise
      • Siebel Service Enterprise
      • Siebel Universal Agent
    2. Copy the following file:
      Copy
      From
      To

      SRW_753_77_Plus_UA_Integration_objects.sif

      SiebelAnalytics\dwrep

      \tools\objects
    3. In Siebel Tools, navigate to Repository > Import from Archive, and select the file SRW_753_77_Plus_UA_Integration_objects.sif.
    4. Click Open.

      The Import Wizard—Preview displays a list of tables.

    5. In the Conflict Resolution area, select the option Merge the object definition from the archive file with the definition in the repository, and click Next.

      NOTE:  Do not select the Overwrite option, because this will delete existing objects in the repository.

    6. The Import Wizard—Summary screen displays a summary of the .sif changes to the repository files. Click Finish.
  8. Recompile the SRF file.

    NOTE:  This step is required only if are planning to use the Usage Accelerator in an integrated environment with a Siebel eBusiness application version 7.5.3.

    1. In Windows Explorer, navigate to \tools\objects\enu, and rename the siebel.srf file.
    2. In Siebel Tools, navigate to Tools > Compile Projects, and select the Locked Projects radio button.
    3. Under Siebel Repository, select the new SRF file you created in Step a, and click Compile.

      To see the Usage Accelerator screen in your application, the new SRF file must replace the siebel.srf file you were using.

  9. Confirm the Analytics Server name to run Embedded Analytics.

    NOTE:  This step is required only if are planning to use the Usage Accelerator in an integrated environment with a Siebel eBusiness application version 7.5.3.

    1. Log in to the Siebel application as the administrator.
    2. Navigate to Site Map > Administration - Integration > WI Symbolic URL List.
    3. In the Administration - Integration screen, from the visibility filter, select Host Administration.
    4. In the Host Administration list, locate the record Name=[AnalyticsServerName].
    5. Change [AnalyticsServerName] to the name of the machine hosting your Analytics Server.
  10. Import language-independent Siebel seed data.
    1. Copy the appropriate seed data files:
      Copy
      From
      To

      seed_753_77_plus.dat

      SiebelAnalytics\dwrep

      Local machine

      seed_753_77_plus_<xxx>.inp
      where xxx corresponds to the database platform you are using

      SiebelAnalytics\dwrep

      Local machine
    2. Open a command line, and go to the same directory where you copied the .dat and .inp files.
    3. Replace each of the connection parameters with the values appropriate to your database environment, and then run the appropriate import command from the following table.
      .
      Database Platform
      Run Import Command

      DB2UDB

      $SIEBELSERVERROOT\bin\dataimp /u $UserName /p $Password /c "$ODBCDataSource" /d $DatabaseOwner /f seed_753_77_plus.dat /w y /q 100 /h Log /x f /i seed_753_77_plus_db2udb.inp /l
      seed_753_77_plus_db2udb.log

      MSSQL

      $SIEBELSERVERROOT\bin\dataimp /u $UserName /p $Password /c "$ODBCDataSource" /d $DatabaseOwner /f seed_753_77_plus.dat /w y /q 100 /h Log /x f /i seed_753_77_plus_mssql.inp /l
      seed_753_77_plus_mssql.log

      Oracle

      $SIEBELSERVERROOT\bin\dataimp /u $UserName /p $Password /c "$ODBCDataSource" /d $DatabaseOwner /f seed_753_77_plus.dat /w y /q 100 /h Log /x f /i seed_753_77_plus_oracle.inp /l
      seed_753_77_plus_oracle.log
  11. Associate the new Usage Accelerator responsibilities with the users whom you want to see the Usage Accelerator screen.

    The Usage Accelerator responsibilities are the following:

    • Usage Accelerator Tracking
    • Usage Accelerator - Sales Rep
    • Usage Accelerator - Sales Manager
    • Usage Accelerator - Sales Executive
    • Usage Accelerator - Administrator
    
Siebel Data Warehouse Installation and Administration Guide