MySQL Connections
Use the connection to connect to and access tables from a MySQL database.
This topic contains the following sections:
Supported Features
|
Feature |
Additional Information |
|---|---|
|
Replication Flows |
You can use the connection to add source objects to a replication flow (see Select Source and Target Connections for Replication Flows). For more information, see MySQL Sources for Replication Flows. |
Prerequisites
Before you can use the connection for replication flows, the following is required:
-
Supported source versions: MySQL 8.4.x
-
If your MySQL server is an on-premise server in your local network, Cloud Connector is required for the connection between MySQL and SAP Datasphere.
When configuring Cloud Connector, ensure you create the system mapping with the following settings:-
Back-end Type: Non-SAP System
-
Protocol: TCP
-
Internal Host: host on which the MySQL database is running to which you want to connect
-
Port or Port Range: port for the endpoint
-
Virtual Host: should be the same as the internal host
-
Virtual Port: should be the same as the internal port
-
Check Internal Host: deselected
For more information, see Configure Cloud Connector.
-
-
A user with an administrator role has uploaded the TLS server certificate. This is required regardless of the authentication type selected in the connection.
For more information, see:-
Using Encrypted Connections
in the MySQL 8.4 Reference Manual
For more information, see Manage Certificates.
-
For information about assigning privileges and roles to a MySQL user, see GRANT Statement
in the MySQL 8.4 Reference Manual.
Configuring Connection Properties
Connection Details
|
Property |
Description |
|---|---|
|
Hostname |
Enter the name of the host on which the MySQL database is running. |
|
Port |
Enter the database server port number. |
|
Database |
Enter the name of the MySQL database to which you want to connect to. |
|
Validate Hostname in Certificate |
[optional] To secure your connection, TLS is enabled by default. You can choose to verify that the hostname you are connecting to matches the hostname listed in the server's certificate. The default is false. |
Cloud Connector
|
Property |
Description |
|---|---|
|
Use Cloud Connector |
[optional] Set to true if your source is an on-premise source and you want to use the connection for replication flows. The default is false. |
|
[if Use Cloud Connector = true] Location |
[optional] Select a location ID. |
|
Virtual Host |
Enter the virtual host that you defined during Cloud Connector configuration. |
|
Virtual Port |
Enter the virtual port that you defined during Cloud Connector configuration. |
Authentication
|
Property |
Description |
|---|---|
|
Authentication Type |
Select the authentication type to use to connect to the MySQL database.
Choose from the following:
|
X.509 Client Certificate
If Authentication Type = X.509 Client Certificate:
|
Property |
Description |
|---|---|
|
User Name |
Enter the user name identifying the MySQL account. |
|
Password |
[optional] Enter the password for the user name. |
|
Certificate |
To upload the certificate or certificate chain that is used to authenticate to the remote system, click and select the file. |
|
Private Key |
To upload the private key, click and select the file. |
|
Private Key Password |
[optional] If the private key is encrypted, enter the password required for decryption. |
User Name And Password
If Authentication Type = User Name And Password:
|
Property |
Description |
|---|---|
|
User Name |
Enter the user name identifying the MySQL account. |
|
Password |
Enter the password. |
Features
|
Feature |
Description |
|---|---|
|
Replication Flows |
Replication Flows are enabled without the need to set any additional connection properties. If your source is an on-premise source, make sure you have maintained the properties in the Cloud Connector section. |