Unlock Your Analytics Faster with Exasol Database

Exasol is a high-performance, in-memory analytics database. It allows you to connect with various SQL clients, BI, data integration and ETL, data warehousing, and many other tools using the Exasol drivers and programming languages.

The loading performance of dashboards is dependent not only on the visual rendering, but also the database querying performance. This analytics database can make your data visualization an excellent user experience through fast load times.

The prerequisites for connecting the Exasol database using Bold BI to create an interactive dashboard are as follows:

Once you select ODBC connector, the ODBC connection window will open in panel.

In the connection window, provide a unique name for your ODBC data source.

Your Exasol data sources are listed in the Dsn name drop-down. Select your data source from the drop-down. Enter the username and password for your Exasol database.

If you want to fetch a specific database, then provide the database name in the Database field. Otherwise, you can leave it empty. Ignore the Command Timeout and Additional connection parameters fields.

Click Connect. Consequently, the Exasol schema is listed in a tree view on the left side of the editing window. Drag and drop the table you want to analyze and save the data source.

Finally, the created data sources will be added to the DATA SOURCES panel. Now, the data source is ready to be configured with dashboard widgets. So, you can analyze gigabytes of data in a few seconds. Add required widgets to the blank dashboard that you created in the beginning and configure the widgets in the dashboard.

Let’s visualize Chicago taxi service performance and retail industry revenue performance metrics with analytics data from Exasol using Bold BI dashboards through the ODBC data connection.

Refer to the below the Chicago taxi service performance dashboard.

This dashboard focuses on monitoring Chicago taxi service performance through the following metrics:

Here is another dashboard showcasing the revenue performance of a retail company.

The following metrics are enough to track the revenue performance of a retail company:

Rendering 1.29 billion of records (158 GB) of Exasol data in a Bold BI dashboard takes approximately just eight seconds. It used to take more than a minute with other common database providers.

Related posts:

The way it demands to be heard in a room. “have you everheard a more beautiful word than her name?” is published by Sophia Reisman.

Python adalah Bahasa pemrograman interpreter yang dapat berjalan diberbagai platform sistem operasi dan juga dapat digunakan untuk membuat aplikasi berbasis desktop ataupun web. Python diklaim…

See life as moments. Good habits give us stability but what touches our heart, what makes us feel alive are moments in time. The hard one that change us forever and the beautiful ones that mend our…