{"id":7729,"date":"2016-04-27T21:59:13","date_gmt":"2016-04-27T19:59:13","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/"},"modified":"2016-04-27T21:59:13","modified_gmt":"2016-04-27T19:59:13","slug":"apex-connect-2016-day-2-apex","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/","title":{"rendered":"APEX Connect 2016 – Day 2 – APEX"},"content":{"rendered":"

After the great Keynote about “APEX Vision, Past, Present, Future” by Mike Hichwa, the father of APEX, I decided to attend presentations on following topics:
\n– Dynamic Actions 5.1
\n– APEX and Oracle JET
\n– Enterprise UX patterns
\n– APEX Scripting
\n– Automation on APEX instance<\/p>\n

APEX Vision, Past, Present, Future<\/strong>:
\nMike Hichwa provided a very interesting overview of how WEB DB was born, turned into Project Marvel which gave HTML DB and finally became
\nAPEX, with numerous stories around it.
\nThe vision of the future for APEX with upcoming version 5.1 and further challenges and expectations is very promising.
\nAPEX is looking at a bright future.
\nIn addition we got to know about ABCS (Application Business Connector Services), which can be seen as “APEX light” for business users, as they can build their own apps from there.<\/p>\n

Dynamic Actions 5.1<\/strong>:
\nThe web browser can be seen as the new desktop. Nowadays you can do almost everything in your browser:
\n– Create documents
\n– Edit spreadsheets
\n– Create presentations
\n– Mail
\n– Edit pictures
\n– …
\nAll of that is enabled for a big part of it, by JavaScript.
\nAPEX tries to abstract JavaScript from the developer with Dynamic Actions which allow to hide some of the complexity.
\n“If you don’t use Dynamic Actions, you are a forms developer, not a web application developer” according to Juergen Schuster, the host of the presentation.
\nThanks to Dynamic Actions APEX went easier into a new dimension with Ajax, so that it can be avoided to submit and reload to the same page. Applications look much more user friendly. You just need to notice that APEX handles Ajax calls like get and not post. So it is impacted by Session State Protection.
\nTo learn more about Dynamic Actions and try them, please visit:
\nhttp:\/\/dynamic-actions.com
\n<\/a><\/p>\n

APEX and Oracle JET<\/strong>:
\nOracle JavaScript Extension Tool is part of the future of APEX as new charts should appear in APEX 5.1 based on that technology.
\nOracle JET is a framework developed for interaction with Oracle Cloud Services, based on different JavaScript libraries:
\n– JQuery
\n– JQuery UI
\n– Hammer
\n– RequireJS
\n– Knockout
\nThe given demo was about charting and tables with and without live data.
\nIf you want to know more about Oracle JET and APEX please visit following blog ny Sven Weller:
\nhttps:\/\/svenweller.wordpress.com\/2016\/04\/07\/integrate-oracle-jet-into-apex-5\/<\/a>
\nMore details can be found on the Oracle site:
\nhttp:\/\/www.oracle.com\/webfolder\/technetwork\/jet\/index.html<\/a><\/p>\n

Enterprise UX patterns<\/strong>:
\nWhat is the gain of using patterns? The answer is instant familiarity, people don’t have to think about before using it.
\nThere are many patterns in our daily life and so are in the web sites.
\nFor web applications most common patterns are about following items:
\n– Login page
\n– Filtering
\n– Marquee pages
\n– Modal Dialogs
\n– Complex Forms
\nIn this area APEX also shows its power and flexibility to stick to the common patterns with few efforts for the developers.
\nI would suggest you to visit following website if you are interested in UI patterns:
\nhttp:\/\/ui-patterns.com\/<\/a><\/p>\n

APEX Scripting<\/strong>:
\nAPEX is based on PL\/SQL and provides numerous packages, so you can make use of them for scripting purpose as actions from the UI can be done by calling them. There are also tools provided like the java based export tool.
\nTherefore scripting can be used for following purpose around APEX:
\n– Export
\n– Backup
\n– Deployment
\nPackages which are useful for those purpose are:
\n– APEX_INSTANCE_ADMIN
\n– APEX_UTIL
\n– APEX_LANG
\nAs those packages are in the database, the new upcoming SQLcl tool (replacement of SQL Plus) should be considered.
\nPlease visit following webpage for more details around SQLcl:
\nhttp:\/\/www.oracle.com\/technetwork\/issue-archive\/2015\/15-sep\/o55sql-dev-2692807.html<\/a><\/p>\n

Automation on APEX instance<\/strong>:
\nAs a continuity of the previous topic, and based on the same predicates, some tasks related to APEX administration can be automated like workspace provisioning, exports for versioning and regular “system” reporting.
\nAPEX administration is somewhere between the DBA and the developer. Therefore following aspects must be looked at when going for administration automation:
\n– Responsibility
\n– Approvals on user requests
\n– Rights definition
\n– Resource management
\n– Administration tasks distribution
\nAPEX provides some functionality for automated workspace delivery, but it can be enhanced by developing a custom solution where for example SSO would be used to identify enterprise users. Also specific roles could be provided and for example default template application installed as well as specific packaged\/sample applications.<\/p>\n","protected":false},"excerpt":{"rendered":"

After the great Keynote about “APEX Vision, Past, Present, Future” by Mike Hichwa, the father of APEX, I decided to attend presentations on following topics: – Dynamic Actions 5.1 – APEX and Oracle JET – Enterprise UX patterns – APEX Scripting – Automation on APEX instance APEX Vision, Past, Present, Future: Mike Hichwa provided a […]<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368],"tags":[304,823,96],"type_dbi":[],"class_list":["post-7729","post","type-post","status-publish","format-standard","hentry","category-development-performance","tag-apex","tag-apex-connect-2016","tag-oracle"],"acf":[],"yoast_head":"\nAPEX Connect 2016 - Day 2 - APEX - dbi Blog<\/title>\n<meta name=\"description\" content=\"Blog about APEX Connect 2016 Day2 APEX, focused on Dynamic Actions, Oracle JET, Enterprise UX patterns, Scripting and Automation\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"APEX Connect 2016 - Day 2 - APEX\" \/>\n<meta property=\"og:description\" content=\"Blog about APEX Connect 2016 Day2 APEX, focused on Dynamic Actions, Oracle JET, Enterprise UX patterns, Scripting and Automation\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-27T19:59:13+00:00\" \/>\n<meta name=\"author\" content=\"Alain Lacour\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alain Lacour\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/\"},\"author\":{\"name\":\"Alain Lacour\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"headline\":\"APEX Connect 2016 – Day 2 – APEX\",\"datePublished\":\"2016-04-27T19:59:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/\"},\"wordCount\":758,\"commentCount\":0,\"keywords\":[\"APEX\",\"APEX connect 2016\",\"Oracle\"],\"articleSection\":[\"Development & Performance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/\",\"name\":\"APEX Connect 2016 - Day 2 - APEX - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-04-27T19:59:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"description\":\"Blog about APEX Connect 2016 Day2 APEX, focused on Dynamic Actions, Oracle JET, Enterprise UX patterns, Scripting and Automation\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"APEX Connect 2016 – Day 2 – APEX\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\",\"name\":\"Alain Lacour\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"caption\":\"Alain Lacour\"},\"description\":\"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"APEX Connect 2016 - Day 2 - APEX - dbi Blog","description":"Blog about APEX Connect 2016 Day2 APEX, focused on Dynamic Actions, Oracle JET, Enterprise UX patterns, Scripting and Automation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/","og_locale":"en_US","og_type":"article","og_title":"APEX Connect 2016 - Day 2 - APEX","og_description":"Blog about APEX Connect 2016 Day2 APEX, focused on Dynamic Actions, Oracle JET, Enterprise UX patterns, Scripting and Automation","og_url":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/","og_site_name":"dbi Blog","article_published_time":"2016-04-27T19:59:13+00:00","author":"Alain Lacour","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alain Lacour","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/"},"author":{"name":"Alain Lacour","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"headline":"APEX Connect 2016 – Day 2 – APEX","datePublished":"2016-04-27T19:59:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/"},"wordCount":758,"commentCount":0,"keywords":["APEX","APEX connect 2016","Oracle"],"articleSection":["Development & Performance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/","url":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/","name":"APEX Connect 2016 - Day 2 - APEX - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-04-27T19:59:13+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"description":"Blog about APEX Connect 2016 Day2 APEX, focused on Dynamic Actions, Oracle JET, Enterprise UX patterns, Scripting and Automation","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2016-day-2-apex\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"APEX Connect 2016 – Day 2 – APEX"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0","name":"Alain Lacour","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","caption":"Alain Lacour"},"description":"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.","url":"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=7729"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7729\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7729"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}