Skip to Main Content

APEX Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

July 28, 2022

14:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.

Description

APEX 22.1, ORDS and the MySQL Database Service
APEX 22.1 is the first APEX release that supports building Applications directly based on the MySQL Database Service in Oracle Cloud Infrastructure. Leveraging ORDS "REST Enabled SQL" functionality, APEX components can visualize data directly from the MySQL database.

In this Office Hours session, Carsten Czarski showed how to set up a connection to a MySQL Database Service within APEX and how to build an application, using tables, views or SQL Queries being executed in the MySQL database. Learn how to create a Catalog of REST Data Sources, each executing a SQL Query in the MySQL Database Service and how to synchronize data to the APEX schema.

How to set up a MySQL Connection in OCI by Peter O'Briens:
https://peterobrien.blog/2022/06/20/how-to-use-the-oracle-database-tools-service -to-provide-mysql-data-to-apex/

Your Experts

  • #SELECTION#
    Marc Sewtz

    Marc Sewtz   

    Marc Sewtz is a Senior Software Development Manager at Oracle Corporation in New York City. With over 20 years of industry experience, Marc held roles in Consulting, Sales and Product Development. Today he manages a global team of Software Developers and Product Managers working on the development of Oracle Application Express (APEX), Oracle's premier Low Code development platform for building responsive applications on Oracle Database. Marc frequently presents at international conferences, such as Oracle Open World, ODTUG Kscope, UKOUG, DOAG, APEX Connect, and Oracle Code. Marc has a Master's degree in Computer Science from the University of Applied Sciences in Wedel, Germany.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chaitanya Koratamaddi

    Chaitanya Koratamaddi   

    Chaitanya Koratamaddi is a Senior Principal Product Manager for Oracle APEX and is responsible for all Product Management activities of Oracle APEX including APEX on Autonomous and APEX Service. Chaitanya is on a mission to ensure customers embrace and utilize the full potential of low code application development with Oracle APEX. Chaitanya is a regular speaker at various global conferences. You can gain insights into what Chaitanya is up to by following @chaitanya_in on Twitter.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Mónica Godoy

    Mónica Godoy   

    Mónica Godoy is a Principal Product Manager for Oracle APEX since 2019. Before she joined the APEX Team, she worked as an Oracle APEX Consultant, modernizing Oracle Forms apps and developing new applications with Oracle APEX. Mónica also encourages women to be part of the APEX Community at www.womeninapex.com.
    #MISC#
    #ACTIONS#