Description Creates a baseline of the operation hereinput schema name.
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 |
| Revert to Baseline ID | FDORA_REVERT_TO_BASELINE_ID | ??? - please update plugin.xml with <IsRequired> as well. | Numeric ID of the baseline to revert an environment to. |
| Table Renames | FDORA_TABLE_RENAMES | ??? - please update plugin.xml with <IsRequired> as well. | Table rename string. |
| Index Renames | FDORA_INDEX_RENAMES | ??? - please update plugin.xml with <IsRequired> as well. | Index rename string. |
| Column Renames | FDORA_COLUMN_RENAMES | ??? - please update plugin.xml with <IsRequired> as well. | Column rename string. |
| Trigger Renames | FDORA_TRIGGER_RENAMES | ??? - please update plugin.xml with <IsRequired> as well. | Trigger rename string. |
| Constraint Renames | FDORA_CONSTRAINT_RENAMES | ??? - please update plugin.xml with <IsRequired> as well. | Constraint rename string. |
| Synonym Renames | FDORA_SYNONYM_RENAMES | ??? - please update plugin.xml with <IsRequired> as well. | Synonym rename string. |
| Sequence Renames | FDORA_SEQUENCE_RENAMES | Sequence rename string. | |
| View Renames | FDORA_VIEW_RENAMES | View rename string. | |
Outputs
Output Name | Required | Description |
|---|---|---|
FDORA_OUT_BASELINE_ID | 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_BL_PRIVILEGES_COUNT | No |
Artifacts (Keep one and edit if desired.)
This operation doesn’t consume or produce any artifacts.
This operation consumes artifacts from the artifacts repository.
This operation produces artifacts that will be stored in the artifacts repository.
This operation delegates the consume/produce artifacts decision to the workflow developer.
Endpoint Selection (Keep one and edit if desired.)
This operation will select all available endpoints associated to the environment instance which have resource type of {Resource Type}. This operation will select all available endpoints associated to the environment/instance.
This operation delegates the selection to the workflow developer to determine.
Endpoint Execution (Keep one and edit if desired.)
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
This operation will execute on all of the selected endpoints and will execute on each of the selected endpoints.
This operation will select all available endpoints associated to the environment instance which have resource type of {resource type}.
This operations delegates the execution to the workflow developer to decide.
Special Considerations
[Delete section if not needed]
...