Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Customer Support
• Review Patch Documentation
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Help Center (docs.oracle.com)
• Conventions

1 Introduction

• What is DDS?
• Need for DDS
• Functionality Offered
• Accessibility

2 Installation Prerequisites

• Installation and Setup Instructions
  • Prerequisites
• Installing WebLogic
• Creating the Required Schema Using Repository Creation Utility
• Creating a WebLogic Domain with JRF

3 Deploying DDS Web Application

• Preparing the Database for DDS Installation
• Deploying DDS Web Application on the WebLogic Servers
• Redeploying DDS Web Application
• Testing the Deployment

4 Security

• Access Levels
• Table Level Security
• Column Level Security
• Row Level Security
• Security Setup
• System Options

5 RESTful Services

• Discover
• Get Data
• Get Data from a Table
• Insert Data
• Update Data
• Delete Data
• Get Schemas
• Get Tables
• Get Columns for a Table
• Get System Options
• Create System Options
• Update System Options
• Delete System Options
• Reset Cache

6 Security RESTful Services

• Get Security Groups
• Get Security Group Permissions
• Get Access Levels
• Get Security Config for a Schema
• Get All Security Config
• Get All Table Level Securities
• Get Table Level Security for Table
• Get Table Level Security for Table and Group
• Get Column Level Security for Table and Group
• Get Row Level Security for Table and Group
• Create Access Level
• Update Access Level
• Delete Access Level
• Create Table Level Security
• Create Table Level Securities
• Update Table Level Security
• Update Table Level Securities
• Delete Table Level Security
• Delete Table Level Security by Id
• Delete Table Level Securities by Type
• Create Column Level Security
• Update Column Level Security
• Delete Column Level Security
• Create Data Security Configuration
• Update Data Security Configuration
• Delete Data Security Configuration
• Create Security Group
• Delete Security Group
• Create Row Level Security
• Update Row Level Security
• Delete Row Level Security
• Create Default Security Setup

7 User Interface

• Admin Tab Guide
  • Initial Permissions Setup
  • Manage Access Levels
  • Manage Security Groups
  • Manage Security Permissions
• Designer Tab Guide
  • Table Definition
  • Query Builder

8 Advanced Backend Features

• LIKE Statement
• IN Statement
• Comparative Operators
• Filtering DATE Column
• Combinations of OR, AND & BETWEEN Statements
• Viewing Clob Data
• Viewing Query Response as JSON Data
• JOINing Two or More Tables