ODBC Data Source (Preview)
Connect to on-premise ODBC Data Source to create connection
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions except the following: - US Department of Defense (DoD) |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs
| Name | Type | Description | Required |
|---|---|---|---|
| ODBC Connection String | string | Specify the ODBC Connection String (e.g. dsn=mydatasourcename) | True |
| Authentication | string | Authentication type | |
| Username | securestring | Username credential | |
| Password | securestring | Password credential | |
| Gateway | gatewaySetting | On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 5000 | 60 seconds |
Actions
| Get tables |
This operation gets tables from a database. |
Get tables
Definitions
TablesList
Represents a list of tables.
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
value |
List of Tables |