Synchronizes Oracle DDL to upgrade a schema to the supplied baseline.

Environment/Instance Properties

Property Name	Property Code	Required	Description
Oracle Database URL	`FDORA_URL`	Yes	The JDBC URL for the target Oracle database.
Oracle Database User	`FDORA_USER`	Yes	The username that will be used to connect to the target Oracle Database.
Oracle Database Password	`FDORA_PASSWORD`	Yes	The password for Oracle Database User.
Target JDBC Driver Path.	`FDORA_DRIVER_PATH`	Yes	Path containing JDBC driver for target database connection.
DDL Repo JDBC Driver Path	`FDORA_DDL_DRIVER_PATH`	Yes	Path containing JDBC driver for DDL repository database connection.
DDL Repository URL	`FDORA_DDL_URL`	Yes	The JDBC URL for the DDL repository.
DDL Repository User	`FDORA_DDL_USER`	Yes	The userid used to connect to the DDL repository.
DDL Repository Password	`FDORA_DDL_PASSWORD`	Yes	The password for the DDL repository userid.

Project Properties

Property Name

Property Code

Required

Description

Oracle Object Types

FDORA_OBJECT_TYPES

Yes

The Oracle object types which are being managed.

Select multiple from FUNCTION,INDEX,PACKAGE,PACKAGE BODY,PROCEDURE,SEQUENCE,SYNONYMN,TABLE,TRIGGER,TYPE,TYPE BODY,VIEW

Oracle Database Schema Name(s)

FDORA_SCHEMA_NAME

Yes

Comma-separated list of schemas controlled by this project.

Inputs

Input Name

Input Code

Required

Description

Column Drop Action

FDORA_COL_DROP_ACTION

No

Determines what action to take for "dropping" columns.

Can be set to SET UNUSED or DROP.

Defaults to SET UNUSED

Create Baseline

FDORA_CREATE_BASELINE_FLG

No

Whether to generate a baseline on the target environment and compare to new baseline.

Defaults to false

Preview Execution

FDORA_PREVIEW_EXECUTION

No

Whether to bypass actual execution of the DDL, and simply run the compare.

Defaults to false.

Outputs

Output Name	Required	Description
`FDORA_OUT_BASELINE_ID`	No
`FDORA_OUT_NEW_BASELINE_ID`	No
`FDORA_OUT_DELTA_BASELINE_ID`	No
`FDORA_OUT_DROP_TABLE_COUNT`	No
`FDORA_OUT_CREATE_TABLE_COUNT`	No
`FDORA_OUT_ALTER_TABLE_COUNT`	No
`FDORA_OUT_DROP_COLUMNS_COUNT`	No
`FDORA_OUT_ADD_COLUMNS_COUNT`	No
`FDORA_OUT_MODIFY_COLUMN_COUNT`	No
`FDORA_OUT_DROP_CONSTRAINT_COUNT`	No
`FDORA_OUT_ADD_CONSTRAINT_COUNT`	No
`FDORA_OUT_MODIFY_CONSTRAINT_COUNT`	No
`FDORA_OUT_DROP_INDEX_COUNT`	No
`FDORA_OUT_CREATE_INDEX_COUNT`	No
`FDORA_OUT_ALTER_INDEX_COUNT`	No
`FDORA_OUT_DROP_VIEW_COUNT`	No
`FDORA_OUT_CREATE_VIEW_COUNT`	No
`FDORA_OUT_ALTER_VIEW_COUNT`	No
`FDORA_OUT_DROP_SEQUENCE_COUNT`	No
`FDORA_OUT_CREATE_SEQUENCE_COUNT`	No
`FDORA_OUT_ALTER_SEQUENCE_COUNT`	No
`FDORA_OUT_DROP_PROCEDURE_COUNT`	No
`FDORA_OUT_CREATE_PROCEDURE_COUNT`	No
`FDORA_OUT_ALTER_PROCEDURE_COUNT`	No
`FDORA_OUT_DROP_TRIGGER_COUNT`	No
`FDORA_OUT_CREATE_TRIGGER_COUNT`	No
`FDORA_OUT_ALTER_TRIGGER_COUNT`	No
`FDORA_OUT_DROP_SYNONYM_COUNT`	No
`FDORA_OUT_CREATE_SYNONYM_COUNT`	No
`FDORA_OUT_DROP_FUNCTION_COUNT`	No
`FDORA_OUT_CREATE_FUNCTION_COUNT`	No
`FDORA_OUT_ALTER_FUNCTION_COUNT`	No
`FDORA_OUT_DROP_TYPE_COUNT`	No
`FDORA_OUT_CREATE_TYPE_COUNT`	No
`FDORA_OUT_ALTER_TYPE_COUNT`	No
`FDORA_OUT_DROP_TYPE_BODY_COUNT`	No
`FDORA_OUT_CREATE_TYPE_BODY_COUNT`	No
`FDORA_OUT_ALTER_TYPE_BODY_COUNT`	No
`FDORA_OUT_DROP_PACKAGE_COUNT`	No
`FDORA_OUT_CREATE_PACKAGE_COUNT`	No
`FDORA_OUT_ALTER_PACKAGE_COUNT`	No
`FDORA_OUT_DROP_PACKAGE_BODY_COUNT`	No
`FDORA_OUT_CREATE_PACKAGE_BODY_COUNT`	No
`FDORA_OUT_ALTER_PACKAGE_BODY_COUNT`	No
`FDORA_OUT_DROP_MVIEW_COUNT`	No
`FDORA_OUT_CREATE_MVIEW_COUNT`	No
`FDORA_OUT_ALTER_MVIEW_COUNT`	No
`FDORA_OUT_DROP_MVIEW_LOG_COUNT`	No
`FDORA_OUT_CREATE_MVIEW_LOG_COUNT`	No
`FDORA_OUT_ALTER_MVIEW_LOG_COUNT`	No
`FDORA_OUT_OBJECT_GRANT_COUNT`	No
`FDORA_OUT_BL_TABLE_COUNT`	No
`FDORA_OUT_BL_INDEX_COUNT`	No
`FDORA_OUT_BL_CONSTRAINT_COUNT`	No
`FDORA_OUT_BL_SEQUENCE_COUNT`	No
`FDORA_OUT_BL_PROCEDURES_COUNT`	No
`FDORA_OUT_BL_VIEWS_COUNT`	No
`FDORA_OUT_BL_SYNONYMS_COUNT`	No
`FDORA_OUT_BL_MVIEW_COUNT`	No
`FDORA_OUT_BL_MVIEW_LOG_COUNT`	No
`FDORA_OUT_RENAME_TABLE_COUNT`	No
`FDORA_OUT_RENAME_COLUMN_COUNT`	No
`FDORA_OUT_RENAME_CONSTRAINT_COUNT`	No
`FDORA_OUT_RENAME_INDEX_COUNT`	No
`FDORA_OUT_RENAME_VIEW_COUNT`	No
`FDORA_OUT_RENAME_SEQUENCE_COUNT`	No
`FDORA_OUT_RENAME_TRIGGER_COUNT`	No
`FDORA_OUT_RENAME_SYNONYM_COUNT`	No
`FDORA_OUT_BL_PRIVILEGES_COUNT`	No

Artifacts

This operation consumes artifacts from the artifacts repository.

Endpoint Selection

This operation will select all available endpoints associated to the environment/instance.

Endpoint Execution

This operation will execute on any one of the selected endpoints and will be random in the determination of which one.

Special Considerations

[Delete section if not needed]

Describe any dependencies between properties that may exist or anything that that isn’t really covered above but is relevant to this operation.

synchronize