Data Services Server

WSO2 Data Services Server

Behind most application silos are heterogeneous and disparate data stores.The WSO2 Data Services Server augments Service Oriented Architecture (SOA) development efforts by providing an easy to use platform for integrating data stores, creating composite data views, and hosting data services.

Data services provide unprecedented data access and straightforward integration with business processes, mashups, gadgets, business intelligence and mobile applications. The WSO2 Data Services Server 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.

Features

Expose Any Source of Data as Web Services or REST Resources

  • Supported data sources: Any RDBMS, CSV, Excel, ODS, Cassandra, Google Spreadsheets, RDF, Any Web page via scraping
  • Supported data bases: 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
WSO2Con

Case Studies

Analyst Reports

White Papers

Customers