SQL examples for SQL Server

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with OData.

• Filter records using client-side criteria
• Filter records using server-side criteria
• Read all records from a JSON OData service table
• Read all records from an XML OData service table
• Read all tables (JSON format)
• Read all tables (XML format)