Output Formats for Writing

<< Click to Display Table of Contents >>

Navigation:  Integrating SQLstream Blaze with Other Systems > Writing Data Out of s-Server > Writing to Other Destinations >

Output Formats for Writing

Previous pageReturn to chapter overviewNext page

In s-Server, the destination for data writing and format for data are separate, meaning you can, for example, write JSON formatted data to the file system, a network socket, AMQP, Kafka, Amazon Kinesis, IBM MQ, Snowflake, MongoDB, over HTTP, and to a WebSocket.

s-Server supports the following data formats:

CSV

XML

JSON

BSON (new in 5.2)

You set data format through the FORMATTER parameter of the foreign stream for a data source. For example, the following AMQP foreign stream formats data as CSV.

CREATE OR REPLACE FOREIGN STREAM amqp_stream (

line VARCHAR(4096))

SERVER AMQPSERVER

OPTIONS (DESTINATION 'amq.topic',

CONNECTION_URL 'amqp://guest:guest@clientid/?brokerlist=''tcp://localhost:5672''',

FORMATTER 'CSV');

 

To change formatting to XML, enter FORMATTER 'XML', and so on.