...
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. | |
...
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
...
This operation produces artifacts that will be stored in 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.
...