Oracle Cloud Infrastructure Documentation

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 specify. You can change the identifier value, but after you create and save the data asset, you cannot update the identifier.
Description

Add a description. This field is optional.
Type Displays the data asset type based on the icon you select in the Select data asset type panel. For more information, see Creating a Data Asset.
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 the 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 is 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:

  1. Select Upload wallet or Use vault secret OCID, depending on whether you want to upload the wallet or use secrets in Oracle Cloud Infrastructure Vault to retrieve the wallet and wallet password.
  2. For Upload wallet: Under Wallet file, drag your wallet file to the Drop file space, or click Select file to browse and then select the wallet to upload. Then enter the Wallet password.
  3. For Use vault secret OCID: Enter the OCID of the secret for the wallet, and then enter the OCID of the secret for the wallet password.
Default connection information
Name

Enter a name for the default connection.
Identifier

The identifier is a system-generated value based on the name you specify. You can change the identifier value, but after you create and save the connection, 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, you can click Test connection to ensure you have entered the data asset details correctly.

A success or failure message displays, indicating whether the test was successful or not. If the test fails, review your connection settings and try again.