ICMB is using Crystal Reports for historical reports. As far as I understood the design from my previous tickets, the SQL proxy is part of crystal report,
and the proxy server component itself is compiled into the httppluginhost binary. To let the proxy work you must check some things:
In 2021 R1 the Crystal Reports engine was updated, so before 2021 R1 you can only use SQLNCLI11.
According to the Genesys Support newer versions of SQLNCLI have problems with the Crystal Report engine used in CIC before 2021 R1.
Second, the httppluginhost-based SQL proxy does not suport SQL encryption (see IDEA COOPLA-I-262).
You had to disable the encryption in the ODBC connection string to let the httppluginhost SQL proxy work.
And 3rd, even if you are using SQL Proxy, you must install the SQL Client (SQLNCLI or MSODBC) on every client.
And according to your question: Are you facing the direct SQL connections when the agents try to execute a historical report, or by using other ICBM reports?
Andreas
------------------------------
Andreas Tikart
Fiebig GmbH
------------------------------
Original Message:
Sent: 07-15-2021 15:37
From: Shane Jenkins
Subject: ICBM Proxy through HttpPluginHost for reporting
Hello all,
Reaching out to the experts here on this one. We'd heard that you can force IC to proxy ICBM SQL connections when reports are ran through the IC server. Has anyone been successful at this? Currently our ICBM users make a direct connection to our SQL server from their endpoint and we'd like to force this traffic through IC as a proxy. We'd like to only have the necessary SQL port opened from IC and not all those endpoints.
We've updated the IC Data Sources > IC Report Logs > Report Connection Configuration tab to reflect 'Proxy through httppluginhost' and even restarted after. Our dba still sees a direct connection to the SQL server from my laptop when I run a report. We are testing this on a Dev server before attempting in production. We're running 2020 R2, if that matters.
Thanks in advance.
#PlatformAdministration
#Reporting/Analytics
------------------------------
Shane
------------------------------