Samples Tutorial

     Previous  Next    Contents    View as PDF - New Window  Get Adobe Reader - New Window
Content starts here

About This Document

Document Organization

Technical Prerequisites

System Requirements

Data Sources Used Within These Tutorials

Related Information

Core (Tutorials 1-17)

Data Services Platform Development Process

Advanced (Tutorials 18-35)

Introducing the Data Services Environment

1.1 Starting WebLogic Workshop

1.2 Navigating the ALDSP Integrated Development Environment (IDE)

Application Pane

Design View

XQuery Editor View

XQuery Editor View Tools

Source View

Test View

1.3 Starting WebLogic Server

1.4 Stopping WebLogic Server

1.5 Saving Your Work

Creating a Physical Data Service

2.1 Creating an ALDSP Application

2.2 Creating a Data Services Project

2.3 Creating Project Sub-Folders

2.4 Importing Relational Source Metadata

2.5 Building a Project

2.6 Viewing Physical Data Service Information

Viewing XML type

Viewing Native Data Type


Viewing XML Schema Definition


Viewing Generated Functions


Viewing Data Service Metadata


2.7 Testing Physical Data Service Functions

Creating a Logical Data Service

3.1 Creating a Simple Logical Data Service

3.2 Defining the Logical Data Service Shape

3.3 Adding a Function to a Logical Data Service

3.4 Mapping Source and Target Elements

3.5 Viewing XQuery Source Code

3.6 Testing a Logical Data Service Function


Integrating Data from Multiple Data Sources

4.1 Joining Multiple Physical Data Services within a Logical Data Service

4.2 Defining a Where Clause to Join Multiple Physical Data Services

4.3 Creating a Parameterized Function

Modeling Data Services

5.1 Creating a Basic Model Diagram for Physical Data Services

5.2 Modeling Relationships Between Physical Data Sources

Accessing Data Services

6.1 Importing a Web Service Project into the Application

6.2 Importing Web Service Metadata into a Project

6.3 Testing the Web Service via a SOAP Request

6.4 Invoking a Web Service in a Data Service

Consuming Data Services Using Java

7.1 Running a Java Program Using the Untyped Mediator API

7.2 Running a Java Program Using the Typed Mediator API

7.3 Resetting the Mediator API

Consuming Data Services using Data Service Controls

8.1 Installing a Data Service Control

8.2 Defining the Data Service Control

8.3 Inserting a Data Service Control into a Page Flow

8.4 Running the Web Application

Accessing Data Services Through Web Services

9.1 Generating a Web Service from a Data Service Control

9.2 Using a Data Service Control to Generate a WSDL for a Web Service

Updating Data Services Using Java

10.1 Modifying and Saving Changes to the Underlying Data Source

10.2 Inserting New Data to the Underlying Data Source Using Java

10.3 Deleting Data from the Underlying Data Source Using Java

Filtering, Sorting, and Truncating XML Data

11.1 Filtering Data Service Results

11.2 Sorting Data Service Results

11.3 Truncating Data Service Results

Consuming Data Services through JDBC/SQL

12.1 Running DBVisualizer

12.2 Integrating Crystal Reports and Data Services Platform

12.3 (Optional) Configuring JDBC Access through Crystal Reports

Consuming Data via Streaming API

13.1 Stream results into a flat file

13.2 Consume data in streaming fashion

Managing Data Service Metadata

14.1 Defining Customized Metadata for a Logical Data Service

14.2 Viewing Data Service Metadata Using the ALDSP Console

14.3 Synching a Data Service with Underlying Data Source Tables

Managing Data Service Caching

15.1 Determining the Non-Cache Query Execution Time

15.2 Configuring a Caching Policy Through the ALDSP Console

15.3 Testing the Caching Policy

15.4 Determining Performance Impact of the Caching Policy

15.5 Disable Caching

Managing Data Service Security

16.1 Creating New User Accounts

16.2 Setting Application-Level Security

16.3 Granting User Access to Read Functions

16.4 Granting User Access to Write Functions

16.5 Setting Element-Level Data Security

16.6 Testing Element-Level Security

(Optional) Consuming Data Services through Portals & Business Processes

17.1 Installing a Data Service Control in a Portal Project

