Skip to Main Content
Connect Oracle Agent Factory to Oracle APEX

About This Workshop

Youtube Video

About This Workshop
This LiveLabs workshop walks learners through the complete end-to-end process of connecting Oracle AI Database Private Agent Factory (PAF) to Oracle APEX using OCI API Gateway, APEX Web Credentials, and PL/SQL. Learners begin by publishing a working agent in Agent Factory, capturing the integration endpoint, and understanding the two core challenges in the integration: the browser-based session cookie required by PAF and the private-network, self-signed SSL setup that prevents a straightforward direct call from APEX. The workshop then shows how OCI API Gateway can be configured as the bridge between APEX and the private backend, including the required login and agent routes and the SSL verification settings needed for this pattern to work.

After the gateway is in place, learners move into Oracle APEX and implement the full server-side integration flow. They create secure Web Credentials for storing login information, build PL/SQL logic to fetch a fresh agent_factory_session cookie automatically, initialize a room for the conversation, and send user messages to the published agent through the gateway. They also learn how to parse NDJSON responses returned by the service and return those responses cleanly back into the APEX application. By the end of the workshop, participants will have a practical, production-oriented blueprint for integrating Oracle Agent Factory with Oracle APEX without relying on manual cookie copy-paste steps, while also understanding the architectural decisions, security considerations, and operational flow behind the solution. The workshop concludes with a knowledge-check lab to reinforce the concepts and implementation details.

Workshop Info

4 hours
  • Introduction: Overview of the use case, architecture, and workshop goals
  • Lab 1: Build and publish your Oracle Agent Factory agent, then capture the integration endpoint
  • Lab 2: Understand authentication, session-cookie handling, and the connectivity constraints involved in the integration
  • Lab 3: Configure OCI API Gateway as the secure bridge between Oracle APEX and the private PAF backend
  • Lab 4: Create APEX Web Credentials and initialize the chat session using PL/SQL
  • Lab 5: Send messages from Oracle APEX, refresh the session automatically, and parse NDJSON responses
  • Lab 6: Complete a knowledge-check quiz to reinforce the implementation pattern and key concepts
  • Basic familiarity with Oracle APEX and PL/SQL is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI), especially API Gateway and basic networking concepts, is helpful
  • A general understanding of HTTP APIs, JSON, and web application integration patterns is useful
  • Access to Oracle AI Database Private Agent Factory, OCI API Gateway, and an Oracle APEX workspace backed by Autonomous Database is recommended for full hands-on completion

Other Workshops you might like

Other Workshops you might like Cards