database | PaaS Community Blog

Store, connect & govern your enterprise data for your AI Agents – Oracle 23AI book by Asim Chowdhury

February 5, 2026 Leave a comment

Oracle 23AI ADBS in Action is a definitive guide to the AI-native database, demonstrating how enterprise data can be transformed into an intelligent, conversational automation fabric. The book shows how Oracle 23AI elevates the data layer into a smart foundation for AI-driven business processes. Building on this core, Oracle Integration seamlessly connects Oracle 23AI with AI agents and automation workflows, enabling secure, event-driven orchestration while maintaining human oversight through approvals, policy enforcement, and auditable decision paths. Through hands-on QuickMart case studies, advanced capabilities—including vector search, JSON duality views, autonomous optimizations, and in-database machine learning—are translated into practical, real-world implementations. The result is an end-to-end, actionable blueprint for DBAs, developers, and data scientists to build high-performance, compliant, and truly intelligent data platforms on Oracle 23AI.

Oracle 23AI & ADBS in Action: Exploring New Features with Hands-On Case Studies

Unlock the power of Oracle Database 23AI and Autonomous Database Serverless (ADB-S) with this comprehensive guide to the latest innovations in performance, security, automation, and AI-driven optimization. As enterprises embrace intelligent and autonomous data platforms, understanding these capabilities is essential for data architects, developers, and DBAs.

Explore cutting-edge features such as vector data types and AI-powered vector search, revolutionizing data retrieval in modern AI applications. Learn how schema privileges and the DB_DEVELOPER_ROLE simplify access control in multi-tenant environments. Dive into advanced auditing, SQL Firewall, and data integrity constraints to strengthen security and compliance.

Discover AI-driven advancements like machine learning-based query execution, customer retention prediction, and AI-powered query tuning. Additional chapters cover innovations in JSON, XML, JSON-Relational Duality Views, new indexing techniques, SQL property graphs, materialized views, partitioning, lock-free transactions, JavaScript stored procedures, blockchain tables, and automated bigfile tablespace shrinking.

What sets this book apart is its practical focus—each chapter includes real-world case studies and executable scripts, enabling professionals to implement these features effectively in enterprise environments. Whether you’re optimizing performance or aligning IT with business goals, this guide is your key to building scalable, secure, and AI-powered solutions with Oracle 23AI and ADB-S.

What You Will Learn

Explore Oracle 23AI’s latest features through real-world use cases
Implement AI/ML-driven optimizations for smarter, autonomous database performance
Gain hands-on experience with executable scripts and practical coding examples
Strengthen security and compliance using advanced auditing, SQL Firewall, and blockchain tables
Master high-performance techniques for query tuning, in-memory processing, and scalability
Revolutionize data access with AI-powered vector search in modern AI workloads
Simplify user access in multi-tenant environments using schema privileges and DB_DEVELOPER_ROLE
Model and query complex data using JSON-Relational Duality Views and SQL property graphs

Who this Book is For

Database architects, data engineers, Oracle developers, and IT professionals seeking to leverage Oracle 23AI’s latest features for real-world applications

Get the book here. For additional integration books please visit the wiki here.

Filed under Uncategorized Tagged with ai, artificial-intelligence, books, database, llm, oracle

E-Business Suite Integration with Integration Cloud Service and DB Adapter by Ulrich Janke

October 28, 2016 Leave a comment

Introduction

Integration Cloud Service (ICS) is an Oracle offering for a Platform-as-a-Service (PaaS) to implement message-driven integration scenarios. This article will introduce into the use of ICS for integrating an on-premise E-Business Suite (EBS) instance via Database Adapter. While EBS in recent releases offers a broad set of integration features like SOAP and REST support (i.e. via Integrated SOA Gateway), these interfaces are not available in older versions like 11.5.x. In the past it has been a proven approach to use Oracle Fusion Middleware Integration products (SOA, OSB etc.) running on-premise in a customer data center to connect to an EBS database via DB Adapter. In a short time this feature will be available also in a cloud based integration solution as we will discuss in this article.

Unless we focus on EBS integration here the DB Adapter in ICS will work similarly against any other custom database. Main reason to use an EBS context is the business case shown below, where ICS is connected to Mobile Cloud Service (MCS) to provide a mobile device solution.

Business Case and Architecture

Not hard to imagine that Oracle customers running EBS 11.5.x might have a demand to add a mobile channel for their end-users. One option could be an upgrade to a recent release of EBS. As this will be in most cases a bigger project, an alternative could be the creation of a custom mobile solution via Oracle Jet and MCS as figured below. MCS is a PaaS offering and requires access to an underlying database via REST/JSON. This is the situation where ICS appears in this architecture.

In absence of native SOAP or REST capabilities being available in EBS 11.5.x tech stack, the integration via ICS would close that gap. Any database access activities (retrieving data, CRUD operations etc.) can run via an ICS/DB Adapter connection to an EBS on-premise database. ICS itself will provide a REST/JSON interface for the external interaction with EBS. This external interface is generic and not restricted to MCS as caller at all. However in our business case the ICS with DB Adapter fulfills the role of a data access layer for a mobile solution. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Facebook Wiki