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 |
---|---|---|
Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - 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) |
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) |
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 |
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
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.
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.
Using a on-premises data gateway is currently not supported.
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Not shareable |
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 |
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 100 | 60 seconds |
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 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 without a result set
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
sqlStatement
|
sqlStatement | string |
Returns
- response
- object
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
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
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 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
Name | Path | Type | Description |
---|---|---|---|
exception
|
exception | string | |
status
|
status | string |
Name | Path | Type | Description |
---|---|---|---|
exception
|
exception | string | |
status
|
status | string | |
tablesList
|
tablesList | array of exasol_rest_api.Table |
Name | Path | Type | Description |
---|---|---|---|
schemaName
|
schemaName | string | |
tableName
|
tableName | string |
This is the type 'object'.