Expose Any Source of Data as Web Services or REST Resources

• Supports any RDBMS, CSV, Excel, ODS, Cassandra, Google Spreadsheets, RDF, and any Web page
• Supports OData v4 protocol for any RDBMS and Cassandra data sources
• Supported databases: MSSQL, DB2, Oracle, OpenEdge, TerraData, MySQL, PostgreSQL/EnterpriseDB, H2, Derby or any database with a JDBC driver
• Supported transports: HTTP, HTTPS, JMS, SMTP, and others including (via WSO2 Enterprise Service Bus) FTP, FTPS, SFTP and TCP

Agile Development Approach

• Declarative programming model for defining services & resources
• XML based DSL with no Java code to be written

Federation Support

• Combine data from multiple data sources in single response or resource
• Support for nested queries across data sources

RESTful Data Access

• Create collection of REST resources for CRUD operations
• Support for both JSON and XML media types
• Secure resources with HTTP(S) Basic Auth integrated to enterprise identity systems (via WSO2 Identity Server)

Secured and Managed Data Access

• Authentication, authorization, confidentiality, integrity and encryption with HTTP(S) Basic Auth, WS-Security, WS-Trust, WS-SecureConversation, WS-Policy, WS-PolicyAttachment and WS-SecurityPolicy
• Fine-grained authorization with XACML (via integration to WSO2 Enterprise Service Bus)
• Flexible throttling for access frequency, source IP and more via policies
• Convenient WS-SecurityPolicy configuration for common security patterns
• Comprehensive user management including LDAP via integration to WSO2 Identity Server

Transactional Data Access and Services

• Distributed transactions via JMS
• Transactions spanning different data sources

Data Transformation and Validation

• Transform via XSLT and XQuery
• Built-in validators for standard data types
• Customizable validators via Java extensions
• Schema validation via integration with WSO2 Enterprise Service Bus

High Performance, High Availability, Scalability & Stability

• 100% streaming for dealing with large data volumes
• Extremely low latency for data access
• Distributed response caching for minimizing database access
• Supports highly available deployment
• Horizontal scaling via clustering with stateless server architecture
• Long term execution stability with low resource utilization

Lightweight, Developer Friendly and Easy to Deploy

• Declarative development with configuration instead of code
• Wizards for easy editing of data service & resource configurations
• Tool for automatic generation of CRUD operations/resources against existing database schemas
• Flexible mapping of query responses to custom XML data formats
• Easy to debug services with tools for message tracing and interactive testing with TryIt capabilities
• Automatic generation of WSDLs for services and service stubs
• Server customization via feature provisioning of any WSO2 middleware capability
• Choice of deployment to on-premise servers, private cloud or public cloud (WSO2 StratosLive Data as a Service)
• Integrated with SVN, Maven, Ant and other standard tools for development & deployment
• Integrated to WSO2 Developer Studio, Eclipse-based IDE for all WSO2 products

Manage & Monitor

• Comprehensive management & monitoring Web console with enterprise-level security
• Built-in collection and monitoring of standard access and performance statistics
• JMX MBeans for key metrics monitoring and management
• Integrates with WSO2 Business Activity Monitor for operational audit and KPI monitoring and management
• Flexible logging support with integration to enterprise logging systems
• Centralized configuration management across different environments with lifecycles and versioning via integration to WSO2 Governance Registry