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|
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.