Did anyone have luck with using Database connector to connect to Cassandra DB ?
Are you getting any issue to connect with Cassandra DB?
Dell Boomi AtomSphere uses JDBC to connect to the database.If Cassandra support JDBC connectivity you connect through Boomi Data base connector by Custom Database Type option.
The Database connector contains drivers for Microsoft SQL Server and Oracle. To connect to another type of database you must obtain the appropriate JDBC driver. Any driver files that you add to the Atom must be copied into the ../<atom_installation_directory>/userlib/database directory. If the userlib/database directory does not exist, you must create it then restart the Atom
To add a point what rajashekar had expressed is that first you need to get all the required jars for a DB connectivity.
Cassandra supports JDBC. Get jars from apache cassandra and try to configure.
Incase of any queries let us know..
Thanks for the help ! We could connect to Cassandra DB successfully using Boomi's Database custom connection , It needs JDBC driver jar files from third party. And after enabling the port 9160 at Cassandra DB configuration.
Can you please which jdbc cassandra jar files were used as we are facing similar issue. Wherein, we are able to connect to cassandra but getting metadata table access issue "Unable to extract database meta data. unconfigured table schema_columnfamilies". The system keyspace doesn't contain schema_columnfamilies table.
Retrieving data ...