11-30-2012 08:34 AM - edited 03-19-2019 05:57 AM
We would like to create a MS SQL linked server to our CUCM database as we have done with UCCX. Is this possible? If so, is there some reference material available?
Thank you
Solved! Go to Solution.
12-01-2012 04:53 AM
The CUCM Informix database is only accessible through the AXL API. You would have to write some middleware to issue the API commands with the appropriate SQL SELECT statements and then populate your database with the responses.
As a side-note: Copying the CCX database isn't officially supported either. By this I mean it isn't documented therefore TAC will tell you to get lost if you have a problem. The ODBC connection was only intended to be used when designing (not executing) custom Crystal reports for use by the HRC. I realize some Cisco TMEs are suggesting that you use the ODBC connection for other things; just be advised of the brick wall before you run into it.
Please remember to rate helpful responses and identify helpful or correct answers.
12-01-2012 04:53 AM
The CUCM Informix database is only accessible through the AXL API. You would have to write some middleware to issue the API commands with the appropriate SQL SELECT statements and then populate your database with the responses.
As a side-note: Copying the CCX database isn't officially supported either. By this I mean it isn't documented therefore TAC will tell you to get lost if you have a problem. The ODBC connection was only intended to be used when designing (not executing) custom Crystal reports for use by the HRC. I realize some Cisco TMEs are suggesting that you use the ODBC connection for other things; just be advised of the brick wall before you run into it.
Please remember to rate helpful responses and identify helpful or correct answers.
12-03-2012 07:18 AM
Not what I wanted to hear, but not unexpected considering the lack of information on alternatives.
I really appreciate the help.
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