TDS is the protocol used by Microsoft SQL Server, a popular relational database management system. Due to its prevalence, many applications allow connection to SQL Server via the TDS protocol. This section covers examples of connection to the Connect TDS remoting service, metadata discovery and supported queries.

Connecting to TDS

There are many libraries and application that allow you to connect to SQL Databases. See Connecting to TDS for examples on how to connect to the Connect TDS endpoint from various tools and applications

Schema Discovery

Before running any SQL queries against a connection, you will need to know what resources are available. See Schema Discovery for information on how to discover what tables, views and procedures are available through the Connect TDS endpoint.

Query Syntax

SQL syntax allows for a variety of filtering and formatting options to retrieve data, as well as data-manipulation functionality. See Query Syntax for examples of what queries are supported in the Connect TDS endpoint.