Download SQLstream Blaze

Blaze is available on Linux for both evaluation and operational systems. Deployment choices include AWS, Virtual Machines for Windows and Mac OS, as well as native Linux Installers.

Download the Blaze VM Appliance

The SQLstream Blaze VM can be deployed on any host OS supported by Virtual Box, Parallels, VMWare, and Hyper-V, including Linux, OS X, and Windows 7-10. All VM hosts require a 64-bit OS.

  • For VMware and VirtualBox 5.1.1.4
    3.33 GB .ova

    Download
  • For Hyper-V 5.1.1.4
    3.24 GB .zip

    Download
  • For Parallels 5.1.1.4
    2.83 GB .zip

    Download
  • System Requirements
    • All SQLstream Blaze VMs are 64-bit and require a 64-bit host OS and a virtualization facility that supports a 64-bit guest OS.
  • Installed Products
    • s-Server data stream management platform.
      • See the full product documentation for installation, getting started, integration and building streaming SQL apps on s-Server.
      • The s-Server package includes s-Studio, the Eclipse-based IDE and s-Server administration platform.
      • The s-Server package includes the machine data collection agents and enterprise integration adapters.
    • StreamLab for intelligent guided data stream discovery, analysis and real-time dashboards without coding.
    • s-Dashboard for building real-time, push-based dashboard on any device (HTML5).

    Examples

    Example demonstrations for streaming analytics based on sample data is included in the VM package. The first demonstration is called Mochi.  This example streaming SQL application reads phone server, web server and transaction logs in order to detect suspicious bank account activity. Scripts for running the demonstration are included.  The second demonstration is called Buses and included traffic data.
  • Getting Started
    The QuickStart VM should require no administration beyond managing the installed products and services, and watching for log file size increases on the example applications. Here’s some information on setup and installation to get started. In the event that additional administration is required or that problems occur, this page provides information on accounts and possible explanations and solutions to some common questions.

    VM and Installation Setup

    You will be logged in automatically on VM startup as the blazer user with sudo privileges in the VM. No password required. From there, please refer to the installation document for the complete set of instructions, however, a few prompts are provided below:
    • Step 1: Double click the ‘FIRST Install SQLstream s-Server’ icon to run the installation wizard. SQLstream Blaze is installed as user sqlstream, password sqlstream. To verify that s-Server is installed and running typing service s-serverd status in a terminal window should return Server is listening on port 5570.
    • Step 2: Double click ‘Run Mochi Demo’ to load and start the example application (may take up to 5 minutes to complete ). Confirm the installation as follows:
      • Command: ls -l /tmp/mochi (to view the sample server log files)
      • Response: Two log files are created and increasing in size (transaction.log and web_login.log)
    • Step 3: Launch the ‘View Mochi Demo’ to view the Mochi streaming analytics outputs in s-Dashboard. Four real-time streaming dashboards are included in the Mochi example. Click on the dashboard start icon to launch each dashboard.
    • Step 4: Get up and running with StreamLab. Launch the ‘Start StreamLab Server’ icon. Wait for StreamLab server is now running on port 5590 response than launch StreamLab from the ‘StreamLab’ icon.
    • Step 5: Start up and explore the SQL code and streaming data with s-Studio.
      • Startup s-Studio from the desktop icon
      • Right click on ‘My First SQLstream Server’ in the Development or Management tabs, and select ‘Connect’ to connect to the s-Server instance.
      • Explore, for example, select Schema-Mochi-WebLoginEvents and select Inspect from the right-click menu.

    Using VMware

    To launch the VMware image you will either need a VMware Player for Windows or Linux, or VMware Fusion player for Mac. The latest versions of the players are recommended.

    Using VirtualBox

    No reported issues on Linux, Windows or OS X for VirtualBox 4.3.

    Using Parallels Desktop for Mac

    Parallels Desktop does not support the direct import of OVA tar files. The Blaze VM can be run on Parallels but must first be imported using VirtualBox or VMware to create a .vbi or .vmdk image, and the created image imported into Parallels. Parallels will convert the image to a native .pem image on import. Please contact technical support for further information and guidance.

Launch Blaze on AWS

