Setting up PostgreSQL to work with HCL Discover
ODBC Driver Setup
- Access the PostgreSQL website.
- Download the psqlodbc_x86.msi file (32-bit).
- Run the psqlodbc_x86.msi file to install it.
- 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
- After installing the ODBC driver, navigate to the regitry path Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Unica Discover\DataStore\ReportServer.
- 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
DCAlertServicecorrectly identifies and connects to the PostgreSQL reporting database.