<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
color:black;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I am routinely loading CDRs into off-line
MS-SQL db. The process is quite simple. I just copied 4.x CCM database and made
some schema adjustments to conform to 5.x. I use DTS to import the CDRs into
the off-line DB.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mord<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Benjamin Amezcua<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, June 10, 2008 1:32
PM<br>
<b><span style='font-weight:bold'>To:</span></b> cisco-voip@puck.nether.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> [cisco-voip] Store CDR's
in SQL Database with CCM 5.0.4</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>Hi all,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>I need to send CDRs to
a SAP server in real-time (or ASAP). To do it we need to store CDR in MySQL.
Any of you know if it is possible to store CDRs from Cisco Call Manager 5.0.4
to MySQL or any Database?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:black'>Regards,<o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=2
color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><st1:PersonName
style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
tabIndex="0" w:st="on"><b><font size=2 color=black face=Arial><span
lang=ES-TRAD style='font-size:10.0pt;font-family:Arial;color:black;font-weight:
bold'>Benjamin Amezcua</span></font></b></st1:PersonName><b><font size=2
color=black face=Arial><span lang=ES-TRAD style='font-size:10.0pt;font-family:
Arial;color:black;font-weight:bold'> Guzman</span></font></b><font size=2
color=black face=Arial><span lang=ES-TRAD style='font-size:10.0pt;font-family:
Arial;color:black'><br>
<i><span style='font-style:italic'>Responsable de proyectos VoIP</span></i></span></font><font
color=black><span lang=ES-TRAD style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=ES-TRAD
style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font><font
color=black><span lang=ES-TRAD style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=ES-TRAD
style='font-size:10.0pt;font-family:Arial;color:black'>Telcom Business
Solutions S.L.<br>
Servicios de Telecomunicaciones</span></font><font color=black><span
lang=ES-TRAD style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=ES-TRAD
style='font-size:10.0pt;font-family:Arial;color:black'> </span></font><font
color=black><span lang=ES-TRAD style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=ES-TRAD
style='font-size:10.0pt;font-family:Arial;color:black'>C/ Graham Bell, Edificio
Hevimar, 1º oficina 14<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=ES-TRAD
style='font-size:10.0pt;font-family:Arial;color:black'>Parque Tecnológico de
Andalucía<br>
29590 Málaga<br>
Telf. +34 902 021 270</span></font><font color=black><span lang=ES-TRAD
style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=ES-TRAD
style='font-size:10.0pt;font-family:Arial;color:black'>Fax: +34 902 021
271</span></font><font color=black><span lang=ES-TRAD style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=ES-TRAD
style='font-size:10.0pt;font-family:Arial;color:black'>E-mail: </span></font><font
size=2 color="#336699" face=Arial><span lang=ES-TRAD style='font-size:10.0pt;
font-family:Arial;color:#336699'><a href="mailto:ben@telbs.com"><font
color=black><span style='color:black'>ben@telbs.com</span></font></a></span></font><font
size=2 color=black face=Arial><span lang=ES-TRAD style='font-size:10.0pt;
font-family:Arial;color:black'><br>
web: </span></font><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'><a href="http://www.telbs.com/"
target="_blank"><font color=black><span lang=ES-TRAD style='color:black'>http://www.telbs.com</span></font></a></span></font><font
color=black><span lang=ES-TRAD style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=ES-TRAD
style='font-size:10.0pt;font-family:Arial;color:black'> </span></font><font
color=black><span lang=ES-TRAD style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=ES-TRAD
style='font-size:10.0pt;font-family:Arial;color:black'> AVISO LEGAL: <br>
Este mensaje está dirigido únicamente a la/s dirección/es indicada/s anteriormente.
El mismo, como sus ficheros anexos, en su caso, contienen <st1:PersonName
style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
tabIndex="0" w:st="on">info</st1:PersonName>rmación confidencial y es de uso
exclusivo de su destinatario. Se prohíbe la revelación, copia, reenvío o uso no
autorizado, completo o en parte, del contenido del mismo, sin previa
autorización del remitente.<br>
Si ha recibido este mensaje por error, comuníquelo inmediatamente, por esta
misma vía, a la persona que lo ha enviado y, a continuación, elimine el mensaje
junto con sus ficheros anexos sin leerlo ni almacenarlo en ningún tipo de
soporte. </span></font><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>Gracias.<br>
This e-mail including any attachments is confidential and may be legally
privileged. If you have received it in error please advise the sender
immediately by return email and then delete it from your system. The
unauthorised use, distribution, copying or alteration of this email is strictly
forbidden.</span></font><font color=black><span style='color:black'><o:p></o:p></span></font></p>
</div>
</body>
</html>
<BR>
<P><FONT SIZE=2>No virus found in this incoming message.<BR>
Checked by AVG.<BR>
Version: 7.5.524 / Virus Database: 270.2.0/1494 - Release Date: 6/10/2008 7:22 AM<BR>
</FONT> </P>
<P><FONT SIZE=2 FACE="Arial"> </FONT> </P><BR>
<P><FONT SIZE=2>No virus found in this outgoing message.<BR>
Checked by AVG.<BR>
Version: 7.5.524 / Virus Database: 270.2.0/1494 - Release Date: 6/10/2008 7:22 AM<BR>
</FONT> </P>