Advanced Analytica Advanced Analytica: IBOM
← All connectors
EX

Destination connector

Exasol

Send governed data into Exasol with a clear, practical setup guide.

Version 0.1.1 archived alpha

Exasol

Exasol is an in-memory database built for analytics.

Sync overview

Output schema

Each Airbyte Stream becomes an Exasol table. Each Airbyte Field becomes an Exasol column. Every Exasol table created by Airbyte contains three columns:

  • _AIRBYTE_AB_ID: a uuid that Airbyte assigns to each processed event. The Exasol column type is VARCHAR(64).
  • _AIRBYTE_DATA: a json blob containing the event data. The Exasol column type is VARCHAR(2000000).
  • _AIRBYTE_EMITTED_AT: a timestamp showing when the event was pulled from the data source. The Exasol column type is TIMESTAMP.

Features

The Exasol destination supports these features:

FeatureSupported? (Yes/No)Notes
Full Refresh SyncYes
Incremental - Append SyncYes
Incremental - Append + DedupedNo
NormalizationNo
NamespacesYes
SSL connectionYesTLS
SSH Tunnel SupportNo

Limitations

Maximum data size: two million characters

Exasol doesn’t have a dedicated data type for arbitrary-length data or JSON. This connector therefore stores Airbyte data using type VARCHAR(2000000).

Getting started

Requirements

You’ll need Exasol database version 7.1 or above to use the Exasol destination.

Network access

Make sure Airbyte can access your Exasol database. For databases within a VPC, you may need to allow the IP used to expose Airbyte.

Permissions

Airbyte namespaces let you store data in different schemas. Each scenario requires different permissions for the user account. The following table describes four scenarios for the login user and destination user.

Login userDestination userRequired permissionsComment
DBA UserAny user-
Regular userSame user as loginCreate, drop and write table, create session
Regular userAny existing userCreate, drop and write ANY table, create sessionGrants can be provided on a system level by DBA or by target user directly
Regular userNot existing userCreate, drop and write ANY table, create user, create sessionGrants should be provided on a system level by DBA

You should create an Airbyte-specific user for this purpose.

Setup guide

You now have everything needed to configure Exasol as a destination in the UI. You’ll need these details:

  • Host
  • Port
  • Fingerprint of the Exasol server’s TLS certificate (if the database uses a self-signed certificate)
  • Username
  • Password

Changelog

Expand to review
VersionDatePull RequestSubject
0.1.12023-02-21xxxFix the build
0.1.02023-01-??21200Initial version of the Exasol destination
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.