Advanced Data Services
Course Summary:
WSO2 Data Services allows you to bring data locked away in relational databases to the Web and make Web services out of them. This 3-hour course is designed to give a detailed understanding on how to use Data Services for your SOA data access needs. We will start off with a simple example and go on to demonstrate the advanced options.
Course Objectives:
- Understand Data Service concepts
- How to tackle advance scenarios with data services
Duration:
- 3 hours
Audience:
- Developers interested in getting to know the advanced configuration options available with data services and the WSO2 Web Services Application Server (WSAS)
Prerequisites:
- Understanding of Web Service concepts and hands on experience
- Brief understanding of Data services (not mandatory)
Program:
- Course outline and objectives
- Brief introduction to Data Services
- Hands on
- Introduction to hands on environment
- RDBMS
- Exposing a single database table as a service
- How to test your service without leaving the WSAS console
- Dynamically changing the queries and hot update
- Invoking the service using URL (SOAP HTTP Bindings)
- Parameterizing the service
- Joining multiple tables
- Using nested queries
- CRUD operation support
- How to enable connection pooling
- Connecting to a data source bound to a JNDI name
- Using WSDL2Java to generate a Stub
- Accessing data services using a Java client
- Accessing stored procedures and functions
- Creating a data service using a CSV file
- Creating a data service using MS Excel (97-2003) file
- How to secure your service using WS-Security module
- How to access throttle your service
- How to enable request caching
- Q&A