PureConnect

 View Only
Discussion Thread View
  • 1.  ICBM Proxy through HttpPluginHost for reporting

    Posted 07-15-2021 15:38
    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
    ------------------------------


  • 2.  RE: ICBM Proxy through HttpPluginHost for reporting

    Posted 07-16-2021 05:28
    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
    ------------------------------



  • 3.  RE: ICBM Proxy through HttpPluginHost for reporting

    Posted 07-22-2021 14:34
    Thanks for the info Andreas! 

    To answer a few of your questions. We are currently running 2020 R2. We have the Microsoft ODBC 11 driver for SQL installed on our IC server and all of our endpoints. We have disabled SSL and TLS 1.0, and are only using TLS 1.2 currently.

    The only test I've done so far is running a custom built (Crystal Reports 2013) historical report. When I ran the report, the DBA could see my workstation connect directly to the SQL database. I guess I expected us to see only a connection coming from the IC server vs. my laptop. 

    Ultimately we'd like to not have to allow port 1433 from all of our ICBM users endpoints.

    I was also pointed to the following URL by support recently on this: https://help.genesys.com/pureconnect/mergedprojects/wh_tr/mergedprojects/wh_tr_reporting/desktop/appendix_j_internet_enabled_reporting.htm

    Thanks again!


    ------------------------------
    Shane
    ------------------------------



  • 4.  RE: ICBM Proxy through HttpPluginHost for reporting

    Posted 07-23-2021 14:02
    Hi Shane,

    So, to be clear, with this custom report, have you added it to the reports run through Reporter (ICBM) or are you running it directly in Crystal?


  • 5.  RE: ICBM Proxy through HttpPluginHost for reporting

    Posted 07-23-2021 14:04
    Hi Paul,

    Sorry, I left that part out. Yes, we use the Crystal Report import utility for our custom reports and import them into Int. Admin.
    At that point, we then run the reports through ICBM and Reporter.

    Thanks,
    Shane

    ------------------------------
    Shane
    ------------------------------



  • 6.  RE: ICBM Proxy through HttpPluginHost for reporting

    Posted 07-23-2021 18:39
    Edited by Paul Simpson 07-23-2021 18:42
    "The Crystal Reports import utility"? This isn't something I've heard of. I just looked it up and it looks interesting.

    In the Custom Reporting class, we create new reports manually and this issue doesn't occur. It might be worth attending the class (1 day) to see if you can see what you are doing that is different.


Need Help finding something?

Check out the Genesys Knowledge Network - your all-in-one access point for Genesys resources