Guides
Visit our websiteDeveloper Docs
  • Getting Started with Databrain
    • What is Databrain?
  • ❄️Onboarding & Configuration
    • 📝Sign-Up
    • ✍️Sign-In
    • ✏️Google Sign In Setup for Self-hosted app
    • 🤔Forgot password? Recover your Databrain Account
    • 🌟Onboarding
    • 💾Add a Data Source
    • 🧑Configure Tenants
    • 🆕Create a Workspace
    • 🔓Create a Private Workspace
    • 🆕Create a Dashboard
    • 💠Create a Metric
      • Create Custom Columns
      • Create a Metric using Chat Mode
      • Create a Metric using Custom SQL
    • Workspace Settings
      • General Settings
      • Access Control Settings
      • Cache Settings
      • Download Settings
    • 🗄️Explore Data
  • 🛢️Datasources
    • Connecting Data Sources to Databrain
      • Amazon Redshift
      • Snowflake
      • BigQuery
      • MySQL
      • Postgres
      • MongoDB
      • ElasticSearch
      • DataBricks
      • ClickHouse
      • MSSQL
      • Amazon S3
      • CSV
      • Firebolt
      • SingleStore
      • Athena
    • Allow Access to our IP
    • Add a Data Source
    • Configure Tenants
    • How to Sync a Data Source
    • Edit Tenancy
    • Create a Datamart
    • Semantic Layer
    • Create a Data App
    • Creating a Custom Dataset/View in a Multi-Datasource Environment
  • Workspace
    • Multi Datasource Workspace
  • 🔍DASHBOARDS
    • Edit a Dashboard
    • Share Dashboard
    • Dashboard Settings
    • Create/Modify Dashboard Filter
      • Dashboard Filter - Variable Apply On
      • Add LHS and RHS custom sql support for dashboard filter
    • Customize Layout
    • Adding Elements to Dashboard
    • Import/Export Dashboard
    • Report Scheduler
  • 📉METRIC
    • Edit a Metric
    • Joins , Filter, Sort, Group By
    • Complex Filter
    • Apply Metric Filter
      • Metric Filter - Variable
      • Metric Filter - Custom
    • Switch X axis and Switch Y axis
    • Group By
    • Footnote and Long Description
    • Dynamic Property
    • Archive/Unarchive Metric Card
    • Download Metric Card
    • Download Underlying Data
    • Metric Summary
    • Metric Expression for Single Value Card
    • AI Summary
    • Merge Metrics
    • Section Filters
    • View Unpublished Metrics
  • 📊VISUALIZATIONS - ACTIONS & APPEARANCE
    • Chart Actions
      • Chart Click Action
      • Chart Click Action with Metric
      • Card Click Action
      • Drill Down
      • Cross Dashboard Drill Down
    • Chart Appearance
      • Chart-Specific Appearance Options
  • 🛢️PREVIEW OF DASHBOARDS
    • Email Settings for Scheduled Reports
    • Scheduled Reports for End User
  • 🔍FILTERS
    • Dashboard Filter
    • Metric Filter
    • App filter
  • 💡Features
    • Python Editor Console
    • Custom SQL Console
    • Custom SQL Query Guidelines
  • 🏢Integrating Plugin
    • ✳️Get an auth token
    • 🙏Get a guest token
  • 🛃THEMEING & CUSTOMIZATION
    • 🎨Creating a theme
    • 🖼️View the theme in action
    • ⚙️Reset a saved theme
  • 📊Metric Component (upto version v0.11.15)
    • ✨Quick start
  • 🕸️Web Components
    • ✨Quick start
    • ⚛️Framework Specific Guide
  • 🚀Product Changelog
  • 🤳Self Hosted Changelog
Powered by GitBook
On this page
  • Requirements
  • Prerequisites
  • Locating the Configuration Details in SingleStore
  • Steps to Connect SingleStore to Databrain
  1. Datasources
  2. Connecting Data Sources to Databrain

SingleStore

This guide will walk you through the steps to connect your SingleStore database to Databrain.

PreviousFireboltNextAthena

Last updated 20 hours ago

Requirements

  • Activate SingleStore account.

  • Allow connections from Databrain to your SingleStore account.

    • For details on setting up IP whitelisting and ensuring secure connectivity, refer to our guide on

  • Choose the Databrain Workspace to which you wish to connect the data.

Prerequisites

Before you begin, ensure you have the following information:

  • SingleStore Host (your account locator)

  • Port (default: 3333)

  • Username (e.g., your-email@domain.com)

  • Password (associated with the username)

  • Database Name (the target database for synchronization)

Locating the Configuration Details in SingleStore

To connect SingleStore to Databrain, you need specific details from your SingleStore instance. Follow these steps to locate them:

  1. Log in to SingleStore

    • Open your SingleStore workspace.

    • Navigate to the Admin Portal.

  2. Find Your Account Locator

    • In the SingleStore portal, go to Deployments.

    • Select your database instance.

    • The Account Locator (Host) will be displayed in the connection details.

  3. Retrieve Connection Credentials

    • Go to Access Control and find your database user.

    • Ensure you have the correct username and password for authentication.

  4. Check the Database Name

    • Open the Databases tab in the SingleStore Admin Portal.

    • Identify the name of the database you want to sync with Databrain.

Steps to Connect SingleStore to Databrain

  1. Navigate to SingleStore Configuration

    • Log in to Databrain.

    • Go to Data Sources and click Add Data Source.

    • Select SingleStore from the list of available connections.

  2. Enter Connection Details

    • Name: Enter a name to help you identify the connection (e.g., SingleStore).

    • Host: Provide your SingleStore account locator.

    • Port: Enter 3333 (or the port assigned to your instance).

    • Username: Enter the email address or username associated with your SingleStore account.

    • Password: Enter the password for authentication.

    • Database: Specify the name of the database you want to sync data into.

  3. Authenticate and Connect

    • Click Authenticate to validate the credentials.

  4. Complete the Setup

    • Once connected, you can proceed to configure data sync settings.

    • Define tenancy level: database or table

🛢️
Allow Access to our IP