MuleSoft is one of the popular integration platforms with its sophisticated ESB and API management offering and a great set of feature-rich tools for design development, testing, deployment, management and monitoring of Mule Applications and APIs to integrate diverse systems and applications.

MuleSoft provides AnyPoint studio which is an Eclipse based IDE to design and develop message flows as Mule Applications with dozens of ready to use connectors for enabling integration between different types of applications and systems in a seamless manner.

In this tutorial, I will explain how we can create a Mule Application using Anypoint Studio and query data from Oracle database and return this data in JSON format back to the client as a response to a REST web service.

MuleSoft Beginners Video Tutorial: Query Data from Oracle Database and Return in JSON Format

In order to explain the power of MuleSoft for integrating with Oracle database and retrieving data from the tables and returning it to the client, I have created below video tutorial on YouTube channel of TutorialsPedia, where following use case has been implemented focusing on the beginners and keeping the implementation as simple as possible without involving any advanced concepts or features:

Use Case Implemented for MuleSoft Database tutorial

User Management Scenario is Implemented as part of this video tutorial with details as below:

• A MuleSoft Application is created using AnyPoint Studio containing Message Flow to Fetch Users from Oracle Database.
• Client will be able to invoke a REST service and query for any particular user from a Users table in Oracle Database.
  • For this purpose, client will provide a query parameter in GET operation of the exposed REST web service.
• Data returned to client will be in JSON format.

Watch complete MuleSoft video Tutorial for this use case below on YouTub Channel of TutorialsPedia and don’t forget to subscribe to the channel to get more videos as part of this video tutorials series:

Feel free to comment below the video if you have any further help needed.

Ajmal Abbasi

Ajmal Hussain Abbasi is Integration Consultant By Profession with 13+ years experience in Integration domain mainly with TIBCO products. He has extensive practical knowledge of TIBCO Business Works, TIBCO Cloud, TIBCO Flogo, TIBCO Mashery, TIBCO Spotfire, EMS and TIBCO ActiveSpaces. He has worked on a number of highly critical integration projects in various sectors by using his skills in TIBCO Flogo, TIBCO API Management (Mashery), TCI, Tibco Designer, TIBCO Business Studio, Adapters, TIBCO EMS, RV, Administrator, TIBCO BE, TIBCO ActiveSpaces etc. Ajmal Abbasi has experience with MuleSoft ESB as well. Ajmal Abbasi is also experienced in the area of API Management particularly with WSO2 API management platforms. Ajmal Abbasi is also experienced in developing solutions using Core Java and J2EE Technologies. You can contact Ajmal Abbasi for Consultancy, Technical Assistance and Technical Discussions.

More Posts - Website - Facebook - LinkedIn - YouTube