Oracle Cloud Infrastructure Documentation

Oracle Siebel Data Asset Properties

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 Siebel 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 specify. You can change the identifier value, but after you create and save the data asset, you can't 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 checkbox 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

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.
RAC support

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

If you selected Wallet for the Connection type, do the following:

  1. Select Use vault secret OCID or Upload wallet, 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 Use vault secret OCID: Enter the OCID of the secret for the wallet. Optionally, enter the OCID of the secret for the wallet password.
  3. For Upload wallet: Under Wallet file, drag the wallet file to the Drop a file space, or click Select a file to browse and select the wallet to upload. Optionally, enter 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 can change the identifier value, but after you create and save, you cannot update the identifier.
Description (Optional) Add a description.
Username and Password

If you selected the Basic connection type and Use password, enter the user name and password.
Username and Vault secret OCID for database password

When either one of the following conditions is met, enter the user name and the vault secret OCID for the database password:

  • If you selected the Basic connection type and Use vault secret OCID
  • If you selected the Wallet connection type

The OCID, from OCI Vault, is the OCID of the secret for the database password that's 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 the connection settings and try again.