Software
EXASuite is an integrated, self-contained software bundle provided by Exasol.
This standalone distribution includes the Exasol Database, EXAoperation (a Web-based database administration user interface), EXACluster OS services, a runtime environment, and an underlying enterprise operating system (CentOS with Linux Kernel).
Exasol Clients and Drivers include sql clients and the drivers provided by Exasol (eg. ODBC, JDBC, ADO.NET).
SQL Development Tools
For creating, editing and executing SQL code graphically, we can recommend several tools:
- DbVisualizer: Universal database tool that has been optimized to support specific Exasol features. Expert developers from both Exasol and DbVis Software are working jointly together.
- DataGrip: Commercial SQL Client with very good support for UDF developers. DataGrip is based on Jetbrain's powerful IDE platform.
- DBeaver: Open-source SQL Client with comprehensive support for Exasol.
Drivers
There are currently three important standardized interfaces for which Exasol provides the necessary driver software:
- ODBC (Open Database Connectivity)
- JDBC (Java Database Connectivity)
- ADO.NET (Abstract Data Objects .NET)
In addition, there is the possibility to access EXASolution with the help of the OLE DB Provider for ODBC Drivers from Microsoft via an OLE DB interface (Object Linking and Embedding Database).
By integrating the drivers in your application, they are enabled to send SQL requests, present the results and load data into EXASolution. For larger bulk loads it is recommended to use the EXAloader.
In addition, Exasol provides a client SDK (software development kit) in order to integrate EXASolution into your own applications. Our drivers and SDK are publicly and can be downloaded from the download page.
