Dr. Dobb's is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Channels ▼

Open Source

WSO2 Releases Database Tool

WSO2 has announced its WSO2 Data Services, a tool which lets database administrators expose data via a Web services API without programming. With WSO2 Data Services, DBAs and database programmers can contribute to an organization's Service-Oriented Architecture (SOA) by creating WS-* style Web services and REST-style Web resources based on enterprise data. The WSO2 Data Services approach lets users enter queries and map them into services and operations. The UI lets anyone with a knowledge of the SQL create powerful data services. Once the query or stored procedure has been exposed as a service, it can be accessed across the network as a service or Web resource.

In its initial release, WSO2 Data Services supports access to data stored in relational databases such as Oracle, MySQL and IBM DB2 (virtually any database accessible via JDBC), as well as the comma-separated values (CSV) file format, and Excel spreadsheets. Services can be authenticated, encrypted and/or signed using the WS-Security and HTTP security standards, and the console includes a full security management capability. In addition, support for the WS-ReliableMessaging standard provides enterprise-level reliability.

The standalone WSO2 Data Services solution builds on the proven performance of the data services functionality within the WSO2 Web Services Application Server (WSAS) 2.0. WSO2 Data Services is based on the Apache Axis2 toolkit. Key features of the product include:

  • Data aggregation: administrators can create services that aggregate data from multiple data sources, in order to offer cleanly defined services to other departments and hide internal database details.
  • Wizards for easy configuration: users can create and modify a service using either the graphical Web-based wizard or Eclipse plug-in wizard.
  • XML configuration file format: XML is a familiar tool to both DBAs and programmers, and this allows service creation to be automated.
  • Try-it tool: with the click of a button, the utility lets users test the data services they have created within the Data Services console.
  • Customizable XML output: response data can be tailored as needed.
  • Dual REST and WS-* support: REST resources access data using a unique URL for each record; WS-* services use typical Web service access to expose data.
  • Built-in connection pooling support: the ability to establish a pool of reusable connections saves time and compute resources.
  • Support for stored procedures and functions: it only takes a few mouse clicks to expose the stored procedures and functions that speed database operations as Web services.
  • Built-in caching: cached responses to queries eliminate the system overhead of repeatedly returning the same XML response to clients.
  • Throttling: IT professionals can prevent databases from being overloaded through rate-based throttling, which limits number of the service calls in a given time period, and concurrency-based throttling, which limits the number of simultaneous calls for a service.

"There is significant demand among enterprises for an efficient and effective way to unlock data from a wide variety of sources, and expose this data as Web services for use within SOAs," said Dr. Sanjiva Weerawarana, CEO of WSO2. "Our new WSO2 Data Services solution further democratizes SOA by providing a flexible product that anyone with fundamental data management knowledge can use immediately out of the box."

Related Reading

More Insights

Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.