​
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

Allow Access to our IP

Allow Access to our IP
  • 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