{"id":1350,"date":"2021-02-17T15:30:00","date_gmt":"2021-02-17T14:30:00","guid":{"rendered":"https:\/\/promatis.com\/ch\/oracle-apex-cloud-service-inexpensively-available-in-the-oracle-cloud\/"},"modified":"2023-03-28T12:46:18","modified_gmt":"2023-03-28T10:46:18","slug":"oracle-apex-cloud-service-inexpensively-available-in-the-oracle-cloud","status":"publish","type":"post","link":"https:\/\/promatis-test.de\/ch\/en\/oracle-apex-cloud-service-inexpensively-available-in-the-oracle-cloud\/","title":{"rendered":"ORACLE APEX Cloud Service \u2013 inexpensively available in the Oracle Cloud"},"content":{"rendered":"<p>[et_pb_section fb_built=\"1\" custom_padding_last_edited=\"on|tablet\" disabled_on=\"off|off|off\" admin_label=\"Sektion\" _builder_version=\"4.17.6\" _module_preset=\"default\" custom_padding=\"5vh||5vh||true|false\" custom_padding_tablet=\"5vh||5vh||true|false\" custom_padding_phone=\"5vh||5vh||true|false\" global_module=\"22\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_row column_structure=\"1_4,3_4\" _builder_version=\"4.17.6\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_column type=\"1_4\" _builder_version=\"4.17.6\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_image src=\"\/.\/wp-content\/uploads\/2022\/07\/YvesChassein-e1658734137580.png?_t=1658758954\" alt=\"Yves Chassein PROMATIS\" _builder_version=\"4.17.6\" _module_preset=\"default\" width=\"90%\" custom_margin=\"||||false|false\" border_radii=\"on|1222px|1222px|1222px|1222px\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][\/et_pb_image][\/et_pb_column][et_pb_column type=\"3_4\" _builder_version=\"4.17.6\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_text ul_type=\"square\" _builder_version=\"4.19.5\" _module_preset=\"default\" text_font=\"Open Sans||||||||\" text_font_size=\"17px\" text_line_height=\"1.6em\" link_font=\"Open Sans||||on|||RGBA(255,255,255,0)|\" link_text_color=\"gcid-0becd5ff-19fc-4653-a221-c8c75771a987\" link_font_size=\"22px\" ul_font=\"Open Sans||||||||\" ul_font_size=\"17px\" ul_line_height=\"1.6em\" header_font=\"|600||on|||||\" header_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_font_size=\"47px\" header_line_height=\"1.2em\" header_2_font=\"|600||on|||||\" header_2_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_2_line_height=\"1.6em\" header_3_font=\"|600|||||||\" header_3_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_3_font_size=\"24px\" header_3_line_height=\"1.4em\" header_4_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_4_line_height=\"1.4em\" header_5_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_5_line_height=\"1.4em\" header_6_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_6_font_size=\"16px\" header_6_line_height=\"1.4em\" custom_margin=\"4vh||0px||false|false\" custom_padding=\"||||true|false\" text_font_size_tablet=\"20px\" text_font_size_phone=\"17px\" text_font_size_last_edited=\"on|tablet\" header_font_size_tablet=\"\" header_font_size_phone=\"28px\" header_font_size_last_edited=\"on|phone\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22%93,%22gcid-0becd5ff-19fc-4653-a221-c8c75771a987%22:%91%22link_text_color%22%93}\" theme_builder_area=\"post_content\"]<\/p>\n<div><a href=\"\/.\/en\/author\/ychassein\/\" rel=\"author\">Yves Chassein<\/a><\/div>\n<div>\n<p>&nbsp;<\/p>\n<div><strong>Senior Vice President<\/strong> \u2013 Head of Application Development<\/div>\n<\/div>\n<p>[\/et_pb_text][et_pb_text ul_type=\"square\" _builder_version=\"4.17.6\" _module_preset=\"default\" text_font=\"Open Sans||||||||\" text_text_color=\"gcid-0becd5ff-19fc-4653-a221-c8c75771a987\" text_font_size=\"22px\" text_line_height=\"1.6em\" link_font=\"Open Sans||||on||||\" link_text_color=\"#00A9A0\" ul_font=\"Open Sans||||||||\" ul_font_size=\"17px\" ul_line_height=\"1.6em\" header_font=\"|600||on|||||\" header_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_font_size=\"47px\" header_line_height=\"1.2em\" header_2_font=\"|600||on|||||\" header_2_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_2_line_height=\"1.6em\" header_3_font=\"|600|||||||\" header_3_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_3_font_size=\"24px\" header_3_line_height=\"1.4em\" header_4_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_4_line_height=\"1.4em\" header_5_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_5_line_height=\"1.4em\" header_6_text_color=\"gcid-32812186-bc94-4de4-814c-2bf202477fd5\" header_6_font_size=\"16px\" header_6_line_height=\"1.4em\" custom_margin=\"5px||0px||false|false\" custom_padding=\"||||true|false\" text_font_size_tablet=\"20px\" text_font_size_phone=\"17px\" text_font_size_last_edited=\"on|tablet\" header_font_size_tablet=\"\" header_font_size_phone=\"28px\" header_font_size_last_edited=\"on|phone\" locked=\"off\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22%93,%22gcid-0becd5ff-19fc-4653-a221-c8c75771a987%22:%91%22text_text_color%22%93}\" theme_builder_area=\"post_content\"]<a target=\"_blank\" href=\"https:\/\/de.linkedin.com\/in\/yves-chassein-76204bb4\" rel=\"noopener\"><i class=\"fab fa-linkedin\"><\/i><\/a><a target=\"_blank\" href=\"https:\/\/www.xing.com\/profile\/Yves_Chassein\/cv%20\" rel=\"noopener\"><i class=\"fab fa-xing-square\"><\/i><\/a><a target=\"_blank\" href=\"mailto:yves.chassein@promatis.de\" rel=\"noopener\"><i class=\"fas fa-envelope\"><\/i><\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\"1\" _builder_version=\"4.16\" _module_preset=\"default\" custom_padding=\"0vh||10vh||false|false\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_row use_custom_gutter=\"on\" _builder_version=\"4.17.3\" _module_preset=\"default\" custom_padding=\"0px||0px||true|false\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_column type=\"4_4\" _builder_version=\"4.16\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_text _builder_version=\"4.19.5\" _module_preset=\"default\" background_enable_color=\"off\" hover_enabled=\"0\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22%93,%22gcid-0becd5ff-19fc-4653-a221-c8c75771a987%22:%91%22background_color%22%93}\" theme_builder_area=\"post_content\" sticky_enabled=\"0\"]<\/p>\n<p>Oracle Application Express (APEX) is a popular low code platform for developing database-driven web applications. When previously wanting to operate such applications in the Oracle Cloud, there were two real alternatives. On the one hand Autonomous Database Service or Oracle Cloud Infrastructure (OCI) with a manually installed and maintained database, and on the other hand APEX. Oracle has also been offering an Oracle APEX Cloud Service since the beginning of the year. In the following, I want to examine who it is suited for and what advantages and disadvantages it involves.<\/p>\n<h3><strong>Oracle APEX Cloud Service, what\u2019s included?<\/strong><\/h3>\n<p>Oracle APEX Cloud Service consists of a database instance, similar to the Autonomous Database, which is completely managed by Oracle, as well as an APEX installation with a preconfigured Oracle Rest Data Service (ORDS). Billing \u2013 as is customary for databases in the cloud \u2013 takes place according to OCPUs and terabyte of data, not according to users, developer or the like. The database is accessed via <a href=\"http:\/\/www.thatjeffsmith.com\/archive\/2019\/12\/sql-developer-web-is-now-available\/\" rel=\"noopener\" target=\"_blank\">SQL Developer Web<\/a>, APEX or \u2013 after its implementation \u2013 REST service. With the SQL Developer Web, you can run SQL queries and scripts, create and modify database objects controlled by wizards, and generate database models. Thanks to the preconfigured ORDS, it is possible to provide REST services and read and manipulate data from the database.<\/p>\n<h3><strong>What\u2019s the difference to Autonomous Database Service?<\/strong><\/h3>\n<p>Compared to the Autonomous Database Service, the Oracle APEX Service does not allow a connection to the database via JDBC, which means clients such as Oracle\u2019s SQL Developer cannot be used. This means that interfaces that do not communicate with the database via REST cannot be created with APEX Cloud Service. If they are needed, the Oracle APEX Cloud Service can be upgraded to a \u2018full\u2019 Oracle Autonomous Transaction Processing Database with one click (of course, this also increases costs). Moreover, the two cloud services are very similar. Both cloud services are completely maintained by Oracle and updates are carried out automatically.<\/p>\n<h3><strong>What\u2019s the difference to Oracle Infrastructure Cloud Service<\/strong><\/h3>\n<p>Here the difference is more significant. In addition to the missing pre-configuration of Oracle APEX and ORDS, all patches must also be installed manually for the OCI variant. This therefore always requires a database administrator. In comparison, the Autonomous Database as well as the Oracle APEX service are maintained by Oracle itself and updated when updates are pending. With the OCI variant, it is possible \u2013 in contrast to the APEX service \u2013 to connect to the database itself via JDBC as well as to the database host via SSH. However, SQL Developer Web support is not available out of the box and needs to be installed subsequently.<\/p>\n<h3><strong>Conclusion<\/strong><\/h3>\n<p>If you are looking for an easy and cost-effective way to enter the Oracle Cloud with APEX, the Oracle APEX Service is exactly the right choice. After all, you can get started quickly and without further ado. Likewise, this cloud service makes it possible to run applications with more than 500 users. And if the REST interface and Oracle SQL Developer Web are no longer sufficient, you can easily upgrade to a \u2018full\u2019 Oracle Autonomous Transaction Processing Database.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Application Express (APEX) is a popular low code platform for developing database-driven web applications. When previously wanting to operate such applications in the Oracle Cloud, there were two real alternatives.<\/p>\n","protected":false},"author":3,"featured_media":1251,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[440],"tags":[171,173],"dipi_cpt_category":[],"class_list":["post-1350","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-techblog-en","tag-oracle-apex-2","tag-oracle-vbcs-2"],"_links":{"self":[{"href":"https:\/\/promatis-test.de\/ch\/en\/wp-json\/wp\/v2\/posts\/1350"}],"collection":[{"href":"https:\/\/promatis-test.de\/ch\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/promatis-test.de\/ch\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/en\/wp-json\/wp\/v2\/comments?post=1350"}],"version-history":[{"count":0,"href":"https:\/\/promatis-test.de\/ch\/en\/wp-json\/wp\/v2\/posts\/1350\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/en\/wp-json\/wp\/v2\/media\/1251"}],"wp:attachment":[{"href":"https:\/\/promatis-test.de\/ch\/en\/wp-json\/wp\/v2\/media?parent=1350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/en\/wp-json\/wp\/v2\/categories?post=1350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/en\/wp-json\/wp\/v2\/tags?post=1350"},{"taxonomy":"dipi_cpt_category","embeddable":true,"href":"https:\/\/promatis-test.de\/ch\/en\/wp-json\/wp\/v2\/dipi_cpt_category?post=1350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}