Foreløbig Agenda til APEX-dag 3. september

Her er den foreløbige agenda for APEX-dagen 3. september.

0900-0910 Velkomst

0910-1000 Patrick Wolf: Insider News from the APEX Development Lab

1010-1100 Dimitri Gielis: Can you do that with APEX? Building not so straight forward pages…

1110-1200 Matt Nolan: Building Single Page Applications in APEX

1200-1300 Frokost

1300-1350 Carsten Czarski: REST Integration in APEX: Status quo and outlook

1400-1450 Dimitri Gielis: Print and Export data in the format you want (pptx, xlsx, pdf, …) with AOP

1500-1530 APEX Expert Q&A

1540-1630 Robert Johannesson: SoftBASE MasterAPP development concept for APEX

Automatiseringsværktøjer til Oracle-drift

Vi har fået Oracle Principal Product Manager Ricardo Gonzales til at lægge vejen forbi Danmark til et gå-hjem-møde hos Oracle den 27. maj kl. 15-17. Ricardo har bl.a. ansvaret for Oracle Fleet Patching and Provisioning, der gør det meget nemmere at opgradere, patche og opsætte Oracle databaser. Han har også til opgave at gøre det så nemt som muligt for Oracle kunder at migrere fra on-premise til cloud.

Kom og hør om hvordan man bruger GoldenGate Cloud Service, RMAN, Data Pump, MAA Methods, Remote Cloning, Plug / Unplug, Oracle SQL Developer Migration og Oracle Zero Downtime Migration til at komme i skyen, og hvordan man bruger “gold images” til at gøre administrationen af store Oracle-miljøer med mange databaser lettere.

Vi vil gerne have din tilmelding senest onsdag 22. maj.


A Cloud Journey – Migrating your Database to the Oracle Cloud

Oracle offers a wide array of options to bring your database to the Cloud.
In this talk, we will cover the different solutions that will allow for an easier and seamless migration to the Oracle Cloud in all its different use cases and flavors. We will introduce Oracle Move, Migrate Over to the Oracle Cloud, which offers you a simple and complete walk through of all Oracle Database Cloud Migration technologies.

We will discuss in depth the intricacies, requirements and how-to’s of our work and will walk you through the process through a series of demonstrations. A vast range of Oracle Cloud Migration technologies will be shared so that all your use cases will be covered. Wether it is offline or online migrations, we will cover it all.

We’ll discuss the different tools, such as scripts, the GoldenGate Cloud Service, RMAN, Data Pump, MAA Methods, Remote Cloning, Plug / Unplug and the Oracle SQL Developer Migration tool. We will also be presenting the soon to be released tool, Oracle Zero Downtime Migration, a new automated way to handle all your database cloud migration needs

Overall, you will have a better understanding on how to migrate your workloads into the Cloud and leverage all that Oracle has to offer.

Easy Provisioning Patching & Upgrading with Gold Images

Looking for a simple and efficient way to optimize your large estate management? Do you want to streamline your upgrade, patching, and provisioning efforts?

Focusing on Fleet Patching & Provisioning (formerly known as RHP), this session explores how to enhance software maintenance, deployment, patching, and upgrade operations.

Learn how Fleet Patching & Provisioning takes advantage of and maintains software gold images, a small set of approved software homes that contain the patches and configurations that you need.

See how you can create gold images based on existing deployments and which services you can use to obtain a preconfigured image tailored to your on-premises & cloud environments.

Foredrag Mike Dietrich vedrørende database opgradering

Vi havde et fremragende arrangement hos SimCorp i mandags med ca. 50 deltagere. Vi hørte Mike Dietrich, som er Master Produkt Manager hos Oracle, fortælle om bl.a. opgradering til Oracle 19c, Fallback strategier og det nye AutoUpgrade Tool. Mike har sin egen hjemmeside og blog, hvor man bl.a. kan downloade hans præsentationer – link nedenfor: https://mikedietrichde.com/slides/

Referat af DOUG generalforsamling 2019

Der blev afholdt ordinær generalforsamling i Danish Oracle User Group 21. marts hos Oracle. Dagsorden ifølge vedtægterne:

  1. Valg af dirigent
  2. Beretning fra formanden
  3. Beretning(er) fra evt. udvalg/grupper
  4. Fremlæggelse af regnskab
  5. Forslag fra bestyrelsen
    – Det kommende års budget
    – Fastlæggelse af kontingent
  6. Behandling af indkomne forslag
  7. Valg af bestyrelse
  8. Valg af revisorer
  9. Eventuelt

Ad 1)

Sten Vesterli blev valgt. Generalforsamlingen er lovligt indvarslet.

Ad 2)

Aktiviteter i året der gik:

  • Maj: Oracle MLE meetup
  • August: APEX-dag
  • November: DOUG-dag
  • Februar 2019: APEX Front End Development

DOUG i tal

  • 621 medlemmer
  • 445 aktive (på mailinglisten)
    • “Open rate” for vores mails: 30-45%
  • 338 medlemmer af LinkedIn-gruppe
  • 13 tilmeldt Oracle MLE meetup
  • 39 tilmeldt APEX-dag
  • 44 tilmeldt DOUG-dag
  • 14 tilmeldt APEX Front End Development
  • 7 tilmeldt generalforsamling

Ad 3)

Der er pt. ingen udvalg eller grupper

Ad 4)

Regnskab fremlagt og godkendt.

Ad 5)

