Versions Compared

Key

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

...

Tip

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 name.
  • Build will run in Development environment, so when source is App Builder, application from Development environment is exported.
  • Deployment is configured to run against Test environment irrespective of build options. (developers will be editing application in development environment, so deployment is set to run against Test environment).

...

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

...

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

Image RemovedImage Removed

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

If you use App Builder as Build Option then SQLcl Home, User, Password, JDBC URL is needed. In case of Build, development server values should be used, as export of application is done from Development environment. Also, for user you can use parsing schema, system or APEX_* user.

A localhost endpoint (available out of box) is used for build and deploy.

Tip
titleWhich endpoint?

The endpoint can be any server which contains the Oracle JDBC drive rand the SQLcl clientLocalhost endpoint is used so make sure SQLcl client is installed on FlexDeploy server.

Deploy

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

...


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 parsing schema user, 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


Tip
titleWhich 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 necessaryLocalhost endpoint is used so make sure SQLcl client is installed on FlexDeploy server.