MySQL HeatWave Data Asset Properties
You can use a secret for the password.
See OCI Vault Secrets and Oracle Wallets.
To create a data asset that connects to a MySQL HeatWave source, complete the following properties and connection details.
Field | Description |
---|---|
Properties | |
Name | Enter a name for the data asset. |
Identifier | The identifier is a system-generated value based on the name. You can change the identifier value, but after you create and save, you cannot update the identifier. |
Description | (Optional) Add a description. |
Type | The field shows the data source type that you selected in the Select data asset type panel (as described in Creating a Data Asset). Data Integration displays the data asset property fields and default connection fields based on this type. |
Host |
Enter the IP address of the host. |
Port |
Enter the port number to use. |
Database |
Enter the database name. The database or schema must be within this MySQL HeatWave instance. |
Enable SSL |
Select the Enable SSL checkbox if you want SSL-based authentication. |
Default connection information | |
Name | Enter a name for the default connection. |
Identifier | The identifier is a system-generated value based on the name. You can change the identifier value, but after you create and save, you cannot update the identifier. |
Description | (Optional) Add a description. |
Username |
Enter the user name. |
Use vault secret OCID | If you use a secret in Oracle Cloud Infrastructure Vault to store the password, select this option. The following field appears:
|
Use password |
If you select this option, enter the password in the Password field. |
(Optional) Test connection | |
Test connection | After you complete all the required fields, click Test connection to ensure that the data asset details have been entered correctly and the connection can be established. A success message appears if the test is successful. If the test fails with an error message, review the connection settings and try again. |