Oracle Database on Amazon RDS Data Asset Properties
You can use a secret and wallet for the database password.
See OCI Vault Secrets and Oracle Wallets.
To create a data asset that connects to an Oracle Database source on Amazon RDS, 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 | Add a description. This field is optional. |
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. |
Connection type |
Select Basic or Wallet, depending on whether you want to provide an Oracle Wallet file. |
Host |
Enter the IP address of the host. |
Port |
Enter the port number to use. |
Database |
Select Service name or SID. Then provide the TNS alias to connect to your database remotely, or enter the unique name that identifies your database instance. |
Treat NUMBER columns without precision and scale as VARCHAR |
Select this check box to treat numbers without precision and scale as VARCHAR to prevent data loss. For example, if you have a numeric data type with a precision value that's greater than 38, or if you have numeric data types without precision and scale properties. |
Wallet information |
If you selected Wallet for the Connection type, do the following:
|
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 | Add a description. This field is optional. |
Username and Password |
If you selected Upload wallet, enter the user name and password. |
Username and Vault Secret OCID for database password |
If you selected Use vault secret OCID, enter the user name and then the OCID of the secret for the database password associated with the user. |
(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 your connection settings and try again. |