Creating a connection in DataStax Studio

  • 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.

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.

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

  2. Browse to the URL for the Studio installation.

    $ http://URI_running_DSE:9091/
  3. In the menu (☰), select the Connections menu item.

  4. 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

  1. Select Save.

    1. Click Test to verify the connection works.

    2. 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.

    3. Click Save.

      A connection is created from the notebook to the DSE cluster.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com