Writing Data Out of s-Server
Once you have analyzed, enriched, or otherwise modified data, you will often want to write this data out of s-Server into other locations, or "sinks". This integration guide describes a number of ways to egress data. All data egress moves through an s-Server foreign stream. A foreign stream is an s-Server object that serves as a "tank" to hold streaming data. Once you have established a foreign stream, you can pump data into the foreign stream in order to move it into the external location.
There are two basic categories for writing data out of s-Server:
•Writing data into RDBMS locations (or sinks). You can use s-Server to write directly to RDBMS tables. See Writing Data to RDBMS Sources in this guide.
•Writing data to all other locations using the Extensible Common Data framework. This framework lets you identify a location and write data to it in one of three formats: CSV, XML, or JSON. See Reading Data to Other Locations in this guide, as well as the specific topics
For all of the above sources, you can configure input in three ways. This guide focuses on the third option, creating a foreign stream by hand in SQL, but the principles described within apply to both StreamLab and s-Studio.
1.Using StreamLab, a graphical interface, to set up a connection with a source. For more details, see Adding Sources in StreamLab in the StreamLab Guide. (You can still connect with sources that you've created in StreamLab using SQL.)
2.Creatin a foreign stream in s-Studio, SQLstream's Integrated Development Environment. For more details, see Creating Objects in s-Studio in the SQLstream s-Studio Guide.
3.Creating a foreign stream by hand in SQL, then running this SQL in s-Server using sqlline. This process is described below under topics for each source. The Streaming SQL Reference Guide provides configuration details in the topic CREATE FOREIGN STREAM. For information on using sqlline, see the Using sqlline to Run SQL in s-Server.