Blaze on AWS is available in two ways:

  1. Pay As You Go: on the AWS Marketplace for hourly pay-as-you-go use.
  2. License Direct: as an EC2 AMI with a 60-day unrestricted free trial followed by free 1 GB/day use or a paid license direct from SQLstream
  • Installed Products
    • s-Server data stream management platform.
      • See the full product documentation for installation, getting started, integration and building streaming SQL apps on s-Server.
      • The s-Server package includes s-Studio, the Eclipse-based IDE and s-Server administration platform.
      • The s-Server package includes the machine data collection agents and enterprise integration adapters.
    • StreamLab for intelligent guided data stream discovery, analysis and real-time dashboards without coding.
    • s-Dashboard for building real-time, push-based dashboard on any device (HTML5).

    Examples

    Example demonstrations for streaming analytics based on sample data is included in the VM package. The first demonstration is called Mochi.  This example streaming SQL application reads phone server, web server and transaction logs in order to detect suspicious bank account activity. Scripts for running the demonstration are included.  The second demonstration is called Buses and included traffic data.

  • Step 1: Choose region

    Launch EC2 Wizard

  • Step 2: Choose instance type

    Blaze requires at least 2 cores and 4GB of RAM for a basic application, but more complex applications will require more cores and more RAM. If you are just getting started and want to run a demonstration, choose the t2.medium machine; however, if you have a real application to run, the r3.large is a better starting point because it is optimized for larger memory requirements.
    We support the following instance types on AWS:

    We support the following instance types

  • Step 3: Navigate to Security Group

    Click on “6. Configure Security Group” as shown below. You can skip “Configure Instance” “Add Storage” and “Add Tags” unless you have a specific need for them.

    The EC2 Management Console looks like this:

  • Step 4: Configure Security Group

    Use the EC2 Management Console to create the following rules. You’ll need to
    use the Add Rule button to add more lines

    Create a Security Group with the following policies:

    Type Protocol Port Range Source
    HTTP TCP 80 Custom | 0.0.0.0/0
    SSH TCP 22 Custom | 0.0.0.0/0
    Custom TCP Rule TCP 8080 Custom | 0.0.0.0/0
    Custom TCP Rule TCP 5570 Custom | 0.0.0.0/0
    Custom TCP Rule TCP 5585 Custom | 0.0.0.0/0
    Custom TCP Rule TCP 5590 Custom | 0.0.0.0/0
    Custom TCP Rule TCP 5595 Custom | 0.0.0.0/0
    Custom TCP Rule TCP 5580 Custom | 0.0.0.0/0
    Custom TCP Rule TCP 5591 Custom | 0.0.0.0/0
    Custom TCP Rule TCP 3000 Custom | 0.0.0.0/0
  • Step 5: Launch

    Click on the blue “Review and Launch” button

    The EC2 Management Console looks like this:

  • Step 6: Key configuration

    Click “Launch”

    A pop up window will appear regarding a Key Pair.

    You probably need SSH access and should choose an existing key pair, or create a new one, and then launch your instance

    Choose “Proceed without a key pair” if and only if you don’t need SSH access. You will need to check the “I acknowledge that I will not be able to connect…” box before your launch your instance.

    Important:
    If you choose the Proceed without key pair option, you won’t be able to connect to the instance via SSH.

  • Step 7: Connect To Blaze

    Once the “Status checks” shows 2/2, you will be able to access the blaze instance via:

    http://[your-ip]

    Copy either the public IPv4 or the public DNS (IPv4) address and paste it into a new browser window.

    The EC2 Management Console looks like this:

Launch Blaze on Azure

