Exasol
German in-memory analytics database, read with SQL through JDBC, ODBC or the WebSocket API.
- Category
- Cloud & Data Platforms
- Type
- Data warehouse & lakehouse
- Interface
- database interface
- Built with
- Connect Anything
- Credentials
- Username and password, Access token
- Docs
- Exasol API docs
02Data
What you can sync.
- Sql query results
- Tables
- Schemas
Put Exasol sql query results next to revenue and usage, so every cost has an owner and a reason.
Need more? Name any other Exasol data the API returns, and the AI adds it to the connector.
03Credentials
Credentials you will need.
- A username and password
- An access token
Exasol uses a username and password or an access token. You add the credentials once, when the AI asks for them, and it tells you where to create them in Exasol if you need help.
04How it works
How it works in DataMind.
-
Pick Exasol.
Open Lake, pick Exasol in the source picker and name the connection. Connect Anything opens with a ready prompt that points the AI at the Exasol API docs.
-
Answer a few questions.
The AI reads the Exasol documentation, then asks which credentials you will use, which data to sync (for example sql query results and tables), whether you want a one-time load or a recurring sync, and which accounts or filters apply.
-
Your data lands in Lake.
The connector agent writes a Python connector for Exasol, tests it against the live API and shows you sample rows. Then the data loads into your Lake on your schedule, ready for the Warehouse, DataPrism BI and AI Minds.
05Related
More like Exasol.
ClouderaData warehouse & lakehouse
DatabricksData warehouse & lakehouse
SAP DatasphereData warehouse & lakehouse- Teradata VantageCloudData warehouse & lakehouse
Apache HiveData warehouse & lakehouse
DremioData warehouse & lakehouse
FireboltData warehouse & lakehouse
IBM watsonx.dataData warehouse & lakehouse