I have used JDBC driver to Read and write to Cassandra Database,However the performance is very bad using external JDBC Driver.
I found PenthoETL(open source) has separate big data components for reading and writing to Cassandra database and its performance is pretty faster than using JDBC driver in CloverETL.
Is there any other way to read and write to Cassandra through CloverETL.
I have gone through following thread, but couldn’t help me much.
I have used JDBC driver to Read and write to Cassandra Database,However the performance is very bad using external JDBC Driver.
I found PenthoETL(open source) has separate big data components for reading and writing to Cassandra database and its performance is pretty faster than using JDBC driver in CloverETL.
Is there any other way to read and write to Cassandra through CloverETL.
I have gone through following thread, but couldn’t help me much.
Is Clover team working on building Cassandra reader and writer component?
Thanks.
Bhavin
Data Integration Architect
Ypoint Solutions
“Ypoint Solutions”
Hi,
Can you please tell me which JDBC driver did you use? There are many drivers available. Few drivers like Thrift are bad in performance and should be avoided.
Hello,
there are 3 options of how to connect to Cassandra from CloverDX:
Using a dedicated JDBC driver
Using the Datastax Java library
By calling a script
The first option is not recommended as it appears that no one is actively maintaining or supporting JDBC connectors for Cassandra. The Google archive version we found is a couple of years old and is not being actively developed.
The second option is viable, yet significantly more complex. More information can be found in this Forum article.
In CloverDX Designer, the third option gets as simple as using an ExecuteScript component and feeding it with the proper script.
I have attached 2 projects to this ticket one of which shows the ExecuteScript approach (option #3) and one of which demonstrates the Datastax driver and custom Java code approach (#2).