Installing the SQLstream Blaze Azure MI
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:
2.Click the Get It Now Button on the lefthand side.
3.Sign in with your Microsoft or work account.
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
8.Select Virtual Machine Size. We recommend D2_Standard.
10.Configure Optional features.
11.Click on Network security group firewall and make sure that you have the following ports open:
12.Click OK. The page that opens gives you a summary of your Microsoft Azure purchase:
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.
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.
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.
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.
3.Right-click First SQLstream Server.
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.