Connect with Denodo
Denodo is a data virtualization platform that allows you to integrate your SingleStoreDB data in real-time into a unified view and perform analytics and BI operations. To connect with Denodo, you need to configure the SingleStore JDBC driver as a database adapter in Denodo. Subsequently, add your SingleStoreDB database as a JDBC data source using this adapter.
Prerequisites
Download the .jar
file for the latest version of the SingleStore JDBC driver.
Connect Denodo to SingleStoreDB
Configure the SingleStore JDBC driver as a database adapter in Denodo:
On the Denodo dashboard, select File > Extensions management.
On the Extension management dialog, on the Libraries tab, from the Type list, select JDBC Drivers.
On the Import resources dialog, from the Resource type list, select jdbc_other.
In the Custom version field, enter a name for the driver. For convenience, you can use the singlestore-jdbc-client-<version> format. For example, singlestore-jdbc-client-1.1.5. This name is visible in the dialog where you can configure JDBC data sources.
Select + Add. Add the .jar file downloaded earlier to the Load File dialog.
Select Save. The SingleStore JDBC driver is now configured as an adapter in Denodo.
Add your SingleStoreDB database as a JDBC data source:
Right-click on a database in the Server Explorer, and select New > Data Source > JDBC.
On the Configuration tab on the dialog that opens, enter or select the configuration options for your SingleStoreDB database and JDBC adapter.
Name: Name for the new data source. For example, SingleStore.
Database adapter: Select the name you provided for the driver. For example, singlestore-jdbc-client-1.1.5.
Database class:
com.singlestore.jdbc.Driver
.Database URI: Specify the connection string for your database in the
jdbc:singlestore://<host>:<port>/<database>
format. For example, jdbc:singlestore://svchost:3306/dbTest.Authentication: Specify the authentication method for your connection.
Select Test connection to test connectivity to your database. Select Save.
You can now use Denodo to explore your SingleStoreDB databases.