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


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')
  • vendors/cisco/uc/socialminer.txt
  • Last modified: 2019/04/18 15:53
  • by gerardorourke