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 Name | Yes | The APEX application name as configured in App Builder |
|
| Application Description | No | A description for the application |
|
| Parsing Schema | Yes | The parsing (owner) schema for the application |
|
| Workspace Name | Yes | The workspace the application belongs to |
|
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 Home | No | Directory where SQLcl is installed on the endpoint | FlexDeploy environment instance property is configured to this value |
| APEX User | Yes | APEX 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 URL | Yes | The 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.
- style