ODBC Driver for Microsoft Bing

Build 22.0.8389

Linked Server

CData supports creating a linked server in SQL Server Management Studio with our ODBC drivers. This section describes the benefits of using a linked server, how to create a linked server, metadata discovery using a linked server, and executing queries from the linked server.

Linked Server Benefits

You can use a SQL Linked Server to connect to the CData SQL Gateway. SQL Server treats the CData SQL Gateway as a linked SQL Server instance, so you can write full SQL queries to query your Bing data without losing performance as would happen connecting to an ODBC data source directly. The connection can be made locally or to the Gateway located on a separate machine.

Create a Linked Server

See Create a Linked Server for information on creating a linked server in SQL Server Management Studio. Linked server support is enabled through the ODBC remoting feature. The ODBC remoting feature allows you to connect to the ODBC driver from remote machines. You connect to each ODBC data source as a virtual MySQL or SQL Server database, communicating through the MySQL or TDS (SQL Server) protocols. ODBC remoting is managed through the CData SQL Gateway application. The remoting feature is only available in the Windows edition.

Metadata Discovery

See Metadata Discovery for information on discovering metadata using the linked server from any tool that can connect to SQL Server.

Executing Queries

See Executing Queries for information on executing queries using the linked server from any tool that can connect to SQL Server.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8389