Creating a connection in DataStax Studio

Steps to create a connection from a notebook to a DSE cluster.

Prerequisites

  • DSE 5.1 installed, configured, and running.
  • DataStax Studio installed and running.
  • If using DSE Graph, it must be configured and running.
A connection to a DSE cluster is required.

Each notebook has only one connection. Each connection can have multiple notebooks.

Tip: You can configure more than one host in a Studio connection. Hosts initialize the Cassandra driver connection, so more than one host provides redundancy and failover protection.
A notebook persists its data to a DSE cluster.
DSE Graph
The connection identifies a particular graph.

For notebooks using DSE Graph, the connection must be changed to use a different graph.

CQL
The connection identifies a database instance.

For notebooks using CQL, the keyspace and table can be changed within the notebook.

Procedure

To create a connection from a notebook to a DSE cluster:

  1. Browse to the URL for the Studio installation.
    http://URI_running_DSE:9091/
  2. In the menu (☰), select the Connections menu item.
  3. Create the connection from a notebook to a DSE cluster:
    1. Select Add connection (the plus icon in the top center of the page).
      The Create Connection dialog appears.
    2. Enter the connection information:
      Name
      Name of the connection.
      Host/IP (comma delimited)
      The host names or IP addresses of the DSE cluster to connect to. Default: localhost.
      Username
      Optional. DSE username for logging in.
      Password
      Optional. DSE password for logging in.
      Port
      IP connection port of the DSE cluster. Default: 9042.

      This example connects to a single-node DSE cluster on the local host using the default port.

      Name
      My First Connection
      Host/IP
      127.0.0.1
      Port
      9042
    3. Select Save.
  4. Click Test to verify the connection works.
  5. Optional: To configure a secure encrypted connection, select the Use SSL check box.
    The Truststore and Keystore fields display. See Using SSL connections in DataStax Studio.
  6. Click Save.
    A connection is created from the notebook to the DSE cluster.