Cisco Unified Call Manager up to V4.x

These instructions should assist in configuring your Aastra BP to work with TIM Enterprise. If you are not familiar with PBX configuration, please contact your system maintainer.

Configuring Cisco Unified Call Manager

By default the CDRs are not written to the MS SQL Database. The following 'Service' parameters need to be enabled on the Publisher using the Service Parameters Configuration window:

• CDR Enabled
• CDR Log CallsWith Zero Duration Flag
• Call Diagnostics Enabled

The database that TIM Enterprise will connect to what is called 'CDR'. Within this database there is a table called 'CallDetailRecord'. Rather than TIM Enterprise reading and removing data from the 'CallDetailRecord' table we highly recommend that you setup a second table which is a replication of the 'CallDetailRecord' table. This leaves the original table intact and can be used by other applications that may require it. There should be a SQL User already created with the following credentials:

• Username: CiscoCCMCDR
• Password: dipsy

To setup replication you will need to speak to your Database Administrator or your Cisco UCM maintainer. The replicated table name should be called 'calldetailrecord2'.

Please make sure that when the replication is setup that the above user has full access to the new table.

You will need to know the following information for TIM Enterprise to connect successfully to the Cisco UCM CDR database:

• IP/DNS of the MS SQL Database which is located on the Publisher.
• Username and Password to connect to the CDR database (you may need to speak to your maintainer about this).

Setting up a DSN connection for TIM Enterprise

You will need to setup a DSN connection for TIM Enterprise to work with the Cisco UCM. Below you will find instructions on how to do this within Microsoft Windows:

1. Click on Windows Start.
2. Click on Control panel.
3. Double click on Administrative tools icon.
4. Double click on Data Sources (ODBC) icon.
5. Click on the System DSN tab.
6. Click on the Add button.
7. Select MySQL ODBC 3.51 Driver from the list and click Finish. If you cannot see the MySQL ODBC 3.51 Driver you will need to download this from http://www.mysql.com.
8. In the Name field enter the following: 'shoretel'.
9. In the Description field enter the following: 'TIM Enterprise link to ShoreTel'.
10. In the Server field enter the IP Address of the ShoreWare Server.
11. In the Username field enter the username that was created for the ShoreWareCDR database.
12. In the Password field enter the password that was created for the ShoreWareCDR database.
13. In the Database drop-down list select 'ShoreWareCDR'.
14. Now click on the Test button which will confirm if the information you entered is correct and connection is successful.
15. Click on the OK button and then again to close the window.

Configuring TIM Enterprise

Below you will find steps on how to configure TIM Enterprise to listen for SMDR data from your Aastra BP:

1. Browse to TIM Enterprise as normal and login with your credentials.
2. Click on the Directory tab.
3. Go the the point in the Directory where you need to add the PBX Object and add a PBX with the name 'Aastra BP'.
4. Left-click on it and select Properties.
5. From the General settings tab select Aastra BP from the PBX model list.

6. In the Connection tab select No connection required from the Connection method list.
7. Finally, click on the Save button.