Creating an OCI HeatWave connection

Create an OCI HeatWave connection by performing the following steps:

1. Log in into the OCI Console with your user credentials and the necessary policies to be able to create database connections.
2. Open the navigation menu. Under Database Migrations click Database Connections.
3. Click Create Connection.
4. On the General information step, in the Name field, enter a display name for the database connection resource.

   This is not the actual database name, but a name that will appear in a list of databases connections on completion of this procedure.

5. Add Description for the database connection resource.
6. In Compartment select the compartment in which the Database Connection resource will be created.
7. In Type, select a connection type. Select the connection type as OCI HeatWave.
8. In Vault in Compartment select the security vault.

   Database Migration Service uses the OCI Vault service to store your secrets such as passwords, wallets, and keys, and encrypts them with the encryption key that you provide. All of these are always stored in your tenancy and are in your full control.

   You can select a vault in a different compartment by clicking Change Compartment.

9. In Encryption Key in Compartment select the keystore that you configured in the vault.

   Only AES algorithm type keys are supported.

10. The Advanced Options section allows you to optionally create tags.
11. In the Connection details step, enter the connection details for the OCI HeatWave. Select one of the following options:
    • Select MySQL database system: Provide the following information:
      • Database System in Compartment: Select an OCI database.

      • Database name: The database name

        Enter the database administrator credentials in Initial load database username and Initial load database password.

    • Enter MySQL database information: Provide the following information:
      • Database name: The database name
      • Host: listener host IP address
      • Port: listener port number

      • Enter the database administrator credentials in Initial load database username and Initial load database password.

12. Select Use different credentials for replication to enter the credentials for replication. Select this option if you want to use a separate database user for performing replication for your online migrations. The following options are available
    • Replication database username
    • Replication database password
13. In the SSL details, select the security protocol.
    • Plain
    • TLS, and then select the SSL mode
    • MTLS, then select the SSL mode. Upload the Client certificate and Client private key.
14. In Network Connectivity details, Create private endpoint to access this database indicates whether the database is publicly accessible or if you want to create a private endpoint.

    By default, this option is selected while creating an OCI HeatWave connection. You must connect your database over a private IP address.

    In Subnet in Compartment, select the subnet to which a private endpoint is created from the Oracle Cloud Infrastructure Database Migration service tenancy. This creates a network route for the Oracle Cloud Infrastructure Database Migration service to connect to the database within your tenancy. Select the subnet containing the appropriate Virtual Cloud Network (VCN).Click Change Compartment to select a subnet in a different compartment.
15. (Optional) Under Advanced Options, add Connection attributes. Click + Another attribute to add more.
16. Click Create.

Note:

After you click Create, the database connection name appears in the Connection list while the creating connection operation runs. The creating connection operation can take a few minutes.

You can monitor the operation status in the State column. When the state is Active, the database connection creation is complete and successful.