Connect connects to NoSQL databases through the client software applicable to your NoSQL database and through a compliant ODBC or JDBC driver.
To reference client software download information, links, and installation instructions that are applicable to current NoSQL databases, for example Cassandra, Hbase, and MongoDB, consider the following sites:
- Cassandra: http://cassandra.apache.org/
- Hbase: http://hbase.apache.org/
- MongoDB: http://www.mongodb.org/
To establish a connection to a NoSQL database, install the applicable client software on the system on which Connect is installed.
ODBC driver installation
Connect requires a Level 3.0 compliant ODBC driver to connect to a NoSQL database. For driver installation and configuration information, refer to your ODBC driver documentation.
To reference ODBC driver download information for Simba ODBC drivers, for example, consider the following sites:
- Cassandra: http://www.simba.com/connectors/apache-cassandra-odbc
- Hbase: http://www.simba.com/connectors/apache-hbase-odbc
- MongoDB: http://www.simba.com/connectors/mongodb-odbc
The installation documentation applicable to these sites outlines the steps to create the ODBC DSN and provides links to advanced options specific to the Simba driver for Cassandra, Hbase, and MongoDB.
You can also reference Defining ODBC Data Source Names. While you can use any ODBC driver manager to load ODBC drivers for UNIX systems, by default, Connect uses the shipped unixODBC driver manager.
JDBC driver installation
Connect requires a Level 4.0 compliant JDBC driver to connect to a NoSQL database. For driver installation and configuration information, refer to your JDBC driver documentation.