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;