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

Prerequisites

The DSE cluster must be installed and running. The username and password for internal authentication are defined in the DSE cluster. See About DSE Unified Authentication.

Procedure

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

  1. Browse to the URL for the Studio installation: 
    http://running_DSE:9091/
    where 9091 is the default DataStax Studio server port.
  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.