WSO2 Data Services Server - 100% Open Source Data Management

WSO2 Data Services Server (WSO2 DSS) was created as a mechanism to integrate data stores, create composite data views, and host data services. We currently have this capability within WSO2 Enterprise Integrator (WSO2 EI). WSO2 EI allows you to make enterprise data accessible by integrating cloud services and legacy software, and data stores, as well as transforming data seamlessly across different formats and transports with enterprise service bus and data services capabilities. Try it now!

WSO2 Data Services Server augments service-oriented architecture development efforts by providing an easy-to-use platform for integrating data stores, creating composite data views, and hosting data services. It supports secure and managed data access across federated data stores, data service transactions, and data transformation and validation using a lightweight, developer friendly, agile development approach. It provides federation support, combining data from multiple sources in single response or resource and also supports nested queries across data sources.


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