安装AWS Redshift驱动程序Tableau Server不工作



我使用在Tableau Server中安装了AWS Redshift驱动程序

下载:

wget https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.27.1000/AmazonRedshiftODBC-64-bit-1.4.27.1000-1.x86_64.rpm

安装:

sudo yum --nogpgcheck localinstall AmazonRedshiftODBC-64-bit-1.4.27.1000-1.x86_64.rpm

安装输出为:

Loaded plugins: extras_suggestions, langpacks, priorities, update-motd
Examining AmazonRedshiftODBC-64-bit-1.4.27.1000-1.x86_64.rpm: AmazonRedshiftODBC-64bit-1.4.27-1.x86_64
Marking AmazonRedshiftODBC-64-bit-1.4.27.1000-1.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package AmazonRedshiftODBC-64bit.x86_64 0:1.4.27-1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================================================================
Package                                                Arch                                 Version                                Repository                                                                     Size
========================================================================================================================================================================================================================
Installing:
AmazonRedshiftODBC-64bit                               x86_64                               1.4.27-1                               /AmazonRedshiftODBC-64-bit-1.4.27.1000-1.x86_64                                60 M
Transaction Summary
========================================================================================================================================================================================================================
Install  1 Package
Total size: 60 M
Installed size: 60 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : AmazonRedshiftODBC-64bit-1.4.27-1.x86_64                                                                                                                                                             1/1 
Verifying  : AmazonRedshiftODBC-64bit-1.4.27-1.x86_64                                                                                                                                                             1/1 
Installed:
AmazonRedshiftODBC-64bit.x86_64 0:1.4.27-1                                                                                                                                                                            
Complete!

当我测试红移连接时,我得到了这个错误:

Drivers needed not installed to connect to db.<br>2021-06-28 14:39:57.163, (YNnfPNRMIky5JaHdM7bkwwAAANQ,1:1

将驱动程序降级到1.4.20.1001,之后的任何版本都与tableau服务器不兼容。

https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.20.1001/AmazonRedshiftODBC-64-bit-1.4.20.1001-1.x86_64.rpm

最新更新