Skip to main content

SingleStoreDB v8.0

Connect with Dremio

Dremio is an open source project that enables business analysts and data scientists to explore and analyze any data at any time, regardless of its location, size, or structure. Dremio combines a scale-out architecture with columnar execution and acceleration to achieve interactive performance on any data volume. You can connect Dremio to SingleStoreDB using the SingleStore connector for Dremio.

The following certification matrix shows the recommended version of Dremio:

Certification Matrix

Versions

Dremio

17.0.0+

Prerequisites

Before connecting Dremio to SingleStoreDB, perform the following tasks:

  1. Download and install Dremio.

  2. Download and install the latest version of The SingleStore JDBC Driver

  3. Make sure the SingleStoreDB cluster is running on the server.

  4. Download the SingleStore connector for Dremio.

Configure JARS and Run Dremio

Log in to a linux machine, and perform the following tasks:

  1. Download the .jar plugin from GitHub, and place this .jar plugin in the $DREMIO_HOME/jars directory in Dremio.

  2. Download The SingleStore JDBC Driver.jar file from GitHub, and place this .jar file in the $DREMIO_HOME/jars/3rdparty directory.

  3. Start (or restart) the dremio service:

    sudo /opt/dremio/bin/dremio start

  4. Open a browser, and connect to Dremio running on the linux server:

    http://<IP_address_of_the_server_running_the_Dremio_service>:9047/

Connect Dremio to SingleStoreDB

  1. Open a the following URL in a browser to connect to Dremio running on the linux server:

    http://<IP_address_of_the_server_running_the_Dremio_service>:9047/

  2. On the Welcome to Dremio screen, enter the Username and Password to log into Dremio.

  3. On the left navigation pane, select Sources > Add Source.

  4. On the Add Data Source dialog, from the list, select SingleStore.

  5. In the New SingleStore Source window, enter the following information:

    • Name: Name of the connection.

    • Host: IP address or hostname of the SingleStoreDB cluster.

    • Database: Name of the database to connect with.

    • Port: Default is 3306.

    • Username and Password: Username and password of the database user.

  6. Select Save.

Your new SingleStoreDB connection is now available and ready to use.

In this section: