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 DataStax driver connection, so more than one host provides redundancy and failover protection.

The DataStax driver in Studio uses the DCAwareRoundRobin Load Balancing Policy and creates connection pools to all nodes in the datacenter of the first successfully contacted Host/IP configured in the Create Connection panel. The driver shuffles the contact point list.

Prerequisites

The DSE cluster must be installed and running. All hosts passed to Host/IP in the connection details must be in a single datacenter.

If specified hosts are not in a single datacenter, the following error occurs: All hosts must belong to the same Datacenter.

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. All hosts must be in a single datacenter. 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.