Plugins

<< Click to Display Table of Contents >>

Navigation:  Understanding Streaming SQL Concepts > SQLstream Overview >

Plugins

Previous pageReturn to chapter overviewNext page

You can access foreign data in two ways:

Method

Data Accessed

SQL Verbs

Through MED/JDBC

Foreign databases, including relational and non relational sources.

SELECT, INSERT, UPDATE, DELETE, MERGE

Through the Extensible Common Data Adapter

Non-relational, semi-structured data, including CSV, XML, BSON, and JSON data, accessed through the file system, network sockets, WebSockets, HTTP, Apache Kafka, AMQP, Amazon Kinesis, and IBM MQ.

SELECT, INSERT

Accessing Foreign Data

A Foreign Data Wrapper provides access from within s-Server to an external system via an adapter. The Data Wrapper lets s-Server know that a data source or destination--such as a database or flat file--exists. s-Server also requires you to define server objects, which store credentials, version information, and so on for a foreign stream or database.