Oracle Peoplesoft Data Asset Properties

Enter a name for the data asset.

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 can't update the identifier.

Add a description. This field is optional.

Select Basic or Wallet, depending on whether you want to provide an Oracle Wallet file.

Enter the IP address of the host.

Enter the port number to use.

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.

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.

Retain NUMERIC data type for NUMBER columns without precision. This check box is selected to retain numbers without precision as numeric data type when creating new target entity.

For example, if source has a numeric data type without a precision value and if this check box isn't selected, then such numeric fields are converted as string in target system instead of the numeric data type.

By default, when the Treat NUMBER columns without precision and scale as VARCHAR check box is selected, this check box is also enabled for Fusion and Oracle Data Assets.

The primary purpose of this check box is to facilitate the generation of target columns with numeric data types, specifically designed for forward engineering use cases which have unconstrained numeric columns in source.

The actual creation of target columns depends on how the underlying databases handle the creation of columns without scale and precision.

Select the check box if you want RAC (Oracle Real Application Clusters) support.

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.

Enter a name for the default connection.

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.

Add a description. This field is optional.

If you selected Upload wallet, enter the user name and 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.

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.