Hi Minh,
Zitat von Ngoc Minh VO <ngocminh...@bnpparibas.com>:
Hello,
We are trying to connect some BI tools (eg. Tableau) to our NoSQL
database running C* v2.0.6.
It seems that the latest Datastax's ODBC driver is not compatible
with Cassandra v2.xx (but only with v1.xx, i.e. prior CQL3 era):
http://www.datastax.com/download#dl-datastax-drivers
http://www.datastax.com/dev/blog/using-the-datastax-odbc-driver-for-apache-cassandra
Could you please confirm that the latest version, still in beta, of
Datastax's ODBC driver is incompatible with keyspaces created with
CQL3? Is there any alternative connectors for BI tools (eg. Hive,
Spark drivers...)?
while I'm far from being authoritative, my experience confirms the
above: We could connect to the C* cluster, but would not see
CQL3-created CFs.
We were successful in testing an ODBC to JDBC bridge in conjunction
with the Datastax JDBC driver. (Which is not to say we were happy with
the results... ODBC clients tend to assume SQL DBMS at the other end
;) But we were able to retrieve data that way, to confirm the
connection.)
Regards,
Jens