Blaze is available on the Azure Marketplace

  • Step 1: Azure Marketplace

    Go to Azure’s Marketplace

    1. Click the Get It Now Button on the lefthand side.
    2. Sign in with your Microsoft or work account.
    3. Accept SQLstream’s terms of use and privacy policy. You will be redirected to the SQLstream Blaze welcome home in the Azure Portal.
    4. Click the Create button.
  • Step 2: Configuration

    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

  • Step 3: Virtual Machine Size

    Select Virtual Machine Size. We recommend D2_Standard.

  • Step 4: Network Configuration

    Click on Network security group firewall and make sure that you have the following ports open:
    • 80
    • 3000
    • 5570
    • 5590
    • 5580
    • 5585
    • 5595
    • 22

    Click OK.

  • Step 5: Deployment

    Microsoft Azure will validate your purchase. Once it does, click OK. Validation passed notice.
    Wait until the deployment finishes in the notifications tab.

  • Step 6: Connect to SQLStream Blaze

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

  • Docs
  • Installed Products
    • s-Server data stream management platform.
      • See the full product documentation for installation, getting started, integration and building streaming SQL apps on s-Server.
      • The s-Server package includes s-Studio, the Eclipse-based IDE and s-Server administration platform.
      • The s-Server package includes the machine data collection agents and enterprise integration adapters.
    • StreamLab for intelligent guided data stream discovery, analysis and real-time dashboards without coding.
    • s-Dashboard for building real-time, push-based dashboard on any device (HTML5).

    Examples

    Example demonstrations for streaming analytics based on sample data is included in the VM package. The first demonstration is called Mochi.  This example streaming SQL application reads phone server, web server and transaction logs in order to detect suspicious bank account activity. Scripts for running the demonstration are included.  The second demonstration is called Buses and included traffic data.

Download Blaze Container from Docker Hub

If you are using Docker, Blaze can be downloaded as a Docker container from Docker Hub.

  • System Requirements
    • All SQLstream Blaze Containers are 64-bit and require a 64-bit host OS and a Docker version that supports 64-bit containers.
  • Installed Products
    • s-Server data stream management platform.
      • See the full product documentation for installation, getting started, integration and building streaming SQL apps on s-Server.
      • The s-Server package includes s-Studio, the Eclipse-based IDE and s-Server administration platform.
      • The s-Server package includes the machine data collection agents and enterprise integration adapters.
    • StreamLab for intelligent guided data stream discovery, analysis and real-time dashboards without coding.
    • s-Dashboard for building real-time, push-based dashboard on any device (HTML5).

    Examples

    Example demonstrations for streaming analytics based on sample data is included in the VM package. The first demonstration is called Mochi.  This example streaming SQL application reads phone server, web server and transaction logs in order to detect suspicious bank account activity. Scripts for running the demonstration are included.  The second demonstration is called Buses and included traffic data.

  • Step 1: Download SQLstream Blaze Container

    Run on your command line

    $ docker pull sqlstream/blaze

  • Step 2: Run

    $ docker run -p 80:80 -p 3000:3000 -p 5590:5590 -p 5570:5570 -p 5580:5580 -p 5585:5585 -p 5591:5591 -p 5595:5595 -it sqlstream/blaze:latest /bin/bash -d

  • Step 3: Access SQLstream Blaze

    Open your browser and go to:

    http://localhost

Download Blaze for Linux

The Blaze server (s-Server) can be installed on most Linux distributions. The graphical tools (StreamLab and s-Dashboard) are browser clients, and the platform IDE and admin module (s-Studio) is available for Windows as well as Linux.

SQLstream Blaze

SQLstream Blaze suite is available in two download packages, s-Server and StreamLab. First, download and install the core s-Server package which contains the s-Server stream processing platform with s-Dashboard, and s-Studio. Then download and install StreamLab.

  • SQLstream s-Server 5.1.1
    297.90 MB .run

    Download
  • SQLstream s-Server 5.2.1
    319.14 MB .run

    Download
  • SQLstream StreamLab 2.1.4
    16.12 MB .run

    Download
  • SQLstream StreamLab 2.2.1
    26.89 MB .run

    Download

Client Downloads for Windows

The Client Tools distribution provides developers with the tools and drivers required to build and test SQLstream client drivers and connectivity. Client Tools includes the Extensible Common Data Agent for streaming any type of data to SQLstream s-Server in real time.

  • s-Studio 5.1.1 for Windows (32-bit)
    86.09 MB .exe

    Download
  • s-Studio 5.1.1 for Windows (64-bit)
    86.08 MB .exe

    Download
  • Client Tools 5.1.1 for Windows
    88.15 MB .exe

    Download

