# SingleStore properties

Properties to configure to connect to a SingleStore DB table.

Information noteWarning: Bulk loading with SingleStore is not supported yet.

## SingleStore connection

Select SingleStore in the list and configure the connection.

## Configuration

Select your engine from the list and set the main and advanced settings.

Main settingsMain settings

| Property | Configuration |
| --- | --- |
| Connect with | Select the database you want to connect with SingleStore. SingleStore<br>supports most MySQL-compatible clients and libraries such as ODBC and JDBC<br>drivers from MariaDB and MySQL. For more information, read [the SingleStore<br>documentation](https://www.singlestore.com/faq/) |
| If Define JDBC URL is disabled | If this option is disabled, enter each parameter that identifies the<br>database to be used in the corresponding fields.<br><br>Click Load<br>default values in order to help you pre-fill the fields<br>with the default values associated with this type of database.<br><br>Information noteNote: Use the host name of the target system<br>instead of 'localhost' in the URL as the Remote Engine Gen2 needs to be able to communicate<br>with the target system. |
| If Define JDBC URL is enabled | If this option is enabled, enter the JDBC URL that identifies the<br>database to be used.<br><br>The expected format is the following:<br>jdbc:mariadb://&lt;host&gt;[:&lt;port&gt;]/&lt;database\_name&gt;<br><br>Information noteNote: Use the host name of the target system<br>instead of 'localhost' in the URL as the Remote Engine Gen2 needs to be able to communicate<br>with the target system. |
| User<br>name | Enter the username used to connect to the database. |
| Password | Enter the password used to connect to the database. |

Advanced settingsAdvanced settings

| Property | Configuration |
| --- | --- |
| Force protocol | If Define JDBC URL is disabled, you can enable<br>this option to define the JDBC driver protocol. |
| Connection timeout | Sets the<br>maximum number of seconds that a user will wait for a connection to be<br>available. If this time is exceeded and the connection is still unavailable, an<br>exception is thrown. |
| Connection validation timeout | Sets the<br>maximum waiting time in seconds for a connection to be considered as<br>alive. |

After configuring the connection, give it a display name (mandatory) and a description (optional).

Additional JDBC parameters might be displayed depending on whether the connector is used as a source or destination dataset, read [the JDBC parameters section](https://help.qlik.com/talend/r/en-US/Cloud/connectors-guide/jdbc) to know more about these parameters