Power Query
Search…
published
Introduction
Accessing Data
Access
Active Directory
Adobe Analytics
Ado Dot Net
Amazon Redshift
Analysis Services
Apache Spark
App Figures
Azure Enterprise
Azure Hive LLAP
Azure Spark
Azure Storage
Cdm
Cds
Com Score
Csv
Customer Insights
Data Lake
Data World
DB 2
Denodo
Document DB
Dremio
Dynamics 365 Business Central
Dynamics 365 Business Central On Premises
Dynamics 365 Financials
Dynamics Nav
Exasol
Excel
Exchange
Facebook
File
Folder
Github
Google Analytics
Google Big Query
Hdfs
Hd Insight
Impala
Informix
Jethro ODBC
Json
Kusto
Kyligence
Mail Chimp
Marketo
Marketplace
Microsoft Azure Consumption Insights
Mixpanel
My SQL
Netezza
O Data
Odbc
Odbc.DataSource
Odbc.InferOptions
Odbc.Query
Ole Db
Oracle
Paxata
Planview Enterprise
Postgre SQL
Power BI
Projectplace
Python
Quick Books
R
R Data
Salesforce
Sap Business Warehouse
Sap Hana
Share Point
Smartsheet
Snowflake
Soda
Spark
Spark Post
Sql
Stripe
Sweet IQ
Sybase
Team Desk
Teradata
Troux
Twilio
Ty Graph
Vertica
VSTS
Web
Webtrends
Xml
Zendesk
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
Odbc.DataSource

Odbc.DataSource

Returns a table of SQL tables and views from the ODBC data source.
function (optional connectionString as nullable any, optional options as nullable record) as table

Description

Returns a table of SQL tables and views from the ODBC data source specified by the connection string connectionString. connectionString can be text or a record of property value pairs. Property values can either be text or number. An optional record parameter, options, may be provided to specify additional properties. The record can contain the following fields:
CreateNavigationProperties : A logical (true/false) that sets whether to generate navigation properties on the returned values (default is true).
HierarchicalNavigation : A logical (true/false) that sets whether to view the tables grouped by their schema names (default is false).
ConnectionTimeout : A duration which controls how long to wait before abandoning an attempt to make a connection to the server. The default value is 15 seconds.
CommandTimeout : A duration which controls how long the server-side query is allowed to run before it is canceled. The default value is ten minutes.
SqlCompatibleWindowsAuth : A logical (true/false) that determines whether to produce SQL Server-compatible connection string options for Windows authentication. The default value is true.

Category

Accessing data
Previous
Odbc
Next
Odbc.InferOptions
Last modified 3yr ago
Copy link
Contents
Odbc.DataSource
Description
Category