17.2 Testing the Control and Retrieving Data

Building XQueries in XQuery Editor View

18.1 Importing Schemas for Query Development

18.2 Creating Source-to-Target Mappings

18.3 Creating a Basic Parameterized Function

18.4: Creating a String Function with a Built-In XQuery Function

18.5: Creating a Date Function

18.6: Creating Outer Joins and Order By Expressions

18.7: Creating Group By and Aggregate Expressions

18.8: Creating Constant Expressions

Building XQueries in Source View

Source View Tools

19.1 Creating a New XML Type

19.2 Creating a Basic Parameterized XQuery

XQuery Code Reference for a Parameterized Function

19.3 Creating a String Function

XQuery Code Reference for a String Function

19.4 Building an Outer Join and Using Order By

XQuery Code Reference for an Outer Join and Order By Function

19.5 Creating an Inner Join and a Top N

XQuery Code Reference for Inner Join and Top N Function

19.6 Creating a Multi-Level Group By

XQuery Code Reference for Multi-Level Group By Function

19.7 Using If-Then-Else If

XQuery Code Reference for If-Then-Else Function

19.8 Creating a Union and Concatenation

XQuery Reference Code for Union and Concatenation Operation

Implementing Relationship Functions and Logical Modeling

20.1 Implementing and Testing a Relationship Function

20.2 Creating a Model Diagram for Logical Data Services

Running Ad Hoc Queries

21.1 Creating an Instance of the PreparedExpression Class

21.2 Defining Ad Hoc Query Parameters

21.3 Testing the Ad Hoc Query

Code Reference for an Ad Hoc Query

Creating Data Services Based on SQL Statements

22.1 Creating a Data Service from a User-Defined SQL Statement

22.2 Testing Your SQL Data Service

Performing Custom Data Manipulation Using Update Override

23.2 Creating an Update Override

23.3 Associating an Update Override to a Logical Data Service

23.4 Testing the Update Override

Updating Web Services Using Update Override

24.1 Creating an Update Override for a Physical Data Service

24.2 Writing Web Service Update Logic in the Update Override

24.3 Testing the Update Override

24.4 Checking for Change Requirements

Overriding SQL Updates Using Update Overrides

25.1 Adding SQL Update Statements to an Update Override File

25.2 Associating an SQL-Based Data Service and Update Override

25.3 Testing Updates

Understanding Query Plans

26.1 Viewing the Query Plan

26.2 Locating the SQL Statement in a Query Plan

26.3 Locating XML Elements

Reusing XQuery Code through Vertical View Unfolding

27.1 Unfolding Vertical View

27.2 Testing a Vertical File Unfolding

Configuring Alternatives for Unavailable Data Sources

28.1 Setting the Demonstration Conditions

28.2 Configuring Alternative Sources

28.3 Testing an Alternative Source

Enabling Fine Grained Caching

29.1 Enabling Function-Level Caching for a Physical Data Service

29.2 Testing the Caching Policy

29.3 Testing Performance Impact

CreatingXQueryFilters to Implement Conditional Logic Security

30.1 Creating User Groups

30.2 Writing the XQuery Security Function

30.3 Activating the XQuery Function for Security

30.4 Testing the XQuery Security Function

Creating Data Services from Stored Procedures

Handling Stored Procedure Row Sets

31.1 Importing a Stored Procedure into the Application

31.2 Importing Stored Procedure Metadata into a Data Service

Creating Data Services from Java Functions

32.1 Accessing Data Using WebLogic's Embedded LDAP Function

32.2 Accessing Excel Spreadsheet Data Using JCOM

32.3 (Optional) Accessing Data Using an Enterprise Java Bean

Creating Data Services from XML Files

33.1 Importing XML Metadata and XML Schema Definition


33.2 Testing the XML Data Service

Creating Data Services from Flat Files

34.1 Importing Flat File Metadata

34.2 Testing Your Flat File Data Service

34.3 Integrating Flat File Valuation with a Logical Data Service

34.4 Testing an Integrated Flat File Data Service

Creating an XQuery Function Library

35.1 Creating an XQuery Function Library

35.2 Using the XQuery Function Library in an XQuery


  Back to Top       Previous  Next