Exasol is a high-performance, in-memory analytics database built for fast queries on large datasets. This Dataddo destination loads data from any source into a table in your Exasol database.
Authorize Connection to Exasol
Prerequisites
- A running Exasol instance reachable by Dataddo. If you use a firewall, allow the Dataddo IPs.
- A database user with rights to create tables and to insert, update, and delete rows in the target database.
Create the authorizer
In Authorizers, click Authorize New Service and select Exasol, then fill in the fields:
| Field | Description |
|---|---|
| Label | A name so you can recognize the connection later. Default: Exasol. |
| Server IP or Hostname | Public IP or hostname of your Exasol server. It should not contain whitespaces. |
| Database | Name of the database you will use for writing the data. |
| Username | Username for authentication. |
| Password | Password for authentication. |
| Port | Port to connect to Exasol. Default: 8563. |
| TLS/SSL Settings | Keep the value on PREFER to use an SSL connection when available. Use REQUIRED to enforce SSL with no fallback to an unencrypted connection. Default: require. |
| Use SSH tunnel | Optional. To connect through an SSH tunnel, create it first on the Security settings page, then pick it here. |
Click Save. Dataddo validates the connection.
Create an Exasol Destination
Go to Destinations, click Create Destination, and select Exasol. Give the destination a name and choose the authorizer, then click Save.
Write Modes
The write mode decides how each flow run changes the target table. Exasol offers the standard set below, and the default is insert. Which modes are available, and whether you can switch modes on an existing flow, can depend on the table's current state.
| Mode | Meaning | Composite Key |
|---|---|---|
insert |
Appends new rows on every run. | No |
insert_ignore |
Appends rows, skipping rows that already exist. | Yes |
truncate_insert |
Empties the table, then writes the current data. | No |
upsert |
Inserts new rows and updates existing rows matched by the Composite Key. | Yes |
update |
Updates existing rows matched by the Composite Key; fails rows with no match. | Yes |
update_ignore |
Updates matched rows, skipping rows with no match. | Yes |
delete |
Deletes rows matched by the Composite Key. | Yes |
Composite Key
The Composite Key is the set of columns whose combined values identify each row. Every mode except insert and truncate_insert needs one. You can select up to 4 columns.
Table Naming
Dataddo creates the table on the first write if it does not exist. When you name the table:
- The table name should contain only letters, numbers, underscores, or dashes.
- You can put date-range patterns such as
{{1d1}}in the table name.
How to Create a Flow to Exasol
- Go to Flows and click Create Flow.
- Add one or more sources.
- Add Exasol as the destination and pick the authorizer.
- Choose a write mode, and a Composite Key for modes that need one.
- Set the table name.
- Set the schedule and click Save.
Troubleshooting
Invalid table name
The table name does not match Exasol's naming rules. Fix the name in the flow to match the rules in Table Naming, then restart the flow.
Insufficient privileges
The database user cannot create tables or write rows in the target database. Grant the user create, insert, update, and delete rights, then restart the flow.
Cannot connect to Exasol
Dataddo cannot reach Exasol. Check the credentials in the authorizer, and make sure the server is reachable by Dataddo. If you use a firewall, allow the Dataddo IPs.