Access CUC DB via SQL

Version 1
    This document was generated from CDN thread

    Created by: George Goglidze Berdzenishvili on 24-06-2012 06:42:39 AM
    Hi all,
     
    Is it possible at all to access CUC DB via SQL statements?
    like we do through CUCM AXL API executeSQLQuery ?
     
    Thanks,

    Subject: Re: New Message from Jeff Lindborg in Cisco Unity Connection(CUC) - CUPI Qu
    Replied by: George Goglidze Berdzenishvili on 24-06-2012 04:45:55 PM
    Hi Jeff,

    What do you mean exactly by saying this is not supported by customer user?
    So if I deploy an app, that uses ODBC via ODBC proxy, will this invalidate
    support contract for CUC?

    Thanks for your reply,

    On Sun, Jun 24, 2012 at 5:42 PM, Cisco Developer Community Forums <
    cdicuser@developer.cisco.com> wrote:

    > Jeff Lindborg has created a new message in the forum "CUPI Questions":
    >
    > --------------------------------------------------------------
    > There's no HTTP access using SQL queries - you can use ODBC via the ODBC
    > proxy (as many of the bulk tools use) but this is not supported for
    > customer user.
    > --
    > To respond to this post, please click the following link:
    >
    > <
    > http://developer.cisco.com/web/cuc/forums/-/message_boards/view_message/5917606
    > >
    >
    > or simply reply to this email.




    --
    *IPCORP LTD*
    George Goglidze - Owner/Director
    2x CCIE #19926 (R&S, Voice)
    M: +44 (0) 7974 714 614
    web: www.ipcorp.co.uk

    Subject: RE: Re: New Message from Jeff Lindborg in Cisco Unity Connection(CUC) - CUP
    Replied by: Jeff Lindborg on 24-06-2012 05:26:38 PM
    no, it means they wont help you with questions you have about it and wont help you with problems they determine are caused by your used of ODBC (i.e. you waxed a bunch of data and opened a TAC ticket for assistance - they will direct you to restore from backup or reinstall).  You use the interface at your own risk.

    it logs indications about the use of ODBC into the update logging so it wont be a mystery what happened if you have a messy accident - that said it's really no more dangerous than REST, you can do most of the same things in REST (just less functionality and less performance).  If you stick to using stored procedures and views as you should (never, EVER update data directly in a table - this is just 101 DB advice, though) you'll be fine.  All my tools with a few exceptions are ODBC for performance reasons.

    Subject: RE: Access CUC DB via SQL
    Replied by: Jeff Lindborg on 24-06-2012 11:42:17 AM
    There's no HTTP access using SQL queries - you can use ODBC via the ODBC proxy (as many of the bulk tools use) but this is not supported for customer user.

    Subject: Re: New Message from Jeff Lindborg in Cisco Unity Connection(CUC) - CUPI Qu
    Replied by: George Goglidze Berdzenishvili on 25-06-2012 04:01:55 AM
    Thanks a lot Jeff!!!

    That makes sense...

    I only want to read some data, so I guess I'm safe! :-) at the moment.

    Regards,

    On Sun, Jun 24, 2012 at 11:26 PM, Cisco Developer Community Forums <
    cdicuser@developer.cisco.com> wrote:

    > Jeff Lindborg has created a new message in the forum "CUPI Questions":
    >
    > --------------------------------------------------------------
    > no, it means they wont help you with questions you have about it and wont
    > help you with problems they determine are caused by your used of ODBC (i.e.
    > you waxed a bunch of data and opened a TAC ticket for assistance - they
    > will direct you to restore from backup or reinstall). You use the interface
    > at your own risk.
    >
    > it logs indications about the use of ODBC into the update logging so it
    > wont be a mystery what happened if you have a messy accident - that said
    > it's really no more dangerous than REST, you can do most of the same things
    > in REST (just less functionality and less performance). If you stick to
    > using stored procedures and views as you should (never, EVER update data
    > directly in a table - this is just 101 DB advice, though) you'll be fine.
    > All my tools with a few exceptions are ODBC for performance reasons.
    > --
    > To respond to this post, please click the following link:
    >
    > <
    > http://developer.cisco.com/web/cuc/forums/-/message_boards/view_message/5915636
    > >
    >
    > or simply reply to this email.




    --
    *IPCORP LTD*
    George Goglidze - Owner/Director
    2x CCIE #19926 (R&S, Voice)
    M: +44 (0) 7974 714 614
    web: www.ipcorp.co.uk