SingleStore properties
Properties to configure to connect to a SingleStore DB table.
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.
| Property | Configuration |
|---|---|
| Connect with | Select the database you want to connect with SingleStore. SingleStore supports most MySQL-compatible clients and libraries such as ODBC and JDBC drivers from MariaDB and MySQL. For more information, read the SingleStore documentation |
| If Define JDBC URL is disabled | If this option is disabled, enter each parameter that identifies the
database to be used in the corresponding fields. Click Load default values in order to help you pre-fill the fields with the default values associated with this type of database. Information noteNote: Use the host name of the target system
instead of 'localhost' in the URL as the Remote Engine Gen2 needs to be able to communicate
with the target system.
|
| If Define JDBC URL is enabled | If this option is enabled, enter the JDBC URL that identifies the
database to be used. The expected format is the following: jdbc:mariadb://<host>[:<port>]/<database_name> Information noteNote: Use the host name of the target system
instead of 'localhost' in the URL as the Remote Engine Gen2 needs to be able to communicate
with the target system.
|
| User name | Enter the username used to connect to the database. |
| Password | Enter the password used to connect to the database. |
| Property | Configuration |
|---|---|
| Force protocol | If Define JDBC URL is disabled, you can enable this option to define the JDBC driver protocol. |
| Connection timeout | Sets the maximum number of seconds that a user will wait for a connection to be available. If this time is exceeded and the connection is still unavailable, an exception is thrown. |
| Connection validation timeout | Sets the maximum waiting time in seconds for a connection to be considered as 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 to know more about these parameters