...
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 TheFDORA_DRIVER_PATH 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_DRIVERDDL_PATHURL | Yes | The JDBC URL for the DDL repository. |
| DDL Repository User | FDORA_DDL_DRIVER_PATHUSER | Yes | The userid used to connect to the DDL repository. |
| DDL Repository Password | FDORA_SCHEMADDL_NAMEPASSWORD | 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 | FDORA_DDL_URL | Yes | DDL Repository User
| Oracle Database Schema Name(s) | FDORA_DDLSCHEMA_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 | DescriptionNAME | 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 | Whether to generate a baseline on the target environment and compare to new baseline. | |
| Preview Execution | FDORA_PREVIEW_EXECUTION | Whether to bypass actual execution of the DDL, and simply run the compare. |
...