Enterprise Integration for Beginners

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. This blog post is written to help users to getting started with WSO2 DSS with writing a data service to execute a stored procedure which is defined in a database. Prerequisites Before starting the implementation, you need the following things to be downloaded and installed. 1. Download WSO2 Data Services Server and install. 2. Download mysql server and install. Once you have installed both WSO2 DSS and mysql in your enviornment, you can proceed to the next step. Creating the stored procedure in mysql 1. Connect to mysql server with the following command. mysql -u root -p Enter password: 2. Create a sample databasae. DROP DATABASE IF EXISTS ESB_SP_SAMPLE; CREATE DATABASE ESB_SP_SAMPLE; 3. Create a table using the following statement. USE

Business Requirement Today, your business is all about working with information. If you are a business owner and if you need to grow your business, best way is to make it accessible over the internet. When your business grows, it can be thousands, millions or even billions of people interacting with your business every second. If you think about online stores like ebay, amazon or google play, they need to process millions of messages per second. When a customer interact with such a system, that information need to saved in somewhere (ex:database). This can be illustrated as below. In the above figure, Client interacting with a web browser and access your system which is implemented as a web service which is hosted somewhere in the internet. At a given moment, there can be any number of parallel users accessing your business. To handle each and every request from the customers, you need to have a robust, reliable messaging system. How WSO2 can serve your requirement? WSO2