Oracle APEX Application

The Oracle APEX Application blueprint will create the topology, workflows, source control repository connection, and project for managing the build and deployment of an APEX application.

Install SQLcl client on FlexDeploy server, which is just a zip file that can be extracted in folder like c:\installs or /u01, in which case SQLcl Home will be c:\installs\sqlcl or /u01/sqlcl. You can decide to use a different server if you like but that would require small adjustments once you run through this blueprint.

  • The Development environment is both the build environment and the single target environment mapped to for deployment.
  • The build instance instance is also used for deployment.
  • The build workflow, Build APEX, is created/linked and bound to APEX projects creating using this blueprint.
  • The deploy workflow, Deploy APEX, is created once and bound to all APEX projects created using this blueprint.
  • The instance is created based on the Parsing Schema.

Blueprint Properties

Property Name
Required
Description
How its used
Application NameYesThe APEX application name as configured in App Builder
  • FlexDeploy project is named using this value
  • FlexDeploy project property is configured to this value
Application DescriptionNoA description for the application
  • FlexDeploy project's description is set to this value
Parsing SchemaYesThe parsing (owner) schema for the application
  • FlexDeploy application name is configured to this value
  • FlexDeploy project property is configured to this value
  • FlexDeploy instance is created using this value
Workspace NameYesThe workspace the application belongs to
  • FlexDeploy instance is created using this value
  • FlexDeploy project is mapped to this instance

Build 

There are two options for building an Oracle APEX application.  You can download the source files from the APEX App Builder, or source the files from a source control repository such as Git or Subversion. 

Build Properties

There are no Build Properties for this blueprint, whether building from App Builder or an SCM Repository.

A single Development endpoint is created and linked to all Oracle APEX projects for the instance (Parsing Schema).

Which endpoint?

The endpoint can be any server which contains the Oracle JDBC driver and the SQLcl client.

Deploy

All APEX applications are deployed using FlexDeploy's Oracle APEX Plugin.  As such, the only and default deploy option is Deploy APEX.

Deploy Properties

Property Name
Required
Description
How its used
SQLcl HomeNoDirectory where SQLcl is installed on the endpoint

FlexDeploy environment instance property is configured to this value

APEX UserYesAPEX user to import and export applications with.  Use system or APEX_<xxxx>.

FlexDeploy environment instance property is configured to this value

APEX Password

Yes

The password for APEX User.FlexDeploy environment instance property is configured to this value
Oracle Database URLYesThe JDBC connect string for the Oracle Database hosting the application.FlexDeploy environment instance property is configured to this value

Which endpoint?

The endpoint can be any server which contains SQLcl client. Blueprint will default to execution on LOCALHOST which is FlexDeploy server itself, you can decide to change that if necessary.