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

Operation ID:

DeleteRows

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

Body

exasol_rest_api.APIBaseResponse

Execute a statement on the Exasol database

Operation ID:

ExecuteNonQuery

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

Operation ID:

GetRows

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

Operation ID:

GetTables

Get a list of all available tables

Returns

Body

exasol_rest_api.GetTablesResponse

Insert row to a table

Operation ID:

InsertRow

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

Body

exasol_rest_api.APIBaseResponse

Query the Exasol database

Operation ID:

ExecuteQuery

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

Operation ID:

UpdateRows

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

Body

exasol_rest_api.APIBaseResponse

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