Menu
Simba Technologies
Simba Technologies

Simba Cassandra ODBC Driver with SQL Connector 2.6.0
Installation and Configuration Guide

Creating a Data Source Name

Typically, after installing the Simba Cassandra ODBC Driver, you need to create a Data Source Name (DSN).

Alternatively, for information about DSN-less connections, see Using a Connection String.

To create a Data Source Name:

  1. From the Start menu, go to ODBC Data Sources.
  2. Note:

    Make sure to select the ODBC Data Source Administrator that has the same bitness as the client application that you are using to connect to Cassandra.

  3. In the ODBC Data Source Administrator, click the Drivers tab, and then scroll down as needed to confirm that the Simba Cassandra ODBC Driver appears in the alphabetical list of ODBC drivers that are installed on your system.
  4. Choose one:
    • To create a DSN that only the user currently logged into Windows can use, click the User DSN tab.
    • Or, to create a DSN that all users who log into Windows can use, click the System DSN tab.

    Note:

    It is recommended that you create a System DSN instead of a User DSN. Some applications load the data using a different user account, and might not be able to detect User DSNs that are created under another user account.

  5. Click Add.
  6. In the Create New Data Source dialog box, select Simba Cassandra ODBC Driver and then click Finish. The Simba Cassandra ODBC Driver DSN Setup dialog box opens.
  7. In the Data Source Name field, type a name for your DSN.
  8. Optionally, in the Description field, type relevant details about the DSN.
  1. Choose one:
    • In the Host field, type the name or IP address of the host where your Cassandra instance is running.
    • Or, in the Host field, type a comma-separated list of host names or IP addresses of Cassandra servers to which the driver connects.

    Note:

    The driver attempts to connect to all the servers concurrently, and then keep the first connection that is successfully established. The driver does not maintain a connection with any of the other servers in the list.

  2. In the Port field, type the number of the TCP port that the server uses to listen for client connections.
  3. Note:

    The default port used by Cassandra is 9042.

  4. If user login is required to access the Cassandra instance, then configure authentication. For more information, see Configuring Authentication.
  5. In the Default Keyspace field, type the name of the Cassandra keyspace to use by default.
  6. To configure advanced driver options, click Advanced Options. For more information, see Configuring Advanced Options.
  7. To configure logging behavior for the driver, click Logging Options. For more information, see Configuring Logging Options.
  8. To test the connection, click Test. Review the results as needed, and then click OK.
  9. Note:

    If the connection fails, then confirm that the settings in the Simba Cassandra ODBC Driver DSN Setup dialog box are correct. Contact your Cassandra server administrator as needed.

  10. To save your settings and close the Simba Cassandra ODBC Driver DSN Setup dialog box, click OK.
  11. To close the ODBC Data Source Administrator, click OK.