Creating a connection in DataStax Studio

Creating a connection from a Studio notebook to a DSE cluster.

A connection from each notebook to a DSE cluster is required. A notebook persists its data to a DSE cluster.

Connect notebooks only to DSE clusters that run the relevant workload. For example:
  • To run Gremlin cells, create a connection to a DSE cluster that is configured for and running DSE Graph.
  • To run AlwaysOn SQL queries in Studio, create a connection to a DSE cluster that is configured for and running the AlwaysOn SQL service.

Each notebook has only one connection. A connection can serve 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.

Prerequisites

The DSE cluster must be installed and running.

Procedure

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

  1. Browse to the URL for the Studio installation: 
    http://running_DSE:9091/
  2. In the menu (☰), select Connections.

    The existing connections are displayed in a list. The list is sorted in alphabetical order and shows the port and host for each connection.

  3. Click + in the top center of the page.
  4. In the Create Connection dialog, enter the connection information:
    Name
    Name of the connection from the notebook to a DSE cluster.
    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. Default: 9042.

    For example, to connect 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
  5. Click Test to verify the connection works.
  6. 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.
  7. Click Save.
    A connection is created from the notebook to the DSE cluster.