PDA

View Full Version : Need help in loading data from Cassandra to MySQL.



santushet
09-25-2013, 11:01 AM
Dears,

I am trying to load data from Cassandra to MySQL using Kettle tool.

I have tried 2 ways.
1. Dragged 'Table input' and 'Table output' on transformation canvas. When i double click on table input to set database properties, I do not see "cassandra" connection type in the left pan.
2. Dragged 'Cassandra input' into transformation canvas. Dragged 'Table output' for Mysql output. After providing property details for both input and output, when i click on mapping part i do not see any fields under 'Source fields tab'.

Could you please suggest me how do I achieve this without loading data from Cassandra to text file and reload into MySQL?

My Kettle version is 4.4.0( pdi-ce-4.4.0-stable).

Thanks in advance,

Santosh