Budget fremlagt og godkendt.

Kontingentet fastholdes på nuværende niveau: Nul kroner.

Ad 6)

Ingen indkomne forslag.

Ad 7)

Bestyrelsen består nu af

  • Charlotte Hansen
  • Dimitri van de Ven
  • Jeanette Holland
  • Sten Vesterli
  • Steen Bartholdy
  • Tove Horn

Ken Holmslykke er valgt som suppleant.

Ad 8)

Lone Aalekjær genvalgt som revisor

Ad 9)

Intet.

APEX gå-hjem møde 19. februar

Kom til gå-hjem møde hos Oracle om APEX Front end development med APEX Nitro.

APEX er et stærkt værktøj til hurtigt at udvikle data-drevne web applikationer oven på en Oracle database. Men hvad gør man når brugerne vil have mere end APEX umiddelbart kan levere?

På dette møde fokuserer vi på, hvordan man kan forbedre front end delen af en APEX applikation, hovedsagelig med CSS og JavaScript. Vi ser også nærmere på et framework, der kan lette processen: “APEX Nitro”.

Du er velkommen til at tage din egen laptop med, hvis du har lyst til at prøve det under mødet.

Tilmeld dig venligst her, så vi kan sørge for forplejning.

DOUG-dagen 2018 bliver tirsdag 6. november

Årets DOUG-dag bliver tirsdag 6. november. Vi starter som sædvanlig med registrering og morgenmad fra kl. 9.00 og programmet starter 9.30. Der bliver en hel dag med to spor for hhv. udviklere og DBAer og efterfølgende fælles middag om aftenen. Tilmeldingen er åben, så du kan allerede nu sikre dig en plads. Prisen er 550 kroner for hele dagen inkl. morgenmad, frokost, kaffe og middag om aftenen, og det foregår som sædvanlig hos Oracle Danmark i Ballerup.

Vi får bl.a. besøg af Oracle ACE Director Ami Aharonovich fra Israel, der skal tale om The SQL* Family – Exploring SQL*Plus SQL Developer and SQLcl Best Practices for Developers and DBAs. Ami er virkelig ekspert i Oracle databasen og taler jævnligt på Oracle OpenWorld, KScope, DOAG, Collaborate og Oracle Code.

Program for APEX-dag 22. august

Tilmelding på https://www.doug.dk/events/2018/08/apex-dag-22-august/

Program

0930-1030 Carsten Czarski, Oracle: APEX 18.1 and beyond: What’s new?
1040-1140 Shakeeb Rahman, Oracle: The most amazing Universal Theme yet
1140-1220 Lunch
1220-1310 Carsten Czarski, Oracle: APEX and the REST of the world: Deep Dive
1320-1410 Shakeeb Rahman, Oracle: Building Big Things for Small Screens
1420-1510 APEX panel discussion with Carsten Czarski, Shakeeb Rahman, Martin Nielsen, Robert Johannesson
1520-1600 Robert Johannesson, SoftBASE:  APEX 18.1 Enterprise deployment – a user case/demo

Abstracts

APEX 18.1 and beyond: What’s new?

Oracle Application Express 18.1 focuses on declaratively integrating data sources from remote databases and extending applications running on the cloud via REST. A new Create Application Wizard enables you to add components and features to new and existing applications. Upgrading to the latest Oracle JET and jQuery JavaScript libraries will further allow APEX to take advantage of new and improved data visualizations and widgets. In this session, we will show those new capabilities and show some of the numerous enhancements to JET Charts and the Interactive Grid.

The most amazing Universal Theme yet

The Universal Theme aims to empower developers with the tools they need to build beautiful, responsive, accessible apps without becoming experts in HTML, CSS or JavaScript. This session will introduce you to some of the improvements and updates to Universal Theme in APEX 18.1, including Font APEX 2, Floating Labels and the numerous enhancements for building Mobile User Experiences to name a few. Learn how you can take full advantage of the capabilities in Universal Theme to build compelling user experiences for any device, and why the latest release of APEX contains the most amazing version of the Universal Theme yet.

APEX and the REST of the world: Deep Dive

This talk will focus on the new REST capabilities in Application 18.1: The audience will learn how to use advanced configurations like joining REST data to a local table or computing derived columns based on REST data. Also, the talk will highlight how to programmatically access Web Source Modules using PL/SQL, e.g. to create a database job to load data from a REST service on a regular schedule. A few tips and tricks will round the session up.

Building Big Things for Small Screens

The Universal Theme in APEX 18.1 will see a number of enhancements targeted at developers building responsive apps that are well suited for mobile and small-screen devices. In this session, we will discuss transitioning from jQuery Mobile apps to Universal Theme, explore some of the new mobile-focused features such as touch gestures, and learn how to approach mobile app development for your future projects. This session will be tactical, with live demos, tips, and tricks you can use to build great small-screen experiences.

APEX 18.1 Enterprise deployment – a user case/demo

The presentation will demo a Salesman application accessing ERP Data, developed in APEX Universal Theme (UT) Version 18.1 It will show the powerful GUI on both Desktop and on Mobile device (Tablet).

We will present the functionality of the App, but at the same time present the Enterprise level features, which make up the usage of APEX application, both as single application or a combination of more APEX applications.

The features include:

  • Authentication/Authorisation
  • User GUI
  • Navigation Bar features:
  • REST Service Integration

We will also show the mashup application 1220, which combines the usage of Forms and APEX functionalities.