Below are a list of how to connect to the DataEco Platform and the Exasol Database using Business Intelligence Tools.

You will have to download the correct JDBC or ODBC drivers from the Exasol site as per this connection Link

Looker

Looker is a business intelligence software and big data analytics platform that helps you explore, analyze, and share real-time business analytics easily. Looker is a web-based application and connects to Exasol using JDBC.

Prerequisite

Ensure right permissions are provided to users to access Exasol. For more information, refer to Exasolsection in the Looker documentation.
Exasol database running.

Connect Looker to Exasol

Follow these steps to create a connection to Exasol on Looker:

1. Open Looker in your browser using the Looker URL for your organization and login with your credentials. The Looker landing page is displayed, as shown below.

1. From the top panel, click Admin and under Database, select Connections.

1. In the Connections screen, click New Connection to add a new connection.

At the top of the New Connection screen, you have two options to configure the connection. Select the option Existing Database to configure a Looker connection to a current database or select the option New Database to create, connect, and download your data into a new Looker database. In this guide, we have chosen the option Existing Database.
Enter the connection details for the following fields in the New Connection screen:
- - Name: Name to identify the connection.
  - Dialect: Choose Exasol from the drop-down list.
  - Host:Port: The database hostname and port number that Looker should use to connect to your database.
  - Database: Your Exasol database name.
  - Username: Enter the user name to connect to the database.
  - Password: Enter the password to connect to the database.
  - Schema: The default schema Looker must use.
  - Persistent Derived Tables: Select this checkbox to enable persistent derived tables. This reveals the Temp Database, which is a dedicated schema in the database to store persistent derived tables.
  - Temp Database: Schema name Looker must use to create persistent derived tables (for example, LOOKER_SCRATCH).
  - Additional Params: You can include additional Java Database Connectivity (JDBC) parameters for your queries here if needed.
  - PDT and Datagroup Maintenance Schedule: You can provide a Cron expression that indicates Looker on how often should a check for datagroups and Persistent Derived Tables be regenerated or dropped. The default value is */5****, which means ‘check every 5 minutes’, and this is the maximum frequency of checks.
  - SSL: Choose whether or not you want to use SSL encryption to protect data.
  - Max Connections: Set the maximum number of connections that Looker can establish with your database.
  - Connection Pool Timeout: Enter the maximum amount of time a request will wait before the connection times out.
  - SQL Runner Precache: Select the checkbox to pre-cache table. This allows all table information to be pre-loaded as soon as you select a connection and schema, and faster display of table columns when you click on a table name.
Click Test These Settings to test the connection to Exasol.
Click Add Connection to save the connection.

View Connection

Once you have configured the Looker connection, you can view the connection on the Connections screen as shown below:

Once you have configured the connection to Exasol, you can next create dashboards and reports. For more information on how to create dashboards, refer to Looker Documentation.

Microsoft Power BI Desktop

The Exasol Microsoft Power BI Connector enables you to connect from Power BI Desktop to Exasol in Direct Query mode. The classical import mode is supported as well.

The Exasol Microsoft Power BI Connector is a Certified Custom Connector and is now shipped with Power BI Desktop and the On-premises data gateway.

Prerequisite

You need to have the following:

Exasol ODBC driver (EXASOL_ODBC_*.msi) installed.
Latest version Power BI Desktop installed.

Connect Power BI Desktop to Exasol

Follow these steps to connect Power BI Desktop to an Exasol database.

1. Launch the Power Bi Desktop application, from the Home ribbon, select Get Data.

1. The Get Data window appears. From list of data sources under Database, select Exasol, then click Connect.
2. In the connection window, enter the Exasol connection string information for your Exasol database, and then select DirectQuery option. Click Ok.

1. Enter the user name and password for your database, and click Connect.

1. In the Navigator window, expand the database name to view the schemas. Expand the schema you want to use and select the desired tables for your analysis. Click Load.

1. Review the relational model. It is recommended to have foreign keys set in the database so Power BI can auto-detect the relations.

1. Build interactive dashboards on billions of rows in Exasol.

MicroStrategy Overview

MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Reporting. It can connect to data warehouses, relational systems, web services, and a host of other types of sources to pull data for analysis.

The MicroStrategy suite of products includes the following:

MicroStrategy Desktop: A desktop application that offers a graphical interface for creating visualizations and interactive dossiers. For more information, refer to MicroStrategy Desktop
MicroStrategy Intelligence Server: The Intelligence Server can be used for monitoring, reporting, and performing analysis on integrated platforms. For more information, refer to MicroStrategy Intelligence Server

Tableau is a fantastic BI reporting tool that has had a lot of adoption in the last ten years.

This guide shows how to set up the data connection to the ‘DataEco – Enterprise Service’ connection sent in the registration email.

The steps to connect Tableau to EXASOL are described in the solution: How to connect Tableau to an EXASOL database

Tableau

Exasol is easily integrated with Tableau and provides Tableau customers the power to visualize and analyze very large live data. Tableau has a native connector to Exasol which makes it easy for you to establish a connection.

This topic provides you with information on how to connect Tableau to Exasol. For this, you must make sure you have Exasol ODBC driver installed on your operating system.

For more information on creating content on tableau, refer to the training videos on Tableau.

Prerequisite

Exasol ODBC driver installed on your operating system. You can download the driver from the Exasol downloads section.
Both the Exasol database and the host with Tableau must be able to communicate with each other through a network.

Quick Start

This quick start video shows how to connect an Exasol database to Tableau.