Enterprise Integration for Beginners

Database technologies are growing at a somewhat slower rate than other technology areas. But still, it is a major component of any enterprise software architecture. Due to the lack of innovation in the user experience side of the database technologies and the amount of “fear” people having when exposing databases to the end users have put the databases into a corner within the enterprise software systems. If you need to access a particular data set from a database table, you need to go through several layers and go after DB admins to get your work done. Databases have become the “precious” things in the enterprise. But do you need to be that way forever? The below medium post explains how databases can be exposes through a managed API which will democratize the database access within your enterprise. https://medium.com/wso2-learning/how-to-expose-your-database-as-a-managed-api-with-wso2-in-10-minutes-c9ac2595738b

WSO2 Carbon based products require some databases to be created for operation. Every WSO2 product comes with a folder named dbscripts (CARBON_HOME/dbscripts) and that folder contains database scripts for different types of databases. These scripts creates 3 set of tables by default. 1) Registry tables -These are related to registry artifacts of the WSO2 product.  2) User management tables – These tables are related to user management of the server. All the user permissions and roles related information will be saved in these tables. By default these are created in internal H2 database. ( We can create a separate database schema for this if we want) 3) User Store tables – These tables are related to creating actual users which are create in the server. These tables will not be used if we have pointed to external LDAP user store. From the above 3 set of tables, we will only need to focus on user management tables since we have created other tables in external LDAP and data...

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 ...

WSO2 ESB is a lean but powerful mediation engine that would help you to run your businesses in the best shape. With this blog post I am going to point you to the best resources that you could find in the internet for learning about WSO2 ESB. Getting started with WSO2 ESB Here is a video tutorial about getting started with WSO2 ESB done by Kasun Indrasiri.  http://kasunpanorama.blogspot.com/2012/04/getting-started-with-wso2-esb.html?view=sidebar Here is an article written by Kasun Indrasiri about using WSO2 ESB in a real world scenario http://wso2.com/library/articles/2012/11/enterprise-service-integration-wso2-esb Learn more about WSO2 ESB and its features Here is a set of blog posts written by Hiranya Jayathilake about ESB tips and tricks. http://techfeast-hiranya.blogspot.com/2009/11/wso2-esb-tips-tricks-01-sequences-and.html http://techfeast-hiranya.blogspot.com/2009/11/wso2-esb-tips-tricks-02-content-based.html http://techfeast-hiranya...