The CData ODBC Driver for Azure Table Storage is a standards-based ODBC driver with editions for Windows and Linux operating systems. The following sections show how to create an ODBC data source and query data.

Creating a DSN on Your Platform

The following guides show how to use the standard tools to configure data source names (DSN).

• Windows

  Windows DSN Configuration shows how to configure a DSN with the Microsoft ODBC Administrator tool.

• Linux

  Linux DSN Configuration shows how to configure DSNs with several major driver managers on Linux.

Azure Table Storage Version Support

The version support for Azure Table Storage varies based on the driver configuration.

If Backend is set to CosmosDB, the driver uses version 2019-02-02 of the Azure CosmosDB REST API.

If Backend is set to "AzureStack", "Storage", or "Emulator", then the API version used depends on the AuthScheme connection property:

• AuthScheme=AzureAD: The driver uses version 2017-11-09 of the Azure Storage REST API.
• AuthScheme=AccessKey: The driver uses version 2014-02-14 of the Azure Storage REST API.
• AuthScheme=SharedAccessSignature: The driver uses the version of the Azure Storage REST API that is specified in the "sv" parameter in the shared access key.
  • For example, if your shared access key has the value "sv=2018-03-28", the version used will be 2018-03-28.

See Also

See the following sections to connect to the DSN from tools and from code:

• Using from Tools: Connect to the DSN from various tools on different platforms.
• Using ODBC: Connect to the DSN using the native ODBC API.
• Create a Linked Server: Connect to the DSN as a remote SQL Server database.
• MySQL Remoting: Connect to the DSN over the MySQL protocol.