12-29-2014 01:57 AM - edited 03-17-2019 01:26 AM
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
Solved! Go to Solution.
12-29-2014 05:29 PM
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.
12-29-2014 03:03 AM
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
12-29-2014 08:40 AM
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.
12-29-2014 05:09 PM
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
12-29-2014 05:29 PM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide