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:
Download and install Dremio.
Download and install the latest version of The SingleStore JDBC Driver.
Make sure the SingleStoreDB cluster is running on the server.
Download the SingleStore connector for Dremio.
Configure JARS and Run Dremio
Log in to a linux machine, and perform the following tasks:
Download the
.jar
plugin from GitHub, and place this.jar
plugin in the $DREMIO_HOME/jars directory in Dremio.Download The SingleStore JDBC Driver
.jar
file from GitHub, and place this.jar
file in the $DREMIO_HOME/jars/3rdparty directory.Start (or restart) the
dremio
service:sudo /opt/dremio/bin/dremio start
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
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/
On the Welcome to Dremio screen, enter the Username and Password to log into Dremio.
On the left navigation pane, select Sources > Add Source.
On the Add Data Source dialog, from the list, select SingleStore.
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.
Select Save.
Your new SingleStoreDB connection is now available and ready to use.