Client Downloads for Linux

The Linux versions for s-Studio, JDBC driver and client tools are included with the core s-Server distribution above but are also available as separate downloads for larger scale rollout of user and test clients if required. The Client Tools distribution provides developers with the tools and drivers required to build and test SQLstream client drivers and connectivity. Client Tools includes the Extensible Common Data Agent for streaming any type of data to SQLstream s-Server in real time.

  • s-Studio 5.1.1 for Linux (64-bit)
    85.18 MB .run

    Download
  • Client Tools 5.1.1 for Linux (32-bit)
    98.60 MB .run

    Download
  • Client Tools 5.1.1 for Linux (64-bit)
    99.80 MB .run

    Download
  • System Requirements
    SQLstream s-Server System Requirements
    • A 64-bit version 2.6 or later Linux kernel distribution with Libc version 2.5 or later. Other Linux kernel versions are not supported. Tested Linux kernel distributions include:
    • CentOS 5.x
    • CentOS 6.x
    • CentOS 7.x
    • Redhat Enterprise Linux 5.x
    • Redhat Enterprise Linux 6.x
    • Redhat Enterprise Linux 7.x
    • Ubuntu 10.04 LTS (Lucid Lynx)
    • Ubuntu 12.04 LTS (Precise Pangolin)
    • Ubuntu 12.10 (Quantal Quetzal)
    • Ubuntu 13.04 (Raring Ringtail)
    • Ubuntu 14.04 LTS (Trusty Tahr)
    • Ubuntu 16.04 LTS (Xenial Xerus)
     
    • JDK (Java Development Kit) version 8. Earlier versions of Java are not supported. If the JAVA_HOME environment variable is not set or does not point to the JDK, the installer will prompt for its location. 64-bit Java is required for the 64-bit s-Server. If the JDK is not installed on your system, the Installer will attempt to download and install OpenJDK 8 for you.
    • 3G RAM
    • 2G available disk space
    • When running under VMWare, 3G physical RAM required on the guest system.
        SQLstream s-Studio System Requirements
    • Windows 10, Windows 8/8.1, Windows 7, or Windows Vista. Both 32-bit and 64-bit versions are supported.
    OR
    • A 64-bit version 2.6 or later Linux kernel distribution with Libc version 2.5 or later. Other Linux kernel versions are not supported. Tested Linux kernel distributions include:
      • CentOS 5.x
      • CentOS 6.x
      • CentOS 7.x
      • Redhat Enterprise Linux 5.x
      • Redhat Enterprise Linux 6.x
      • Redhat Enterprise Linux 7.x
      • Ubuntu 10.04 LTS (Lucid Lynx)
      • Ubuntu 12.04 LTS (Precise Pangolin)
      • Ubuntu 12.10 (Quantal Quetzal)
      • Ubuntu 13.04 (Raring Ringtail)
      • Ubuntu 14.04 LTS (Trusty Tahr)
      • Ubuntu 16.04 LTS (Xenial Xerus)
     
    • A 32-bit or 64-bit JRE (Java Runtime Environment) version 8. Earlier versions of Java are not supported. Use the 32-bit JRE for 32-bit Windows s-Studio installations. Use the 64-bit JRE for 64-bit Windows or Linux s-Studio installations.
    • 2G RAM
    • 1G available disk space
    • When running under VMWare, 2G physical RAM required on the guest system.
    • All SQLstream s-Studio system memory and disk requirements are above and beyond SQLstream s-Server system requirements when running on the same physical or virtual machine.
        SQLstream s-Dashboard System Requirements
    • A 64-bit version 2.6 or later Linux kernel distribution with Libc version 2.7 or later. Other Linux kernel versions are not supported. Tested Linux kernel distributions include:
      • Centos 6.x
      • Centos 7.x
      • Redhat Enterprise Linux 6.x
      • Redhat Enterprise Linux 7.x
      • Ubuntu 12.04 LTS (Precise Pangolin)
      • Ubuntu 12.10 (Quantal Quetzal)
      • Ubuntu 13.04 (Raring Ringtail)
      • Ubuntu 14.04 LTS (Trusty Tahr)
      • Ubuntu 16.04 LTS (Xenial Xerus)
     
    • The WebAgent component required for s-Dashboard to connect to s-Server requires JRE (Java Runtime Environment) version 8. Earlier versions of Java are not supported.
    • Microsoft Edge, Internet Explorer 11 (or later), Google Chrome 31 (or later), Mozilla Firefox 17 (or later), or Apple Safari 7 (or later).
    • 1G RAM
    • 1G available disk space
    • When running under VMWare, 1G physical RAM required on the guest system.
  • Installed Products

    SQLstream Blaze includes

    • SQLstream s-Server data stream management platform.
      • See the full product documentation for installation, getting started, integration and building streaming SQL apps on s-Server.
      • The s-Server package includes s-Studio, the Eclipse-based IDE and s-Server administration platform.
      • The s-Server package includes the machine data collection agents and enterprise integration adapters.
    • SQLstream StreamLab for intelligent guided data stream discovery, analysis and real-time dashboards without coding.
    • SQLstream s-Dashboard for building real-time, push-based dashboards on any device (HTML5).

    Examples

    An example demonstration for real-time log analytics based on a bank account fraud scenario is included in the Blaze package. Called Mochi, the example streaming SQL application reads phone server, web server and transaction logs in order to detect suspicious bank account activity. Scripts for running the demonstration are included.
  • Getting Started

    Getting up and running with SQLstream Blaze

      • Step 1: Download and install the SQLstream s-Server package. Please follow the steps in the SQLstream Blaze Installation Guide to install the s-Server package. You will then have installed the following products:
        • SQLstream s-Server with APIs, data collection agents and enterprise integration adapters
        • SQLstream s-Dashboard
        • SQLstream s-Studio
        • Client tools for test and development
      • Step 2: Download and install SQLstream StreamLab
    Please follow the steps in the Install StreamLab section in the SQLstream s-Server Installation Guide.
    • Step 3: Double click ‘Run Mochi Demo’ to load and start the example application (this may take up to 5 minutes to complete). Confirm the installation as follows:
      • Command: ls -l /tmp/mochi (to view the sample server log files)
      • Response: Two log files are created and increasing in size (transaction.log and web_login.log)
    • Step 4: Launch the ‘View Mochi Demo’ to view the Mochi streaming analytics outputs in s-Dashboard. Four real-time streaming dashboards are included in the Mochi example. Click on the dashboard start icon to launch each dashboard.
    • Step 5: Get up and running with StreamLab. Launch the ‘Start StreamLab Server’ icon. Wait for StreamLab server is now running on port 5590 response than launch StreamLab from the ‘StreamLab’ icon. From here, refer to the StreamLab Guide.
    • Step 6: Start up and explore the SQL code and streaming data with s-Studio.
      • Startup s-Studio from the desktop icon
      • Right click on ‘My First SQLstream Server’ in the Development or Management tabs, and select ‘Connect’ to connect to the s-Server instance.
      • Explore, for example, select Schema-Mochi-WebLoginEvents and select Inspect from the right-click menu.
      • Review the s-Studio documentation on the online product documentation.

Tutorials

This sequence starts with a freshly installed instance of Ubuntu and leads you through the installation of SQLstream Blaze and the construction of a streaming application in StreamLab. Our application starts with telemetry data on buses in the Sydney area and ends with a map of the buses in motion and with records on the fastest buses being written to an external database (PostgreSQL).

If you’re going to work through the tutorials, please start with the prerequisites and the first tutorial. If you just want to read through the tutorials to understand more about StreamLab, skip the installation tutorials and start with tutorial #4.

PREREQUISITES

SQLstream Blaze runs on Linux, and in this example we’ll be using Ubuntu 16.04 running in a virtual machine in VirtualBox. The following commands must be run by someone with superuser privileges on the machine:

Install Open JDK’s Java 8 JDK
sudo apt-get install openjdk-8-jdk
java –version to verify that it’s installed
Install PostgreSQL

sudo apt-get install postgresql
sudo apt-get install pgadmin3
sudo –u postgres createuser –d –P demo

(When prompted, set the password to: demodemo)