Creating Speech Application Log Analysis Tools Databases

  • Article

Creating Speech Application Log Analysis Tools Databases

Use Microsoft SQL Server 2000 Data Transformation Services (DTS) packages to create the Speech Application Reports and Call Viewer databases. It is possible to create the two databases in the same operation, or separately. Typically Call Viewer databases are created when there is a particular need for call analysis, while creating the Speech Application Reports database might only need to be done once.

The DTS user's account must be added to the db_datawriter role on both the SQL Server containing Reporting Services, and the server containing the Call Viewer and Speech Application Reports databases. For more information on using predefined roles in SQL Server, see the topic Adding a Member to a Predefined Role in the MSDN Library.

In order to receive useful error messages from the database import process, turn on package logging. For more information, see the topic Using DTS Package Logs in the MSDN Library.

Using DTS to Create Both Databases

DTS can be used to create both a Call Viewer and a Speech Application Reports database in a single operation.

To create both databases

  1. In SQL Server Enterprise Manager, expand the server that will contain the reports database.

  2. Expand Data Transformation Services.

  3. Right-click Local Packages and select New Package.

  4. In DTS Designer, on the Connection menu select Microsoft OLE DB Provider for SQL Server.

  5. On the Connection Properties dialog box, in New connection enter a name for the Call Viewer database connection, in Database select the database, select Use Windows Authentication, then click OK.

  6. Repeat the previous two steps, this time entering a name for the Speech Application Reports database connection.

  7. On the Task menu select Microsoft Speech Server Log Import Task.

  8. On the Microsoft Speech Server Log Import Task dialog box, check Import log files into Call Viewer database and select the appropriate database connection name in the dropdown list box. To enable filtering by event types, in Filter import by event types in file specify a text file containing a new line character-delimited list of events. For more information, see Microsoft Speech Server Log Import Task.

  9. Check Import log files into reporting database and select the appropriate database connection in the dropdown list box. Click Locate to browse for a SQL Server Reporting Services server. In Target report server folder name specify the folder where reports are created on the report server. The default is Speech Application Reports but it can be changed. Whenever a reports database import is executed, the Default Reports are uploaded to this folder, but will not overwrite any existing reports in this folder with the same name. For a new upload either delete the existing reports in the folder, or point the upload to a different folder.

    To extract additional event types, in File of additional event types to extract to the database specify a text file containing a list of events. For more information, see Importing Log Files.

  10. Click Add File and select the appropriate .etl log file. Click the file name to edit it. To add all .etl files in a folder, click Add Folder and select the folder in the Browse for Folder dialog box.

  11. Click Open and click OK.

  12. On the DTS Designer toolbar, click Execute.

    Note  In order to be able to use the Lookup tool associated with SQL Server Reporting Services base URL, the user must have permissions to run Windows Management Instrumentation (WMI) on the server hosting Reporting Services.
    Note  To use SQL authentication when creating Speech Application Log Analysis Tools databases, use the MSSLogToDatabase tool (MSSLogToDatabase.exe).

Using DTS to Create a Call Viewer Database

Follow the steps in the section Using DTS to Create Both Databases. Skip the step where the user enters a name for a Speech Application Reports database connection, and do not enter values for Speech Application Reports on the Microsoft Speech Server Log Import Task dialog box.

Using DTS to Create a Speech Application Reports Database

Follow the steps in the section Using DTS to Create Both Databases. Skip the step where the user enters a name for a Call Viewer database connection, and do not enter values for Call Viewer on the Microsoft Speech Server Log Import Task dialog box.

See Also

Using Microsoft SQL Server 2000 Data Transformation Services to Import Log Files | Using the MSSLogToDatabase Tool (MSSLogToDatabase.exe) to Import Log Files