Cassandra

From DreamFactory
Jump to: navigation, search
 
Line 13: Line 13:
 
* '''Username''' - String. Optional. If your Cassandra server requires authentication. Then provide Username here.
 
* '''Username''' - String. Optional. If your Cassandra server requires authentication. Then provide Username here.
 
* '''Password''' - String. Optional. If your Cassandra server requires authentication. Then provide Password here.
 
* '''Password''' - String. Optional. If your Cassandra server requires authentication. Then provide Password here.
 +
* '''Keyspace''' - String. Required. Your Cassandra Keyspace that you will be using. This is equivalent to a SQLDB database name.
 
* '''Options''' - Object/Associative array. Optional. An array of options for the Cassandra connection. Available options are - ssl : boolean, server_cert_path : string, client_cert_path : string, private_Key_path : string, key_pass_phrase : string
 
* '''Options''' - Object/Associative array. Optional. An array of options for the Cassandra connection. Available options are - ssl : boolean, server_cert_path : string, client_cert_path : string, private_Key_path : string, key_pass_phrase : string

Latest revision as of 13:54, 28 September 2016

Cassandra is one of the popular NoSQL databases that comes with DreamFactory OpenSource. The Cassandra service type can connect to local or remote Cassandra servers.

Common Feature Exceptions

  • Unlike some other NoSQL databases, Cassandra has defined schema for tables. Therefore, the _schema resource works like a SQL DB service.
  • Cassandra supports filtering in CQL. Therefore, DreamFactory also supports that using the filter parameter like a SQL DB service.

Requirements

  • PHP extension cassandra and C/C++ driver from DataStax is required to be installed or compiled in. Check here for installation help.

Configuration

  • Host - String. Required. IP Address/Hostname of your Cassandra node. Note that you don’t have to specify the addresses of all hosts in your cluster. Once the driver has established a connection to any host, it will perform auto-discovery and connect to all hosts in the cluster.
  • Port - Integer. Optional. Cassandra server port number. Defaults to 9042.
  • Username - String. Optional. If your Cassandra server requires authentication. Then provide Username here.
  • Password - String. Optional. If your Cassandra server requires authentication. Then provide Password here.
  • Keyspace - String. Required. Your Cassandra Keyspace that you will be using. This is equivalent to a SQLDB database name.
  • Options - Object/Associative array. Optional. An array of options for the Cassandra connection. Available options are - ssl : boolean, server_cert_path : string, client_cert_path : string, private_Key_path : string, key_pass_phrase : string