Setting up PostgreSQL to work with HCL Discover

ODBC Driver Setup

  1. Access the PostgreSQL website.
  2. Download the psqlodbc_x86.msi file (32-bit).
  3. Run the psqlodbc_x86.msi file to install it.
  4. To ensure proper driver registration, after installing the drivers, verify that the following entries are added to the Windows Registry:
    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\PostgreSQL Unicode]
    "UsageCount"=dword:00000001
    "Driver"="C:\\Program Files (x86)\\psqlODBC\\1700\\bin\\podbc35w.dll"
    "Setup"="C:\\Program Files (x86)\\psqlODBC\\1700\\bin\\podbc35w.dll"
    "CPTimeout"="60"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="03.51"
    "FileUsage"="0"
    "SQLLevel"="1"

Verify ODBC Driver Setting

  1. After installing the ODBC driver, navigate to the regitry path Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Unica Discover\DataStore\ReportServer.
  2. Verify that the ODBC Driver value. It must be PostgreSQL Unicode. If the value is not PostgreSQL Unicode, it is an indication that the ODBC driver installation and configuration was not successful.
    Important: The ODBC Driver value must be PostgreSQL Unicode. This ensures that the DCAlertService correctly identifies and connects to the PostgreSQL reporting database.