How To Save Cdr To An Odbc Connection

[Guest u4910]

I would like to save CDR information to a remote Oracle database through ODBC.

Is this set up in the config.xml file?

Do you have a .sql script to create the table (for the proper column names and format)?

Thanks!

[SupportTeam]

You can specify the alternative database in Config.xml, in the <Dialer> section. The same database is used to store both the outgoing calls and the CDRs (incoming and outgoing CDRs) and other information.

 

Please see: http://www.voiceguide.com/vghelp/source/ht...rnal_config.htm

 

At the bottom of that Help file page both your questions are answered:

 

The actual SQL script used by VoiceGuide to automatically create the database tables used by it can be found in VoiceGuide's \system\setup\ subdirectory. The default scripts used is named Db_Create.sql

 

ADO.NET Provider Specific versions of this script can be placed in the same files, with the Provider name incorporated into the filename as such:

 

Db_Create_ProviderName.sql

 

eg:

 

Db_Create_System.Data.SqlClient.sql

 

 

 

Call Detail Records (CDRs) will also be stored in the database specified in the Config.xml <Dialer> section, in tables CdrIn and CdrOut.

 

That Help file provides specific examples for SQL Server and MySQL, so you would need to probably create an Oracle specific version of Db_Create_XXXX.sql, otherwise VoiceGuide will attempt the database table creation using the default Db_Create.sql

 

If you must have the CDRs stored in another database(s) as well please contact sales@voiceguide.com to have this option included in the software.

Edited 12/30/2008 09:22 PM by SupportTeam