Appendix A: Configuration
Netcool/Proviso Cisco IP Telephony Technology Pack User’s Guide, Version 4.3-W 443
The technology pack’s UBA is responsible for retrieving CCM data, using the Data Direct SQL server bridge
to do so. This bridge is part of the UBA installation. No additional software is required.
You need to set up the Data Direct SQL server bridge to get Call Detail Records from each CallManager
Publisher. The complete configuration is done by editing the $DC_HOME/conf/odbc.ini file as user
pvuser.
[ODBC Data Sources]
Your_Data_Source1=DataDirect 4.20 SQL Server Wire Protocol
Your_Data_Source2=DataDirect 4.20 SQL Server Wire Protocol
Your_Data_SourceN=DataDirect 4.20 SQL Server Wire Protocol
[Your_Data_Source1]
Driver=PVmsss20.so
Description=DataDirect 4.20 SQL Server Wire Protocol
Address=xx.xx.xx.xx,1433
AnsiNPW=Yes
Database=CDR
QuoteId=No
[Your_Data_Source2]
Driver=PVmsss20.so
Description=DataDirect 4.20 SQL Server Wire Protocol
Address=xx.xx.xx.xx,1370
AnsiNPW=Yes
Database=CDR
QuoteId=No
[Your_Data_SourceN]
Driver=PVmsss20.so
Description=DataDirect 4.20 SQL Server Wire Protocol
Address=xx.xx.xx.xx,1433
AnsiNPW=Yes
Database=CDR
QuoteId=No
[ODBC]
IANAAppCodePage=4
InstallDir=/opt/datachannel/
Trace=0
TraceDll=/opt/datachannel/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0
All fields above which appear in boldface red and must be configured according to your CallManager
Publisher environment, as follows:
Field Description
[ODBC Data
Sources] One entry per CallManager Publisher.
Note:
The data source name must match the data source name specified in the corresponding
URI (Uniform Resource Identifier) parameter in the dc.cfg file. Each line in this
section should also be associated with a subsection that configures the data source.