You can access foreign data in two ways:

Method Data Accessed Available 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, Avro, XML, BSON, and JSON data, accessed through the file system, network sockets, WebSockets, HTTP, Apache Kafka, AMQP, and Amazon Kinesis. 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.