Connecting to Socialminer Informix Database using Squirrel

  • Download & Install Squirrel
  • Download Informix jdbc jar file ifxjdbc.jar and copy to squirrel lib folder - Informix JDBC Driver
  • Setup password for the user “reportinguser” on Social admin web interface
  • Configure Alias for your Socialminer database
jdbc:informix-sqli://192.168.1.165:1526/mmca_data:INFORMIXSERVER=ucce_socialminer_mmca;\\

References
http://senndoh.blogspot.ie/2012/10/how-to-connect-to-informix-database.html
http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/socialminer/socialminer_10/user_guide/CUSM_BK_SF31C8B0_00_socialminer-user-guide/CUSM_BK_SF31C8B0_00_socialminer-user-guide_chapter_0101.html

Note: Same process to connect to UCCX, except

  • database name is db_cra
  • server name needs _uccx (lowercase and replace hyphens with underscores)
  • Port is 1504
  • set password for historical reporting user in UCCX ('uccxhruser') or wallboad ('uccxwallboard')
jdbc:informix-sqli://192.168.1.186:1504/db_cra:INFORMIXSERVER=uccx10_5a_uccx;
This website uses cookies. By using the website, you agree with storing cookies on your computer. Also you acknowledge that you have read and understand our Privacy Policy. If you do not agree leave the website.More information about cookies