Configuration Reference Home
Oracle Unified Directory - RDBMS Table

RDBMS Table

An RDBMS Table contains information about an RDBMS Table. The table may be referenced by several attribute mappings of the same workflow element.

Relations To this Component

The following components have a direct COMPOSITION relation TO RDBMS Tables :

Properties

A description of each property follows.


Basic Properties: Advanced Properties:
↓ cascade-delete-on-relation ↓ db-schema-name
↓ db-table-name ↓ db-sequence-name
↓ join-rule ↓ primary-key-storability
↓ join-type
↓ outer-join-required
↓ primary-key-field

Basic Properties

cascade-delete-on-relation

Description
whether deletes should be cascaded or not
Default Value
false
Allowed Values
true
false
Multi-valued
No
Required
No
Admin Action Required
None
Advanced Property
No
Read-only
No

db-table-name

Description
Name of the RDBMS Table
Default Value
None
Allowed Values
A String
Multi-valued
No
Required
Yes
Admin Action Required
None
Advanced Property
No
Read-only
No

join-rule

Description
join rules
Default Value
No join rules would be defined
Allowed Values
A String
Multi-valued
No
Required
No
Admin Action Required
None
Advanced Property
No
Read-only
No

join-type

Description
Type of join between this table and the table implied by the join condition
Default Value
No Join Type will be configured
Allowed Values
many-to-one -

one-to-many -

one-to-one -


Multi-valued
No
Required
No
Admin Action Required
None
Advanced Property
No
Read-only
No

outer-join-required

Description
whether we should do an outer join or not
Default Value
true
Allowed Values
true
false
Multi-valued
No
Required
No
Admin Action Required
None
Advanced Property
No
Read-only
No

primary-key-field

Description
primary key field
Default Value
None
Allowed Values
A String
Multi-valued
Yes
Required
Yes
Admin Action Required
None
Advanced Property
No
Read-only
No


Advanced Properties

db-schema-name

Description
Name of the RDBMS Schema
Default Value
Default db-schema is current user schema. This property need to be configured when we want to access table from different schema.
Allowed Values
A String
Multi-valued
No
Required
No
Admin Action Required
None
Advanced Property
Yes
Read-only
No

db-sequence-name

Description
This configuration parameter specifies the database sequence to generate primary key field value in case if the database does not support identity.
Default Value
None
Allowed Values
A String
Multi-valued
No
Required
No
Admin Action Required
None
Advanced Property
Yes
Read-only
No

primary-key-storability

Description
This configuration parameter decides whether the Primary Key of this table can contain user provided values. If set to "True", values can be inserted into this column by end-users. In case of auto-generated Primary Keys, set this parameter to "false"
Default Value
true
Allowed Values
true
false
Multi-valued
No
Required
Yes
Admin Action Required
None
Advanced Property
Yes
Read-only
No


Copyright © 2017, 2020, Oracle and/or its affiliates. All rights reserved.