Unified CCE Data Server

Unified CCE Data Server

This chapter contains the configuration procedures you must perform for the Unified CCE Data Servers on Side A and Side B.

Configure SQL Server

Procedure
    Step 1   Go to Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio.
    Step 2   Log in.
    Step 3   Expand Security and then Logins.
    Step 4   If the BUILTIN\Administrators group is not listed:
    1. Right-click Logins and select New Login.
    2. Click Search and then Locations to locate BUILTIN in the domain tree.
    3. Type Administrators and click Check Name and then OK.
    4. Double-click BUILTIN\Administrators.
    5. Choose Server Roles.
    6. Make sure that public and sysadmin are both checked.

    Configure Domain Manager

    DO THIS ONCE, on the first Unified Data Server that you configure.

    Procedure
      Step 1   Choose Start > All Programs > Cisco Unified CCE Tools > Domain Manager.
      Step 2   Log in as a user who has permissions to create OUs in the domain.
      Step 3   In the pane on the left, expand the domain.
      Step 4   Add the Cisco Root as Cisco_ICM, :
      1. Under Cisco root, click Add.
      2. Select the organizational unit (OU) under which you want to create the Cisco Root OU, then click OK.
      Step 5   Add the facility organizational unit (OU):
      1. In the right pane, under Facility, click Add.
      2. Enter the name for the Facility. Then click OK.
      Step 6   Add the Instance OU:
      1. In the right pane, under Instance, click Add.
      2. Enter the instance name and click OK.
      Step 7   Click Close.

      Set up the Instance

      Procedure
        Step 1   Launch the Unified CCE Web Setup.
        Step 2   Sign in using as domain user having local Administrator rights.
        Step 3   Click Instance Management, and then click Add.
        Step 4   On the Add Instance page, configure as follows:
        1. Choose the facility and instance.
        2. In the Instance Number field, enter 0.
        Step 5   Click Save.

        Configure the Logger

        Configure Logger database and log

        Procedure
          Step 1   Choose Start > All Programs > Cisco Unified CCE Tools > ICMdba. If you see warnings, click Yes to dismiss them.
          Step 2   Navigate to Server > Instance.
          Step 3   Right-click the instance name and choose Create.
          Step 4   In the Select Component dialog box, choose the logger you are working on ( Logger A or Logger B). Click OK.
          Step 5   At the prompt, "SQL Server is not configured properly. Do you want to configure it now?" Click Yes.
          Step 6   On the Configure page, in the SQL Server Configurations pane check the defaults for Memory (MB) and Recovery Interval. Click OK.
          Step 7   On the Stop Server page, click Yes to stop the services.
          Step 8   In the Select Logger Type dialog box, choose Enterprise. Click OK to open the Create Database dialog box.
          Step 9   Create the Logger database and log as follows:
          1. In the DB Type field, choose the Side (A or B).
          2. In the Storage pane, click Add.
          3. Click Data
          4. Choose the E drive.
          5. Enter 665600 MB in the Size field.
          6. Click OK to return to the Create Database dialog box.
          7. Click Add again.
          8. Choose the E drive.
          9. Enter 3072MB in the Size field.
          10. Click OK to return to the Create Database dialog box.
          Step 10   In the Create Database dialog box, click Create. Then click Start.

          When you see the successful creation message, click OK and then Close.


          Configure Logger component in Web Setup

          Procedure
            Step 1   Configure the logger component as follows:
            1. Return to Unified CCE Web Setup. You might need to log in again.
            2. Choose Component Management > Loggers. Click Add. Choose the Instance.
            3. On the Deployment page, click Duplexed. Click Next.
            4. On the Central Controller Connectivity page, enter the host names for Sides A and B for the Router Private Interface and Logger Private Interface.
            5. Click Next.
            Step 2   On the Additional Options page:
            1. If an external AW-HDS-DDS exists in the deployment, check Enable Historical/Detail Data Replication.
            2. Check Display Database Purge Configuration Step.
            3. Click Next.
            Step 3   On the Data Retention page, modify the Database Retention Configuration table:
            1. For these tables, set the retention period to 40.
              • Application_Event
              • Event
              • Network_Event
              • Route_Call_Detail
              • Route_Call_Variable
              • Termination_Call_Detail
              • Termination_Call_Variable
            2. Set the retention period for all other tables to 400 days.
            3. Click Next,
            Step 4   On the Data Purge page, configure purge for a day of the week and a time when there is low demand on the system.
            Step 5   Accept the default Automatic Purge at Percent Full.
            Step 6   Click Next.
            Step 7   Review the Summary page, and then click Finish.

            Apply Base Configuration

            About Base Configuration

            The base configuration performs the following functions on the system:

            Creates core system objects to support call routing and dial plan for Packaged CCE.

            Creates two Peripheral Gateways:

            • One Generic PG with 1 CUCM PIM and 4 CVP PIMs
            • One MR PG with 2 PIMs - one for Outbound and one for Multichannel

            Sets intelligent application defaults for the Packaged CCE deployment model:

            • Default Agent Desk Settings record
            • Enables ECC Variables
            Create configuration objects to support CVP:
            • A type 10 Network VRU for CVP along with Network VRU Labels to send calls to CVP
            • CVP ECC Variables
            • VXML_Server Network VRU Script - GS,V microapp

            Creates configuration objects to support Multichannel Configuration:

            • A Network VRU for the MR PG
            • Application Instance for Multichannel
            • Media Classes for Multichannel

            Apply Base Configuration for Fresh Installs Only

            The Base Configuration is run once on a fresh installation of Packaged CCE. If you have already applied the base configuration to Packaged CCE and are upgrading to a later release of Packaged CCE, do not download the base configuration a second time—in this instance, apply configuration changes manually.

            Related References

            Run Base Configuration Using the ICMDBA Tool

            This task is required for a fresh install. The procedure is run on the CCE Data server on Side A.
            Procedure
              Step 1   Download the base configuration zip file from Cisco.com > Download Software > Packaged Contact Center Enterprise Configuration Scripts: http:/​/​software.cisco.com/​download/​type.html?mdfid=284360381&i=rm. Save it locally and unzip it.
              Step 2   Download the Domain_Update_Tool.zip file from the same location. Save it locally and unzip it.
              Step 3   Open the ICMDBA Tool on the CCE Data Server on Side A.
              Step 4   Select the CCE Data Server and expand the tree to <instance name>_sideA.
              Step 5   Select Data on the menu bar and click Import.
              Step 6   Browse to locate the configuration folder and click Open.
              Step 7   Click OK and then click Import.
              Step 8   Click Start and then click OK on all messages.
              Step 9   Navigate to the folder Domain_Update_Tool and right-click UpdateDomain.PS1. and Run with PowerShell. Respond as follows:
              1. For Server name, enter the computer name of the CCE Data Server Side A.
              2. For Database name, enter <instance_sideA>.
              3. For Domain Name, enter the customer's domain name.
              Step 10   Return to the ICMDBA tool.
              1. Click the logger database (<instance_sideA).
              2. Open Data on the menu bar and click Synchronize.
              3. Under the Target Pane, select the CCE Data Server on Side B.
              4. Enter the database name as <instance name>_sideB for the target side.
              5. Click Synchronize.
              Step 11   Click Start.
              Step 12   Click Yes for all messages.
              Step 13   Click Close.

              Configure AW database and log

              Procedure
                Step 1   Choose Start > All Programs > Cisco Unified CCE Tools > ICMdba. Click Yes at the warnings.
                Step 2   Navigate to Server > Instance.
                Step 3   Right-click the instance name and choose Create.
                Step 4   At the Select Component screen, choose Administration & Data Server.
                Step 5   In the Select AW Type dialog box, choose Enterprise. Click OK to open the Create Database dialog box.
                Step 6   Create the database and log as follows:
                1. In the DB Type field, choose AW.
                2. In the Storage pane, click Add.
                3. Click Data
                4. Choose the C drive.
                5. Enter 1400 MB in the Size field.
                6. Click OK to return to the Create Database dialog box.
                7. Click Add again.
                8. In the Add Device dialog box, click Log.
                9. Choose the C drive.
                10. Enter 100 MB in the Size field.
                11. Click OK to return to the Create Database dialog box.
                Step 7   In the Create Database dialog box, click Create. Then click Start.

                When you see the successful creation message, click OK and then Close.


                Configure Administration Server and Real-Time Data Server components

                Procedure
                  Step 1   Go to the Unified CCE Web Setup.
                  Step 2   Choose Component Management > Administration & Data Servers. Click Add.
                  Step 3   On the Add Administration & Data Servers page, configure as follows:
                  1. Choose the current instance
                  2. Click Enterprise. Then click Small to Medium Deployment Size.
                  3. Click Next.
                  Step 4   On the Role page, choose the option Administration Server and Real-time Data Server (AW). Click Next.
                  Step 5   On the Administration & Data Servers Connectivity page for Side A:
                  1. Click the radio button for Primary Administration & Data Server.
                  2. In the *Secondary Administration & Data Server field, enter the hostname for the Side A server.
                  3. In the *Primary/Secondary Pair (Site) Name field, enter AW_SideA.
                  4. Click Next.

                  OR, on the Administration & Data Servers Connectivity page for Side B:

                  1. Click the radio button for Primary Administration & Data Server.
                  2. In the *Secondary Administration & Data Server field, enter the hostname for the Side B server.
                  3. In the *Primary/Secondary Pair (Site) Name field, enter AW_SideB.
                  4. Click Next.
                  Step 6   On the Database and Options page, configure as follows:
                  1. In the Create Database(s) on Drive field, choose C.

                  2. Do not click Agent Re-skilling or Configuration Management Service.
                  3. Do not click the Agent Re-skilling Web Tool.
                  4. Check Internet Script Editor (ISE) Server.
                  5. Click Next.
                  Step 7   On the Central Controller Connectivity page, configure as follows:
                  1. For Router Side A, enter the Call Server Side A Public hostname.
                  2. For Router Side B, enter the Call Server Side B Public hostname.
                  3. For Logger Side A, enter the Data Server Side A Public hostname.
                  4. For Logger Side B, enter the Data Server Side B Public hostname.
                  5. Enter the Central Controller Domain Name.
                  6. Select Central Controller Side A Preferred or Central Controller Side B Preferred, based on what side you are on.
                  7. Click Next.
                  Step 8   Review the Summary page, and then click Finish.

                  Configure Unified Intelligence Center SQL user account

                  Procedure
                    Step 1   Go to Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio.
                    Step 2   Log in.
                    Step 3   Navigate to Security >Logins, right-click Logins and select New Login.

                    This login is used when you configure the data sources for Cisco Unified Intelligence Center reporting.

                    Step 4   On the General Screen:
                    1. Enter the Login Name.
                    2. Select SQL Server authentication.
                    3. Enter and confirm the Password.
                    4. Uncheck Enforce password policy.
                    Step 5   Click User Mapping.
                    1. Check the databases associated with Side A and AWdb.
                    2. Choose each database and associate it with the db_datareader and public roles, and click OK.