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:

    For more information, see Manage Certificates.

  • For information about assigning privileges and roles to a MySQL user, see GRANT StatementInformation published on non-SAP site 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 [default]

  • User Name And Password for basic authentication

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 (Browse) and select the file.

Private Key

To upload the private key, click (Browse) 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.