on 01-25-2014 10:36 AM
David Staudt:If you're referring to executing SQL statements, the Serviceability API does have a request for that in the WSDL, but it is not actually supported - consider 'vestigial'.
You will want to use AXL for executeSqlQuery/executeSqlUpdate
David Staudt:There is a WSDL for the AXL interface, it is available for download from the administrative web pages/UI of the UCM server itself - under Applications/Plugins, as AXL SQL Toolkit. The Toolkit includes a small Java sample with actually performs an executeSqlRequest.
A limitation of the WSDL concept itself however is that requests/responses are supposed to be fully defined. In the case of an AXL request that submits custom SQL statements, the data returned - while tabular - can have any number of fields in the result, and so cannot be parsed by code created by WSDL consumer/compilers. For executeSqlQuery requests, it's generally just easier to set up an HTTP POST with some string/concatenated XML (only the SQL text needs to change between requests), and then use an XML parser to access the results.
Example of full request/response:
POST https://10.88.131.141:844...
David Staudt:AXL provides some sanity checking, rate/data-size throttling, and transaction protection around SQL requests, intended to prevent at least some potential mis-use, even though direct SQL access is still relatively risky. -Direct SQL access, e.g. JDBC, is not possible. Also note the important caveats around AXL SQL usage, including: performance impact on UCM callprocessing is not guaranteed and testing by the developer is critical; UCM SQL database schema has no backward compatibility guarantees, and could possibly change in any UCM release, including point or patch releases (almost always this is just additions of fields/tables, but FYI.)
UCM Informix database table/field/relationship info is available in the corresponding Data Dictionary documentation: http://developer.cisco.com/web/axl-developer/latest-version
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: