Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • IP address or hostname of the ShoreWare Server where the MySQL database resides.
  • Username and Password of the ShoreWareCDR database.

The default credentials for the ShoreWareCDR database are shown below:

Info

Username: st_cdrreport
Password: passwordcdrreport

HTML
<a id="Set up a DSN connection"></a>

...

  1. Open Windows Control Panel and select the Administrative Tools icon.
  2. Double-click on the Data Sources (ODBC) icon to open the ODBC Data Source Administrator window

    Info

    For a 64 bit system, access the ODBC Data Source Administrator from the following location C:\Windows\SysWOW64\odbcad32.exe

  3. Click on the System DSN tab.
  4. Click on the Add button.
  5. Select MySQL ODBC 3.51 Driver from the driver list and click Finish. If you cannot see the MySQL ODBC 3.51 Driver option in the drop-down list, you can download it from http://www.mysql.com.
  6. In the Name field, enter shoretel.
  7. In the Description field, enter TIM Enterprise link to ShoreTel.
  8. In the Server field, enter the IP address or hostname of your ShoreWare Server.
  9. In the Username field, enter the username for your ShoreWareCDR database.
  10. In the Password field, enter the password for your ShoreWareCDR database.
  11. In the Database drop-down list, select ShoreWareCDR.
  12. Click on the Test button to confirm the information you entered is correct and that the connection is successful.
  13. Click on the OK button to close the window.

...

  1. Click on the Directory tab.
  2. Choose Locate the PBX object you want to configure and click in the Directory, right-click on it and select Properties.
  3. A new window will open. In the General tab, select ShoreTel from the Data format list and tick
  4. the
  5. the 
    Keywordmacro
    LabelKeep a local backup of data
    box, as shown below:
    Screenshotmacro
    Borderfalse
    URL/download/attachments/3145781/shoretel_2.png

  6. In Click on the Connection tab , and select System DSN connection from the Connection method list.
  7. In the DSN field, select ShoreTel from the drop-down list.
  8. In the Frequency field, enter to check for data every five seconds.
  9. In the DB script field, select ShoreTel from the drop-down list.
  10. Click on the Save button to apply the settings.
    Screenshotmacro
    Borderfalse
    URL/download/attachments/3145781/shoretel_3.png