Installing the SQLstream Blaze Azure MI

<< Click to Display Table of Contents >>

Navigation:  Installing SQLstream Blaze >

Installing the SQLstream Blaze Azure MI

Previous pageReturn to chapter overviewNext page

The SQLstream Blaze Trial Azure MI is an Azurfe Machine Image that contains an Ubuntu Server with Oracle JDK 1.7 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 SQLstream Blaze 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 SQLstream Blaze 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 SQLstream Blaze welcome home in the Azure Portal.

5.Click the Create button.

6.Configure Basic Settings:

Enter a name for the Virtual Machine, such as SQLstream-Blaze

Enter the following settings:

VM disk type: SSD

User Name: sqlstream

Authentication type: SSH public key

SSH public key: <paste your own 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

inst_azure_vm_settings

7.Click OK.

8.Select Virtual Machine Size. We recommend D2_Standard.

inst_azure_vm_size

9.Click Select.

10.Configure Optional features.

11.Click on Network security group firewall and make sure that you have the following ports open:

80

3000

5570

5590

5580

5585

5595

22

inst_azure_ports

12.Click OK. The page that opens gives you a summary of your Microsoft Azure purchase:

inst_azure_summary

13.Microsoft Azure will validate your purchase. Once it does, click OK. Validation passed notice

14.Purchase SQLstream Blaze

15.Wait until the deployment finishes in the notifications tab.

16.Go to your virtual machine, copy the Public IP Address and paste it into you browser.

17.The SQLstream Blaze Microsoft Azure home page opens.

Using the SQLstream Microsoft Azure MI Launch Page

From the SQLstream Blaze 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 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 Enter value guide.

To run StreamLab, click the Try StreamLab 2.1.1 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:

1.Copy the JDBC address from the top of the Microsoft Azure MI launch page.

2.Launch s-Studio.

3.Right-click First SQLstream Server.

inst_ami_s_studio_server_properties

4.Paste the JDBC address into the URL field and click OK.

5.Right-click First SQLstream Server again and select Connect.

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