Del via


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
Email 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

Get a list of all available tables

Returns

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'.