Connecting to Socialminer Informix Database using Squirrel

  • Download & Install Squirrel
  • Download Informix jdbc jar file ifxjdbc.jar and copy to squirrel lib folder
  • 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;