Search

SingleStore

Version 25.3.9396

SingleStore

You can use the SingleStore connector from the CData Sync application to capture data from SingleStore and move it to any supported destination. To do so, you need to add the connector, authenticate to the connector, and complete your connection.

Add the SingleStore Connector

To enable Sync to use data from SingleStore, you first must add the connector, as follows:

  1. Open the Connections page of the Sync dashboard.

  2. Click Add Connection to open the Select Connectors page.

  3. Click the Sources tab and locate the SingleStore row.

  4. Click the Configure Connection icon at the end of that row to open the New Connection page. If the Configure Connection icon is not available, click the Download Connector icon to install the SingleStore connector. For more information about installing new connectors, see Connections.

Authenticate to SingleStore

After you add the connector, you need to set the required properties.

  • Connection Name - Enter a connection name of your choice.

  • Server - Enter the host name or the IP address of the server that hosts the SingleStore database.

  • Port - Enter the port for the SingleStore database. The default port value is 3306.

CData Sync supports authenticating to SingleStore in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

Password

To connect with your user credentials, set the following properties:

  • Auth Scheme: Select Password.

  • User: Enter the username that you use to authenticate to your SingleStore account.

  • Password: Enter the password that you use to authenticate to your SingleStore account.

NTLM

To connect with NTLM user credentials, specify the following properties:

  • Auth Scheme: Select NTLM.

  • User: Enter the username that you use to authenticate to your SingleStore server.

  • Password: Enter the password that you use to authenticate to your SingleStore server.

  • Domain - Enter the domain name for a Microsoft Windows (NTLM) security login.

  • NTLM Version - Select your NTLM version. The default version is 1.

Complete Your Connection

To complete your connection:

  1. Specify the following properties:

    • Database (optional) - Enter the name of the default database that you want to use when you connect to the SingleStore server.

    • Use SSL - Specify whether you want to use the Secure Sockets Layer (SSL) protocol. The default option is False.

  2. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)

  3. Click Create & Test to create your connection.

More Information

For more information about interactions between CData Sync and SingleStore, see SingleStore Connector for CData Sync.