Maintenance Notification:
On next Monday August 5th 2019 starting at 7am CEST we will conduct some maintenance. You might encounter some issues using the Exasol User Portal and Issue Tracker! We will restore the Exasol User Portal and Issue Tracker before 9am CEST on Monday August 5th 2019.

Page tree

                           


Exasol is happy to share the latest and greatest from our open source community with the world. Below, you can see a list of our Github projects and a link to the latest release. 

NOTE: Inclusion in this list does not guarantee that the project is officially supported by Exasol. Please view the Readme of the various projects to see if it is officially supported or not.

Exasol on Docker

Project NameDescriptionDownload
Docker DBDockerized version of the Exasol Database for testing purposeshttps://github.com/exasol/docker-db/releases

Virtual Schemas

Project NameDescriptionDownload
Virtual SchemasExasol Virtual Schemas are an abstraction layer that makes external data sources accessible in our data analytics platform through regular SQL commandshttps://github.com/exasol/virtual-schemas/releases

Dialects and Connectors

Project NameDescriptionDownload
Kafka Connect JDBC ConnectorExasol database dialect example setup for Kafka Confluent JDBC Connectorhttps://github.com/exasol/kafka-connect-jdbc-exasol
Spark Exasol ConnectorThis is a connector library that supports an integration between Exasol and Apache Spark. Using this connector, users can create Spark dataframes from Exasol queries and save Spark dataframes as Exasol tables.https://github.com/exasol/spark-exasol-connector/releases
Power BI - Exasol ConnectorThe Exasol Microsoft Power BI Connector is a Certified Custom Connector now and is also shipped with Power BI desktop. The powerbi-exasol repository will contain the latest release which might contain modifications not yet included in the stable version.https://github.com/exasol/powerbi-exasol
Exasol Hibernate Dialect This repository contains a custom dialect to support ORM via JPA and Hibernate 5 using the Exasol database.https://github.com/exasol/hibernate-exasol
Django - Exasol

This project contains the necessary dialect to integrate Exasol into the Django framework.

https://github.com/exasol/django-exasol
SQLAlchemy Dialect for Exasol

This is an SQLAlchemy dialect for the Exasol database.

https://github.com/exasol/sqlalchemy-exasol
Exasol Informatica Connector ArchitectureTemplate for system and software architecture done with OpenFastTrace.https://github.com/exasol/exasol-informatica-connector-architecture

Data Science

Project NameDescriptionDownload

Data Science Examples

This repository contains a collection of examples and tutorials for Data Science and Machine Learning with Exasol.

https://github.com/exasol/data-science-examples

Script Language Containers

This project contains implementations for user defined functions (UDF's) that can be used in the Exasol database (version 6.0.0 or later)

https://github.com/exasol/script-languages/releases

R Package for Exasol

The Exasol R Package offers interface functionality such as connecting to, querying and writing into an Exasol Database (version 5 onwards). 

https://github.com/exasol/r-exasol

Python Package for Exasol - PyExasol

PyEXASOL is a custom Python driver for Exasol created by Badoo. It helps them to handle massive volumes of data commonly associated with this database.

https://github.com/exasol/pyexasol

Data Loading

Project NameDescriptionDownload

Cloud Storage ETL UDFs

his repository contains helper code to create Exasol ETL UDFs in order to read from and write to public cloud storage services such as AWS S3Google Cloud Storage and Azure Blob Storage.

https://github.com/exasol/cloud-storage-etl-udfs/releases

Hadoop ETL UDFs

Hadoop ETL UDFs are the main way to transfer data between Exasol and Hadoop (HCatalog tables on HDFS). The SQL syntax for calling the UDFs is similar to that of Exasol's native IMPORT and EXPORT commands, but with added UDF paramters for specifying the various necessary and optional Hadoop properties.

https://github.com/exasol/hadoop-etl-udfs

Database Migration

This project contains SQL scripts for automatically importing data from various data management systems into Exasol.

https://github.com/exasol/database-migration

Utilities

Project Name

Description

Download

Exa Toolbox

The EXA-toolbox is a collection of useful scripts and views that you can add to your Exasol installation.

https://github.com/exasol/exa-toolbox/blob/master/load_scripts_from_github.sql

Opendata Examples

Contains SQL scripts for loading open datasets into Exasol

https://github.com/exasol/opendata-examples

Nagios Monitoring

The Exasol nagios monitoring container provides users a simple starting point for setting up a monitoring system for your Exasol database. 

https://github.com/exasol/nagios-monitoring

EXAOperation XMLRPC API

This project contains Python script examples how to automate the administration of Exasol cluster using its XMLRPC API instead of EXAoperation's web interface

https://github.com/exasol/exaoperation-xmlrpc

SQL Statement Builder

The Exasol SQL Statement Builder abstracts programmatic creation of SQL statements and is intended to replace ubiquitous string concatenation solutions which make the code hard to read and are prone to error and security risks.

https://github.com/exasol/sql-statement-builder/releases

ETL Utilities

The Query Wrapper is a lightweight object-oriented Lua script used as a library to build procedural ETL jobs in Lua.

https://github.com/exasol/etl-utils

Compatibility Test Suite

This compatibility test suite contains test datasets and sample SQL statements that you can use as a standard against which you can test database clients: ETL tools, connectors, SQL clients.

https://github.com/exasol/compatibility-test-suite/releases

AWS Cost Reporting

Collection of Exasol scripts to record and analyze the costs produced by an AWS account.

https://github.com/exasol/aws-cost-reporting

Websockets API

The JSON over WebSockets client-server protocol allows customers to implement their own drivers for all kinds of platforms using a connection-based web protocol.

https://github.com/exasol/websocket-api

BucketFS Explorer

The BucketFS explorer is a tiny GUI written in Java/JavaFX that helps you working with BucketFS.

bucketfsexplorer-0.0.1-SNAPSHOT-jar-with-dependencies.jar