Sign inTry Free

Connect with Sisense

On this page

You can connect Sisense to SingleStore.

Sisense supports two types of data models: ElastiCube Model and Live Model.

  • When you use the ElastiCube Model, you import data from data sources, and then merge, manipulate, and query the data. If the data in the data sources changes, you will need to refresh the data sources to see the changes.

  • When you use the Live Model, you work directly with data sources. You do not need to refresh the data sources if the data changes.

Prerequisites

Download and install Sisense. See Sisense Documentation for more information.

Connect Sisense to SingleStore using ElastiCube Model

  1. Open Sisense, and select the Data tab from the top menu.

  2. Select +ElastiCube. Specify a name for your new ElastiCube Model, and select Save.

  3. A screen appears that has a row labeled Data >> with the name of the ElastiCube Model you specified in the previous step. Select the +Data button on the right. Then, select the SingleStore icon from the available connectors.

  4. A screen appears where you specify your SingleStore connection details.

    For the Location, specify the IP address or hostname of your cluster. Then, specify the username and password used to connect to your cluster.

    Select Next.

  5. Select the database that you want to use. Then, select the tables or views in this database that you want to work with. Select Done.

Your SingleStore cluster is now configured and can be accessed from Sisense using ElastiCube Model.

Connect Sisense to SingleStore using Live Model

  1. Open Sisense, and select the Data tab from the top menu.

  2. Select +Live. Specify a name for your new Live Model, and select Save.

  3. A screen appears that has a row labeled Data >> with the name of the Live Model you specified in the previous step. Select the +Data button on the right. Then, select the SingleStore icon from the available connectors.

  4. A screen appears where you specify your SingleStore connection details.

    For the Location, specify the IP address or hostname of your cluster. Then, specify the username and password used to connect to your cluster.

    Select Next.

  5. Select the database that you want to use. Then, select the tables or views in this database that you want to work with. Select Done.

Your SingleStore cluster has now been configured and can be accessed from Sisense using Live Model.

Last modified: February 6, 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