Redshift?

Scott Florcsk

• May 02, 2022 17:23

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.

0

• 

  Johnny Stevens

  • Logi Info Ninja
  • Logi Forum Guru
  • May 02, 2022 17:32

  Hey Scott,

  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!
  Johnny

  0
• 

  Scott Florcsk

  • June 22, 2022 16:42

  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.