Connect with Dremio

Prerequisites

Before connecting Dremio to SingleStore, 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 SingleStore 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:

   Shell

   Copy

   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 SingleStore

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 SingleStore 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 SingleStore connection is now available and ready to use.