ODBC on CCMS

[telklass]

Ho Guys,

It's been a while since i am loooking on how to connect with the CCMS DB so that i can customize my own record, an ODBC driver is installed on the server and test connection is successful,now the goal is how to connect with CCMS DB.
I use the sysadmin password for the odbc connection, I am not testing it yet which means i don't know if it's the right credentials to be used for DB stuff from a third app . I any case an account must be set on CCMS DB side that i think it is not under the customer capabilitie, do you guys already experience this ?
Look forward to your reply .

Thanks !

 

[bignose21]

you can use sysadmin or setup an account in the server utility

 

[telklass]

Hi,

Thanks to reply,

For security reason i would prefer to create an account on server utility,now the question is which table to query , since we don't have any knowledge to the ccms db structure .


Thanks !

 

[telklass]

Hi ,

I added a new desktop user under Server Utility on CCMS server,but trying to connect from an SQL portal did not work,CCMS use Intersystem Cache DB , do you guys know how to reach the CCMS DB ?

Look forward to your reply.


Thanks !