Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Scan test Run ApexSec  ApexDBWorkspaceScan test and it returns only pass percentage in the FlexDeploy UI.

Environment/Instance Properties

Property NameProperty CodeRequiredDescription
APEXSEC Jar file pathFDAPEXSEC_SCANNER_JARYesApexSec Scanner Jar with complete path (example C:\\ApexScanner\\apexScanner.jar)
APEX URL NameFDAPEX_URLDatabase HostFDAPEXSEC_APEX_DB_HOSTYesApex Database Host Name for DBWorkspace
APEX Database PortFDAPEXSEC_APEX_DB_PORTYesApex URL Name Database Port Number for DBWorkspace (e.g http://[host]:[port]/apex1521)
APEX User NameFDAPEX_USERYesProvide database user APEX_xxxxx or owner (parsing schema) of the application for export and import operations. You can use system user as well
APEX PasswordFDAPEX_PASSWORDYesPassword for APEX User.
APEX Database HostFDAPEXSEC_APEX_DB_HOSTYesApex Database Host Name for DBWorkspace
APEX Database PortFDAPEXSEC_APEX_DB_PORTYesApex Database Port Number for DBWorkspace (e.g 1521)

Project Properties

Yes
Property NameProperty CodeRequiredDescriptionWorkspace NameFDAPEX_WORKSPACE_NAME
APEX Workspace Name. Provide uppercase name.
Application IDFDAPEX_APPLICATION_IDNoAPEX Application ID
APEX SIDFDAPEXSEC_APEX_DB_SIDYesApex SID (e.g apx03)
APEX SQL File NameFDAPEXSEC_SQL_FILEYesThe path to the Apex SQL file. If relative, it is assumed to be in the FD_ARTIFACTS_DIR.Application IDFDAPEX_APPLICATION_IDNoAPEX Application ID

Inputs

Input NameInput CodeRequiredDescription
APEX Database HostAPEX URL NameFDAPEX_URLFDAPEXSEC_APEX_DB_HOSTNoApex Database Host Name for DBWorkspace
APEX Database PortFDAPEXSEC_APEX_DB_PORTNoApex URL Name Database Port Number for DBWorkspace (e.g http://[host]:[port]/apex1521)
Workspace NameFDAPEX_WORKSPACE_NAMENoAPEX Workspace Name. Provide uppercase name.APEX SIDFDAPEXSEC_APEX_DB_SIDNoApex SID (e.g apx03)
APEX User NameFDAPEX_USERNoProvide database user APEX_xxxxx or owner (parsing schema) of the application for export and import operations. You can use system user as well
APEX PasswordFDAPEX_PASSWORDNoPassword for APEX User.
Application IDFDAPEX_APPLICATION_IDNoAPEX Application ID
APEX Database HostFDAPEXSEC_APEX_DB_HOSTNoApex Database Host Name for DBWorkspace
APEX Database PortFDAPEXSEC_APEX_DB_PORTNoApex Database Port Number for DBWorkspace (e.g 1521)
APEX SIDFDAPEXSEC_APEX_DB_SIDNoApex SID (e.g apx03)
APEX SQL File NameFDAPEXSEC_SQL_FILENoThe path to the Apex SQL file. If relative, it is assumed to be in the FD_ARTIFACTS_DIR.

Outputs

Output NameDescription
FDAPEXSEC_SCAN_PASSPERCENTAGEThe pass percentage of  testfrom the Apex Scan. eg: 85

Artifacts

This operation produces artifacts that will be stored in the artifacts repository for only SQL filedoesn’t consume or produce any artifacts.

Endpoint Selection

This operation delegates endpoint selection to the workflow developer. The workflow editor will default the selection to "All", which selects all available endpoints associated to the environment instance. Selecting a specific resource will result in selection of endpoints associated to the environment instance which have that resource defined. 

Endpoint Execution

This operation delegates endpoint execution to the workflow developer. The workflow editor will default to "Any", which will execute on any one of the selected endpoints, which will be randomly picked from selected endpoints or a specific endpoint where previous step may have executed. Changing this value to "All" to will result in execution on all selected endpoints.