Installing the SQLstream Azure MI

The Guavus SQLstream Trial Azure MI is an Azure Machine Image that contains an Ubuntu Server with Oracle JDK 1.8 and lsb-core installed, and SQLstream s-Server, and SQLstream StreamLab installed in the Ubuntu environment. In runs in Microsoft Azure. Microsoft Azure Machine Images run as virtual machines in the cloud.

What You Need

To use the Guavus SQLstream Trial AMI, it is helpful, but not mandatory, to have experience with Microsoft Azure. You will also need a ‘Microsoft account connected to a subscription or resource group. If you do not have such an account through your workplace, you will need to sign up for one.

To Install the Guavus SQLstream Azure MI:

  1. Go to the Following link: https://azuremarketplace.microsoft.com/en-us/marketplace/apps/sqlstream.com?tab=Overview
  2. Click the Get It Now Button on the lefthand side.
  3. Sign in with your Microsoft or work account.
  4. Accept SQLstream’s terms of use and privacy policy. You will be redirected to the Guavus SQLstream welcome home in the Azure Portal.
  5. Click the Create button.
  6. Configure Basic Settings:
  7. Enter a name for the Virtual Machine, such as Guavus-SQLstream
  8. Enter the following settings:
    • VM disk type: SSD
    • User Name: sqlstream
    • Authentication type: SSH public key
    • SSH public key:
    • Subscription: select your azure subscription
    • Resource group: you can choose using an existing one or you can create other.
    • Location: Select the Azure location
  9. Click OK.
  10. Select Virtual Machine Size. We recommend D2_Standard.
  11. Click Select.
  12. Configure Optional features.
  13. Click on Network security group firewall and make sure that you have the following ports open:
    • 80
    • 3000
    • 5570
    • 5590
    • 5580
    • 5595
    • 22
  14. Click OK. The page that opens gives you a summary of your Microsoft Azure purchase:
  • Microsoft Azure will validate your purchase. Once it does, click OK. Validation passed notice
  • Purchase Guavus SQLstream
  • Wait until the deployment finishes in the notifications tab.
  • Go to your virtual machine, copy the Public IP Address and paste it into you browser.
  • The Guavus SQLstream Microsoft Azure home page opens.

Using the SQLstream Microsoft Azure MI Launch Page

From the Guavus SQLstream AMI launch page, you can do the following:

  • Run the Mochi demo
  • Use StreamLab, using a built-in stream of bus location data.
  • Download s-Studio for Windows to view the server and SQL.

Running the Mochi Demo

The Mochi demonstration application simulates clusters of failed logins at a bank, either by phone or web, as well as withdrawals or debits using the same customer id number. See the topic Running the Mochi Demo for more details.

To run the Mochi demo, click the “Start Mochi Demo” link. Like the installation of s-Server, this process takes some time to initiate. We recommend waiting 5 minutes to allow the Mochi demo to start.

Next, click the “View Mochi Demo” link. This will open a new tab or window in your browser pointing to the dashboard list. If it fails, it probably means you didn’t wait long enough. Close the window, wait a little longer, and try again.

When you’re done with the demo, you can either use the “Stop Mochi Demo” link to shut it down cleanly, or just terminate the EC2 instance if you’re done using it. If you are going to move on to use StreamLab, you need to stop the Mochi demo cleanly.

Running StreamLab

StreamLab is a web application development environment that automatically generates streaming SQL. StreamLab lets you set up projects where you can parse incoming streaming data, generate real time analytics for it, visualize it, so that you can take action on it. See The Using StreamLab Guide for more details.

Viewing Tutorial

The Launch page links to a video tutorial that walks you through using StreamLab.

Using Bus Data

SQLstream provides sample data to use with StreamLab. This is a continually-updating file in JSON format. For more information on using StreamLab with bus data, see the topic Using StreamLab to Build a Streaming Application in the Building Streaming Applications guide. To run StreamLab, click the Try StreamLab link.

Using s-Studio

You can download and install SQLstream s-Studio. Once you do, you can configure s-Studio to connect with your Microsoft Azure MI instance by taking the following steps:

  • Copy the JDBC address from the top of the Microsoft Azure MI launch page.
  • Launch s-Studio.
  • Right-click First SQLstream Server.
  • Paste the JDBC address into the URL field and click OK.
  • Right-click First SQLstream Server again and select Connect.
  • Studio should connect to s-Server and display a list of schemas, data sources, plugins, and so on.

Terminating the Instance

When you’re done using the instance, you should stop it, either from the EC2 Management Console or from the command line.