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.
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/<VERSION>*XXX/s-Studio/s-Studio.
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. 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//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:
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 Guavus SQLstream 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. 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 Click OK. Test the connection by right-clicking on First SQLstream Server and choosing Connect.
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
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.