Properties to configure to connect to a SingleStore DB table.
Warning: Bulk loading with SingleStore
is not supported yet.
|
Property |
Configuration |
|
|---|---|---|
| Selection | Select or enter SingleStore. | |
| Configuration | ||
| Engine | Select your engine in the list. | |
| Main | 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. Note: 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. Example of expected format if you connect with MariaDB: jdbc:mariadb://<host>[:<port>]/<database_name> Note: 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 user name used to connect to the database. | |
| Password | Enter the password used to connect to the database. | |
| Advanced | 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. | |
| Description | Enter a display name (mandatory) and a description (optional) for the connection. | |
Additional JDBC parameters might be displayed depending on whether the connector is used as a source or destination dataset, read this section to know more about these parameters.