Sign inTry Free

Connect with Denodo

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

On this page

Denodo is a data virtualization platform that allows you to integrate your SingleStore 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 SingleStore 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 SingleStore

Configure the SingleStore JDBC driver as a database adapter in Denodo:

  1. On the Denodo dashboard, select File > Extensions management.

  2. On the Extension management dialog, on the Libraries tab, from the Type list, select JDBC Drivers.

  3. On the Import resources dialog, from the Resource type list, select jdbc_other.

  4. 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.

  5. Select + Add. Add the .jar file downloaded earlier to the Load File dialog.

  6. Select Save. The SingleStore JDBC driver is now configured as an adapter in Denodo.

Add your SingleStore database as a JDBC data source:

  1. Right-click on a database in the Server Explorer, and select New > Data Source > JDBC.

  2. On the Configuration tab on the dialog that opens, enter or select the configuration options for your SingleStore 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.

  3. Select Test connection to test connectivity to your database. Select Save.

You can now use Denodo to explore your SingleStore databases.

References

Last modified: April 12, 2023

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK