使用Pentaho数据集成将Amazon Redshift转换为Mysql [英] Amazon Redshift to Mysql using Pentaho Data Integration

问题描述

我们正在使用Amazon redshift，数据库是POSTGRESQL.Tha数据位于亚马逊云中.我们需要使用Pentaho数据集成软件将数据从Amazon redshift加载到Mysql.请告诉我们如何通过Pentaho连接到Redshift ???

解决方案

我会尽力帮助您.

redshift连接将需要pentaho数据集成的lib文件夹中的PostgreSql JDBC.但是Pentaho随附的版本在redshift方面存在一些问题，可以通过删除现有版本并使用8.4版本来解决此问题(如，该步骤具有很棒的表现.但是对于第一次测试，表输出步骤应该可以完成工作.

We are using Amazon redshift and the data base is POSTGRESQL.Tha data sit in amazon cloud. We need to load data from Amazon redshift to Mysql using Pentaho Data Integration Software.Could you please tell us how to connect to Redshift via Pentaho ???

解决方案

I'll try to help you.

The redshift connection will need the PostgreSql JDBC in the lib folder of your pentaho data-integration. But the one that comes with Pentaho have some issues with redshift, this may be solved by removing the existent and use the version 8.4 (as seen on this link)

After that you may create a new connection on a transformation, using a table input step. You query should run just fine.

You may add a table output step, connected to a mysql database (you'll need to download de MySQL JDBC connector and place on the lib folder too).

An alternative output is the MySQL Bulk Loader Step that has a awesome performance. But for first tests the Table Output Step should do the work.

这篇关于使用Pentaho数据集成将Amazon Redshift转换为Mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！