Exasol
Exasol is an analytics-focused parallelized relational database management system (RDBMS). Connect to an Exasol database to create,read, update and delete data.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Copilot Studio | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | Exasol |
| URL | https://github.com/exasol/power-apps-connector/issues |
| integrationteam@exasol.com |
| Connector Metadata | |
|---|---|
| Publisher | Exasol AG |
| Website | https://www.exasol.com/ |
| Privacy policy | https://www.exasol.com/privacy-policy |
| Categories | Data;Business Intelligence |
Prerequisites
You will need the following to proceed:
- A Microsoft Power Apps or Power Automate plan
- An Exasol database
- Exasol REST API set up, internet facing
How to get credentials
Currently the connector uses an API Key as the default authentication method.
The API key(s) can be set in the Exasol REST API which you're also required to set up to use this connector.
Get started with your connector
You should first set up the Exasol REST API (see: https://github.com/exasol/exasol-rest-api).
The connector itself takes 2 parameters when creating a new connection:
'Host': Where your REST API is hosted (this can be an IP address or DNS name).
'API Key': This is one of the authentication keys you've configured to gain access to the REST API.
Note: You can still edit these 2 values afterwards.
Please see the user guide for more detailed instructions and a full tutorial here.
Known issues and limitations
Using a on-premises data gateway is currently not supported.
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
| Name | Type | Description | Required |
|---|---|---|---|
| API Key | securestring | The API Key for this API | True |
| Host | string | Host (ip address or host name) | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Delete rows from a table based on a condition |
Delete zero or more rows from a table providing a WHERE condition |
| Execute a statement on the Exasol database |
Execute a statement without a result set |
| Get rows from a table based on a condition |
Get zero or more rows from a table providing a WHERE condition |
| Get tables that are available for the user |
Get a list of all available tables |
| Insert row to a table |
Insert a single row into an Exasol table |
| Query the Exasol database |
Provide a query and get a result set |
| Update rows in a table based on a condition |
Update zero or more row in a table based on a condition |
Delete rows from a table based on a condition
Delete zero or more rows from a table providing a WHERE condition
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
comparisonPredicate
|
comparisonPredicate | string | ||
|
columnName
|
columnName | string | ||
|
value
|
value | |||
|
schemaName
|
schemaName | string | ||
|
tableName
|
tableName | string |
Returns
Execute a statement on the Exasol database
Execute a statement without a result set
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
sqlStatement
|
sqlStatement | string |
Returns
- response
- object
Get rows from a table based on a condition
Get zero or more rows from a table providing a WHERE condition
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Exasol schema name
|
schemaName | True | string |
Exasol schema name |
|
Exasol table name
|
tableName | True | string |
Exasol table name |
|
Exasol column name for WHERE clause
|
columnName | string |
Exasol column name for WHERE clause |
|
|
Comparison predicate for WHERE clause
|
comparisonPredicate | string |
Comparison predicate for WHERE clause |
|
|
Value of the specified Exasol column
|
value | string |
Value of the specified Exasol column |
|
|
Type of the value: string, bool, int or float
|
valueType | string |
Type of the value: string, bool, int or float |
Returns
- response
- object
Get tables that are available for the user
Insert row to a table
Insert a single row into an Exasol table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
columnName
|
columnName | string | ||
|
value
|
value | |||
|
schemaName
|
schemaName | string | ||
|
tableName
|
tableName | string |
Returns
Query the Exasol database
Provide a query and get a result set
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
SELECT query
|
query | True | string |
SELECT query |
Returns
- response
- object
Update rows in a table based on a condition
Update zero or more row in a table based on a condition
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
comparisonPredicate
|
comparisonPredicate | string | ||
|
columnName
|
columnName | string | ||
|
value
|
value | |||
|
columnName
|
columnName | string | ||
|
value
|
value | |||
|
schemaName
|
schemaName | string | ||
|
tableName
|
tableName | string |
Returns
Definitions
exasol_rest_api.APIBaseResponse
| Name | Path | Type | Description |
|---|---|---|---|
|
exception
|
exception | string | |
|
status
|
status | string |
exasol_rest_api.GetTablesResponse
| Name | Path | Type | Description |
|---|---|---|---|
|
exception
|
exception | string | |
|
status
|
status | string | |
|
tablesList
|
tablesList | array of exasol_rest_api.Table |
exasol_rest_api.Table
| Name | Path | Type | Description |
|---|---|---|---|
|
schemaName
|
schemaName | string | |
|
tableName
|
tableName | string |
object
This is the type 'object'.