All Articles

Tag: Integration

6 articles found

Native JSON Processing in PL/SQL: The Modern Oracle Guide
Integrations
20 min read

Native JSON Processing in PL/SQL: The Modern Oracle Guide

Learn how to natively parse, generate, and query JSON data directly inside Oracle PL/SQL. Master JSON_OBJECT, JSON_ARRAY, JSON_TABLE, and dot-notation for modern REST API integrations.

Read Article
PL/SQL Masterclass: Building REST APIs in PL/SQL (ORDS)
Integration Guide
25 min read

PL/SQL Masterclass: Building REST APIs in PL/SQL (ORDS)

Turn your Oracle Database into a modern web server. Learn how to use Oracle REST Data Services (ORDS) to expose PL/SQL procedures as secure, JSON-based RESTful APIs.

Read Article
SQL Masterclass: JSON & XML Processing in Oracle
Integration Guide
22 min read

SQL Masterclass: JSON & XML Processing in Oracle

Learn how to natively generate, parse, and query JSON and XML payloads directly within Oracle SQL without needing a middle-tier application.

Read Article
Building Custom APIs on Top of Oracle RMS
Phase 9
9 min read

Building Custom APIs on Top of Oracle RMS

Patterns and anti-patterns for exposing Oracle RMS data to modern web and mobile applications using REST APIs and ORDS.

Read Article
Writing Custom Validation Frameworks in PL/SQL
Phase 8
12 min read

Writing Custom Validation Frameworks in PL/SQL

How to build robust validation engines for your RMS staging tables using PL/SQL bulk processing and FORALL loops.

Read Article
The Foundation Data Layer (FDL) in Oracle RMS: Extract Types, Downstream Consumers & ODI Integration
Phase 8
18 min read

The Foundation Data Layer (FDL) in Oracle RMS: Extract Types, Downstream Consumers & ODI Integration

A comprehensive guide to the RMS Foundation Data Layer (FDL). Learn how FDL extracts transform OLTP data into flat files for downstream systems, the difference between full and delta extracts, FDL_ITEM and FDL_ITEM_LOC table schemas, ODI integration patterns, and BDI in cloud deployments.

Read Article
RetailCoder
All systems operational
v1.0 Live

RC:OMS

Multi-channel order management with double-entry inventory ledger. Amazon, Flipkart, Shopify, WooCommerce — one source of truth.

Launch demo →
v1.0 Live

RC:Storefront

Self-hosted headless e-commerce. Your server, your data, zero transaction fees. Native RC:OMS inventory sync.

Visit Storefront →
Pipeline

RC:Pulse

AI-powered retail analytics and demand forecasting — built natively on top of your RC:OMS and Storefront data.

Request early access →
Built in India 🇮🇳  ·  Architected by Priyanshu PandeyTalk to an engineer →