MySQL on Amazon RDS Data Asset Properties
Complete the following properties and connection details to create a data asset that connects to a MySQL on Amazon RDS source.
Create a data asset has generic instructions, if you need them.
| 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 or schema. The database or schema must be within this MySQL instance. |
| 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. Enter the OCID of the secret for the password in the Vault secret OCID for database password field. |
| 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. |