Installing SQLstream Client Tools

<< Click to Display Table of Contents >>

Navigation:  Installing SQLstream Blaze > Installing s-Studio and Client Tools as Standalone Packages >

Installing SQLstream Client Tools

Previous pageReturn to chapter overviewNext page

The SQLstream Client Tools are a set of applications that assist you in running, testing, and maintaining your s-Server. By default, Client Tools install as part of the s-Server package. These instructions are for installing Client Tools in a standalone context.

You can run any of the client tools below as a regular user. Most of them use JDBC to connect with s-Server.

The following client tools install on both Linux and Windows:

Tool

Description

sqlline

SQLLine is a command-line tool for communicating with the SQLstream s-Server. It is a generic & open-source database client that works with any jdbc database. More information about SQLLine can be found at: http://sqlline.sourceforge.net/

datagen

Datagen generates test data for SQLstream applications, and pushes the data into SQLstream using the SQLstream JDBC Driver. For more information, see the topic Generating Test Data with DataGen in the Developer Guide.

datagen/jdbc

JDBC (Java DataBase Connectivity) is a standard Java API for connecting to relational databases and other data sources that can produce relational data.

ECD Agent

The ECDA Agent is a standalone Java application that mediates data between SQLstream s-Server and external data sources. It can be installed on a remote server in order to process or parse data at the site of collection. For example, if you have a server which generates log files, you may find it advantageous to have the ECDA Agent parse those files on the server itself, and pass rows to s-Server, as opposed to passing the entire file.

webAgent

webAgent functions as a simple, miniature Web server. It accepts HTTP requests, sends these to s-Server, and returns JSON objects. See json.org for more details on JSON objects.

Google Big Query Connector

SQLstream Google Big Query Connector is a bulk load script that lets you load s-Server data into Google Big Query.

Installation Notes for Linux

From a terminal prompt enter ./SQLstream-clienttools-X.Y.Z-x64.run, where X.Y.Z represent the release and version numbers, as in SQLstream-5.1.0, and x64 or x32 represents running on a 64-bit or 32-bit operating system.

oIf it does not work, make sure the file is executable (by running chmod +x SQLstream-sStudio-X.Y.Z-x64.run), and try double-clicking the SQLstream icon again.
oIf the installer still does not launch, it generally means JAVA_HOME is not in the default PATH, so the installer fails to find/run Java to execute the installer. Ensure that JAVA_HOME is in the default PATH and try double-clicking the icon again.

Client tools are all pure Java, so they should run on any system that has a Java Runtime Environment (JRE) or Java Development Kit (JDK) installed. Moreover, the 32-bit Linux installer (SQLstream-client-tools-x.y.z-linux.run) should generally run on any Linux system. However, some 64-bit Linux systems are not properly configured to handle 32-bit applications. If you run the 32-bit installer and nothing happens, this may be the case for your system. In this case, you can use the 64-bit installer (SQLstream-client-tools-5.1.0-linux-x64.run) to install the same client tools.

Installation Notes for Windows

To install Client Tools on Windows, launch SQLstream-client-tools-5.1.0-windows.exe.

Before installing client tools on Windows, you need to make sure Java is installed and in the installing user's path.

Installation Process

After you launch the installer on either platform, a welcome page appears.

1.Click Forward.

The SQLstream License Agreement page appears. Click I accept the agreement.

inst_installer_client_tools_license

2.Click Forward.

The Installation Directory page appears. This page lets you select directories for the client tools. Note: the installation user must have permission for these directories.To change directories, click the browse button to the right of the directory field.

inst_installer_client_tools_directory

3.Click Forward. The Select Components page opens. By default, all tools are selected. Deselect those components that you wish to not install.

inst_installer_client_tools_select

4.Enter the name of the server on which s-Server is installed.

inst_installer_client_tools_serverinfo

5.Click Forward. to begin the installation process. The installer displays a progress bar to show you how far along installation has progressed.

inst_client_tools_installer_installing

Installation is complete when the progress bar reaches 100%. You will see a confirmation dialog box.

inst_client_tools_installer_completed

6.Click Finish to exit the installer and/or view the Readme file.