Connecting to s-Server with SQLstream s-Studio

<< Click to Display Table of Contents >>

Navigation:  Using s-Studio >

Connecting to s-Server with SQLstream s-Studio

Previous pageReturn to chapter overviewNext page

Before using SQLstream s-Studio, you should normally have the SQLstream s-Server started. If that is not done yet, follow the directions in Starting and Stopping SQLstream s-Server. Studio can be started without an active Server but will not be able to connect.

Note that if s-Studio closes while connected to a SQLstream s-Server, it will attempt to auto-connect to the same server when it is next re-started. If s-Studio is first disconnected and then shutdown, upon starting anew it will come up quietly without trying to auto-connect.

Opening SQLstream s-Studio

Once the SQLstream s-Server is started, you can open SQLstream s-Studio by double-clicking its desktop icon or by running the s-Studio script in the s-Studio installation folder. If you installed as sudo, this is /opt/sqlstream/5.1.0XXX/s-Studio/s-Studio.

gs_studio_icon

Connecting to s-Server

s-Studio is preconfigured to connect with an available installation of s-Server. To connect with s-Server, right-click the predefined repository instance in the left pane, called First SQLstream s-Server, and choose Connect.

std_connect_first_server

Note: If your s-Studio Development pane does not contain the "First SQLstream s-Server," then open a terminal window, navigate to the $SQLSTREAM_HOME/bin directory, and run the script resetStudio. Then restart the server, and then restart s-Studio.)

Note: $SQLSTREAM_HOME refers to the installation directory for s-Server, such as /opt/sqlstream/5.1.0/s-Server.

Connecting to the First SQLstream s-Server

After showing a progress screen, as in the "Connecting" figure below, the interface to that predefined SQLstream instance will appear, showing the icons representing its predefined Schemas, Data Sources and Sinks, Plugins, and Pumps:

Development Pane Showing Elements Available after Connecting to First SQLstream s-Server

Development Pane Showing Elements Available after Connecting to First SQLstream s-Server

Connecting to a Different Instance of s-Server

For a variety of reasons, you may need to enter a different JDBC URL to connect with your instance of s-Server. For example, if you have installed s-Server as part of the SQLstream Blaze Amazon Machine Image, you will need to enter the JDBC URL in order to connect with this instance from desktop.

To do so:

Right-click on First SQLstream Server and choose Properties.

std_first_server_properties

In the dialog box that opens, enter a URL along the following lines into the URL field.

jdbc:sqlstream:sdp://ec2-00-000.compute.amazonaws.com:5570

std_enter_new_jdbc_url

Click OK.

Test the connection by right-clicking on First SQLstream Server and choosing Connect.

Including Passwords in the JDBC URL

If your administrator has configured s-Server to require a user name and password, you will need to include these in the URL, as in the following example:

jdbc:sqlstream:sdp://ec2-00-000.compute.amazonaws.com:5570?user=uname&password=pass

Closing SQLstream s-Studio

To close s-Studio, select File > Exit. If you have unsaved work, such as object definitions you have added or modified, the program will prompt you for which ones to save.

When the user interface closes, it stores the state of its current windows, so when you restart it, you should have the same items open in the same locations.