cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
1604
Views
0
Helpful
4
Replies
Highlighted
Beginner

How to import CDR data from CUCM 9.1.2 to SQL Server 2008?

Hello guys,

I've done to transfer CDR data to another server (billing server) by using sftp. Now I would like to know how to import these files to SQL Server 2008.

can anyone advise me?

Appreciate your help!

 

Regards,

Tan

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Hall of Fame Cisco Employee

That's up to you and the programming languages you want to use, you can use PHP for example, most programming languages have modules to interface with the DBs, you would need to

A) Build the DB schema with the fields you want

B) Write down the program and parse thru the info from the flat files to insert that into the DB

But all the above, is up to you, we don't have any guides as that has to be in-house development.

HTH

java

if this helps, please rate

View solution in original post

4 REPLIES 4
Highlighted
VIP Mentor

Tan

You don't import anything to the SQL server. You configure a sftp connection to the billing sender from the CDR  management page in cucm. The CDR data is then automatically exported to the billing server via sftp

 

Please rate all useful posts
Highlighted
Hall of Fame Cisco Employee

You would need to write down a program or script that turns the info in the flat files into something you can insert in SQL, as Deji says, all we provide, is the ability to send the flat files to an external server. The processing you do with those, or if you want to have them in a DB, is up to you.

HTH

java

if this helps, please rate
Highlighted

Hi Jaime,

Yes, I've tried to follow the link http://www.experts-exchange.com/Networking/Telecommunications/IP_Telephony/A_1922-Cisco-Call-Manager-6-CDR-SQL-server.html" but got the errors.

Could you tell me what is program or script to do that so I can insert in SQL?

Appreciate your help!

Regards,

Tan

 

Highlighted
Hall of Fame Cisco Employee

That's up to you and the programming languages you want to use, you can use PHP for example, most programming languages have modules to interface with the DBs, you would need to

A) Build the DB schema with the fields you want

B) Write down the program and parse thru the info from the flat files to insert that into the DB

But all the above, is up to you, we don't have any guides as that has to be in-house development.

HTH

java

if this helps, please rate

View solution in original post