{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Export APEX applications from App Builder environment. One or more Application is exported based on provided inputs. You can use this operation to export applications from development environment and commit to SCM on periodic basis. See example workflow below on this page. Example workflow is exporting applications in apexexport folder and then Git repository is cloned in to apexgitrepo, eventually exported files are copied in to cloned repository and committed.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Target Properties","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","localId":"5d151418-a3ed-4b60-85f5-fc08adc8022c"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"Property Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[253.0]},"content":[{"type":"paragraph","content":[{"text":"Property Code","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[92.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[648.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"Oracle SQLcl Home","type":"text","marks":[{"type":"textColor","attrs":{"color":"#4f4f4f"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[253.0]},"content":[{"type":"paragraph","content":[{"text":"FD_SQLCL_HOME","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[92.0]},"content":[{"type":"paragraph","content":[{"text":"Yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[648.0]},"content":[{"type":"paragraph","content":[{"text":"Folder where SQLcl is installed.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Use JDK 8 for Endpoint Java due to SQLcl requirements.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"APEX User","type":"text","marks":[{"type":"textColor","attrs":{"color":"#4f4f4f"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[253.0]},"content":[{"type":"paragraph","content":[{"text":"FDAPEX_USER","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[92.0]},"content":[{"type":"paragraph","content":[{"text":"Yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[648.0]},"content":[{"type":"paragraph","content":[{"text":"Provide database user APEX_xxxxx (APEX user requires INHERIT Privilege) or owner (parsing schema) of the application for export and import operations. You can use system user as well. ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"APEX Password","type":"text","marks":[{"type":"textColor","attrs":{"color":"#4f4f4f"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[253.0]},"content":[{"type":"paragraph","content":[{"text":"FDAPEX_PASSWORD","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[92.0]},"content":[{"type":"paragraph","content":[{"text":"Yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[648.0]},"content":[{"type":"paragraph","content":[{"text":"Password for APEX User. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"Oracle Database URL","type":"text","marks":[{"type":"textColor","attrs":{"color":"#4f4f4f"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[253.0]},"content":[{"type":"paragraph","content":[{"text":"FDORA_URL","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[92.0]},"content":[{"type":"paragraph","content":[{"text":"Yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[648.0]},"content":[{"type":"paragraph","content":[{"text":"JDBC URL for Oracle database. For example:","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" jdbc:oracle:thin:@HOSTNAME:PORT:SID or ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]},{"text":".","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"include","parameters":{"macroParams":{"":{"value":"FD60:Using wallet with oracle database"}},"macroMetadata":{"macroId":{"value":"4719a625-b81b-4267-a8f5-82b2876fa8b4"},"schemaVersion":{"value":"1"},"title":"Include Page"}},"localId":"3c48625d-1100-4fb6-807c-03ae73518976"}}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Project Properties","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","localId":"16e6ba96-eb20-4643-8003-23ec9d3c42a6"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[225.87]},"content":[{"type":"paragraph","content":[{"text":"Property Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[236.53]},"content":[{"type":"paragraph","content":[{"text":"Property Code","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[88.9]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[602.18]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[225.87]},"content":[{"type":"paragraph","content":[{"text":"Export Supporting Object Definitions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.53]},"content":[{"type":"paragraph","content":[{"text":"FDAPEX_EXPORT_SUPPORTING_OBJECTS","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[88.9]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[602.18]},"content":[{"type":"paragraph","content":[{"text":"Specify whether to export supporting object definitions with your application.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[225.87]},"content":[{"type":"paragraph","content":[{"text":"Export Public Reports","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.53]},"content":[{"type":"paragraph","content":[{"text":"FDAPEX_EXPORT_PUBLIC_REPORTS","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[88.9]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[602.18]},"content":[{"type":"paragraph","content":[{"text":"Specify whether to include public reports with your application.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[225.87]},"content":[{"type":"paragraph","content":[{"text":"Export Report Subscriptions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.53]},"content":[{"type":"paragraph","content":[{"text":"FDAPEX_EXPORT_REPORT_SUBSCRIPTIONS","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[88.9]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[602.18]},"content":[{"type":"paragraph","content":[{"text":"Specify whether to include interactive report or interactive grid subscription settings with your application.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[225.87]},"content":[{"type":"paragraph","content":[{"text":"Export Developer Comments","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.53]},"content":[{"type":"paragraph","content":[{"text":"FDAPEX_EXPORT_DEV_COMMENTS","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[88.9]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[602.18]},"content":[{"type":"paragraph","content":[{"text":"Specify whether to include Developer Comments in your application export.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[225.87]},"content":[{"type":"paragraph","content":[{"text":"Export Translations","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.53]},"content":[{"type":"paragraph","content":[{"text":"FDAPEX_INCLUDE_TRANSLATION","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[88.9]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[602.18]},"content":[{"type":"paragraph","content":[{"text":"Check to include Translations with your application export.","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Inputs","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","localId":"a1c99bbc-dbb4-43dc-ae29-7c3557c1805e"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[241.0]},"content":[{"type":"paragraph","content":[{"text":"Input Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[255.0]},"content":[{"type":"paragraph","content":[{"text":"Input Code","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[94.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[648.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[241.0]},"content":[{"type":"paragraph","content":[{"text":"Workspace Name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[255.0]},"content":[{"type":"paragraph","content":[{"text":"FDAPEX_INP_WORKSPACE_NAME","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[94.0]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[648.0]},"content":[{"type":"paragraph","content":[{"text":"APEX workspace name. If not provided, all applications matching name will be exported.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[241.0]},"content":[{"type":"paragraph","content":[{"text":"Application Name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[255.0]},"content":[{"type":"paragraph","content":[{"text":"FDAPEX_INP_APPLICATION_NAME","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[94.0]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[648.0]},"content":[{"type":"paragraph","content":[{"text":"APEX application name. If application name, workspace name, and application id are not provided, then all applications will be exported.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[241.0]},"content":[{"type":"paragraph","content":[{"text":"Application ID","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[255.0]},"content":[{"type":"paragraph","content":[{"text":"FDAPEX_INP_APPLICATION_ID","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[94.0]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[648.0]},"content":[{"type":"paragraph","content":[{"text":"APEX Application ID. This will take priority over workspace name and application name if it is provided.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[241.0]},"content":[{"type":"paragraph","content":[{"text":"Export Folder","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[255.0]},"content":[{"type":"paragraph","content":[{"text":"FDAPEX_INP_EXPORT_FOLDER","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[94.0]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[648.0]},"content":[{"type":"paragraph","content":[{"text":"Absolute or relative to temp directory path for exported applications.","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Artifacts","type":"text"}]},{"type":"paragraph","content":[{"text":"This operation doesn’t consume or produce any artifacts.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Endpoint Selection","type":"text"}]},{"type":"paragraph","content":[{"text":"This operation will select all available endpoints associated to the Target. You can use any Endpoint where SQLcl is installed and has connectivity to database using JDBC URL. We recommend use of LOCALHOST endpoint if connectivity can be established between FlexDeploy and your APEX database.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Endpoint Execution","type":"text"}]},{"type":"paragraph","content":[{"text":"This operation will execute on any one of the selected endpoints and will be random in the determination of which one.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Example Workflow","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Export and commit to Git","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\n Export Apex Applications\n \n \n \n exportAPEXApplications\n 1\n \n FlexagonOracleAPEXPlugin\n exportAPEXApplications\n false\n false\n \n \n FDAPEX_INP_WORKSPACE_NAME\n Text\n false\n String\n \n \n FDAPEX_INP_APPLICATION_NAME\n Text\n false\n String\n \n \n FDAPEX_INP_EXPORT_FOLDER\n Text\n false\n String\n apexexport\n \n \n \n \n \n \n \n \n Git Clone\n 2\n \n FlexagonGITPlugin\n clone\n false\n false\n \n \n FDGIT_INP_INSTANCE_CODE\n Text\n false\n String\n GITDEMO\n \n \n FDGIT_INP_DEST_SUBFOLDER\n Text\n false\n String\n apexgitrepo\n \n \n FDGIT_INP_BRANCH\n Text\n false\n String\n master\n \n \n FDGIT_INP_DEPTH\n Text\n false\n Integer\n 1\n \n \n FDGIT_INP_SPARSE_CHECKOUT_FOLDERS\n Text\n false\n String\n APEXV2\n \n \n \n \n \n \n \n \n Copy exported files to local Git repo\n 3\n \n FlexagonFilePlugin\n copy\n false\n false\n \n All\n \n Any\n \n \n FDFILE_INP_FILE_FILTER\n Text\n false\n String\n *.sql\n \n \n FDFILE_INP_FILE_FILTER_EXCLUDED\n Text\n false\n String\n \n \n FDFILE_INP_SOURCE_PATH\n Expression\n false\n String\n \n FD_TEMP_DIR + \"/apexexport\"\n \n \n \n FDFILE_INP_TARGET_PATH\n Expression\n false\n String\n \n FD_TEMP_DIR + \"/apexgitrepo/APEXV2\"\n \n \n \n FDFILE_INP_CLEAN_DIRECTORY\n Text\n false\n Boolean\n true\n \n \n \n \n \n \n \n \n Add any new Files\n 4\n \n FlexagonGITPlugin\n add\n false\n false\n \n \n FDGIT_INP_INSTANCE_CODE\n Text\n false\n String\n GITDEMO\n \n \n FDGIT_INP_DEST_SUBFOLDER\n Text\n false\n String\n apexgitrepo\n \n \n FDGIT_INP_FILELIST\n Text\n false\n String\n --all .\n \n \n \n \n \n \n \n \n Commit to Git\n 5\n \n FlexagonGITPlugin\n commit\n false\n false\n \n \n FDGIT_INP_INSTANCE_CODE\n Text\n false\n String\n GITDEMO\n \n \n FDGIT_INP_DEST_SUBFOLDER\n Text\n false\n String\n apexgitrepo\n \n \n FDGIT_INP_NAME\n Expression\n false\n String\n \n FD_WF_USER\n \n \n \n FDGIT_INP_EMAIL\n Expression\n false\n String\n \n FD_WF_USER_EMAIL\n \n \n \n FDGIT_INP_REVISION_MESSAGE\n Text\n false\n String\n new apex files\n \n \n \n \n \n \n \n \n Push to Central Repository\n 6\n \n FlexagonGITPlugin\n push\n false\n false\n \n \n FDGIT_INP_INSTANCE_CODE\n Text\n false\n String\n GITDEMO\n \n \n FDGIT_INP_DEST_SUBFOLDER\n Text\n false\n String\n apexgitrepo\n \n \n FDGIT_INP_BRANCH\n Text\n false\n String\n master\n \n \n FDGIT_INP_FOLLOW_TAGS\n Text\n false\n Boolean\n false\n \n \n \n \n \n \n \n \n","type":"text"}]}],"version":1}