Name		Name	Last commit message	Last commit date
parent directory ..
.vscode		.vscode
DirectQueryForSQL.pq		DirectQueryForSQL.pq
DirectQueryForSQL.proj		DirectQueryForSQL.proj
DirectQueryForSQL.query.pq		DirectQueryForSQL.query.pq
DirectQueryForSQL16.png		DirectQueryForSQL16.png
DirectQueryForSQL20.png		DirectQueryForSQL20.png
DirectQueryForSQL24.png		DirectQueryForSQL24.png
DirectQueryForSQL32.png		DirectQueryForSQL32.png
DirectQueryForSQL40.png		DirectQueryForSQL40.png
DirectQueryForSQL48.png		DirectQueryForSQL48.png
DirectQueryForSQL64.png		DirectQueryForSQL64.png
README.md		README.md
resources.resx		resources.resx

README.md

Direct Query using SQL Server ODBC

This sample creates an ODBC based custom connector that enables Direct Query for SQL Server.

The code does the following:

Declares a new data source kind (DirectSQL)
Builds a record containing connection string properties specific to the SQL Server Native Client 11.0 driver
Sets credential related connection string properties separately
Overrides default ODBC capabilities returned by the driver
Wraps M's built-in ODBC function - Odbc.DataSource

Please see the comments in the code for more details.