SingleStore

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

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

• 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., [e-mail])

• 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