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
Procedure
To create a connection from a Studio notebook to a DSE
cluster:
-
Browse to the URL for the Studio installation:
http://running_DSE:9091/
where 9091 is the default DataStax Studio server port. -
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.
- Click + in the top center of the page.
-
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
- Click Test to verify the connection works.
- 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.
-
Click Save.
A connection is created from the notebook to the DSE cluster.