SingleStore Connection

See the Connector Marketplace topic. Please request your administrator to start a trial or subscribe to the Premium SingleStore connector.

SingleStore, as a modern database platform, aligns with the values of speed and simplicity in data management.

This topic describes how to authenticate to SingleStore and configure any necessary connection properties in the SingleStore connection connector.

Connection Configuration #

Each connection property available in the SingleStore connector is explained below.

Connection Name #

The name of the connection to be created should be provided. This is the name that will display on the list of available connections.

Server #

The host name or IP of the server hosting the SingleStore database.

Port #

The port of the server hosting the SingleStore database.

Database #

The name of the SingleStore database.

The default database to connect to when connecting to the SingleStore Server. If this is not set, tables from all databases will be returned.

User #

The SingleStore user account used to authenticate.

Password #

The password used to authenticate the user.

Azure Tenant #

The Microsoft Online tenant being used to access data. If not specified, your default tenant is used.

Client ID #

The client Id assigned when you register your application with an OAuth authorization server.

Client Secret #

The client secret assigned when you register your application with an OAuth authorization server.

Access Token #

The access token for connecting using OAuth.

Enable SSL #

Option for creating the connection with SSL enabled.

Upload Keystore File #

Option to upload keystore file.

Advanced Configuration #

This section contains advanced configuration parameters.

Characterset #

The default client character set used by the provider. For example, ‘utf8’.

This can be useful if you need to use a specific encoding or collation in your queries.

Add Configuration: Additional properties can be added using this option as key-value pairs.

After entering all the details, click on the TEST button.

If the connection service identification and authentication details are provided correctly, a success message stating “connection available” is generated.

Click on the CREATE button to save the changes.

If the details are incorrect or the server is down, you will get a message “Connection unavailable”.