Integrating SQLstream Blaze with Other Systems

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Integrating SQLstream Blaze with Other Systems

Previous pageReturn to chapter overviewNext page

Purpose

The purpose of this document is to describe the many different ways in which SQLstream s-Server can be integrated with external systems. Topics covered include:

Reading and writing data to RDBMS systems. These include Microsoft SQL Server, Oracle, MySQL, PostgreSQL, and Teradata.
The SQLstream JDBC driver. This driver lets applications connect to s-Server.
Reading from Other Sources. You can read data from a variety of sources, including the file system, sockets, AMQP, Kafka, IBM MQ, Amazon Kinesis, and web feeds. You can read from both local and remote sources. You can read from a variety of formats, including CSV, XML, JSON, Key Pair Values, ProtoBuf, Variable Column Data, Fixed Column Data, and W3C Data. You can also parse files with a FastRegex row filter. If you need information about the file to be parsed, including help on parsing options, you can use the Discovery Parser to get this information.
Writing to Other Destinations. You can write data to a variety of sources, including the file system, sockets, AMQP, Kafka, Amazon Kinesis, IBM MQ, and mail servers You can write to both local and remote sources. You can write files in CSV, XML, and JSON.
Transforming Data in s-Server, which describes built-in user-defined transformations and user-defined functions, such as the Parser UDX (which lets you invoke the parsers described in Reading from other Sources), Group Rank UDX and GeoIPFunctions UDX.
SQLstream Software Development Kit (SDK), which includes information on how to write an Extensible Common Data Framework Plugin, how to write a User Defined Function (UDF) and how to write a User Defined Transform (UDX).

Audience

This document is aimed at developers and system architects.

Related Documents

Concepts Guide
Getting Started Guide
Installation Guide
Administrator Guide
Streaming SQL Reference Guide
Glossary