Has anyone successfully gotten Logi Info 14 on Windows 2019 server to connect to Redshift via ODBC?
The server won't let me install Redshift's ODBC driver, but I think it's because either Windows server 2019 or Logi Info installed a newer version of Visual C++ Redistributable for Visual Studio 2015 that may not be compatible with Redshift's driver.
I haven't used RedShift, but I wanted to point out some details in the documentation.
First off, Logi indicates (at https://devnet.logianalytics.com/hc/en-us/articles/4419707709207-Amazon-Redshift) that you need to install the same version of ODBC Driver as your Logi installation (32-bit v. 64-bit). I would confirm this in your environment.
Next, RedShift indicates that JDBC might be simpler (at https://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html). If you want to use ODBC, it looks like RedShift wants a DSN configured. Again, I would confirm that this is configured correctly and confirm connectivity apart from Logi.
If you have already done all this, I would contact Logi Support to see if they can help you troubleshoot your configuration from the Logi side of things.
Best of luck to you!
I got this working with JDBC, but I had to install an additional webserver (Tomcat 9). I could never get it working with a data table, because the data table never gave an option for the Redshift access.0
Please sign in to leave a comment.