完美解决kettle连接 redshift数据库
*问题:需要从同事的redshift中提取一部分数据,我这边选择用kettle来处理。
设置好连接所填信息后,发现报错如下。
错误连接数据库 [redshift_datawarehouse] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database
Driver class 'com.amazon.redshift.jdbc4.Driver' could not be found, make sure the 'Redshift' driver (jar file) is installed.
com.amazon.redshift.jdbc4.Driver
org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database
Driver class 'com.amazon.redshift.jdbc4.Driver' could not be found, make sure the 'Redshift' driver (jar file) is installed.
com.amazon.redshift.jdbc4.Driver
报错图为
行,没有驱动是吧,我就找个驱动去