| D toc |
|---|
| Excerpt |
|---|
You can create connections to one or |
...
more
|
...
from
|
If you are connecting
| D s product |
|---|
| D s item | ||
|---|---|---|
|
...
- Read: Supported
- Write: Supported
Configure
To create this connection:
...
| Property | Description | ||
|---|---|---|---|
| Host | Enter your fully qualified hostname. Example:
| ||
| Port | Set this value to 3306. | ||
| Connect String Options | Insert any additional connection parameters, if needed. See below. | ||
| User Name | Username to use to connect to the database. | ||
| Password | Password associated with the above username. | ||
| Test Connection | After you have defined the connection credentials type, credentials, and connection string, you can validate those credentials. | ||
| Default Column Data Type Inference | Set to | ||
| Connection Name | Display name of the connection | ||
| Connection Description | Description of the connection, which appears in the application. |
...
Connection URL
The properties that you provide are inserted into the following URL, which connects
| D s product |
|---|
...
Driver name:
com.mysql.cj.jdbc.Driver- Driver version:
8.0 - Driver documentation: https://dev.mysql.com/doc/connector-j/8.0/en/
Create via API
This connection can also be created using the API.
- Type:
jdbc - Vendor:
mysql
For more information, see
| D s api refdoclink |
|---|
#operation/createConnection |
Troubleshooting
| Error message | Description | ||
|---|---|---|---|
| 1042 - ER_BAD_HOST_ERROR | Unable to connect to host. Please verify the host and port values. | ||
| 1045 - ER_ACCESS_DENIED_ERROR | Credentials failed to connect. Please verify your credentials.
| ||
Set the following option in the connect string options:
|
...
