In Part 1 of this three part blog, we created an HTTP REST service that retrieves employee records from an Oracle HR database and returns it in JSON format. In Part 2, we took a look at how to easily turn this into a SOAP XML service without any coding by utilizing the SOAP component for top-down web service generation and the Data Mapper for transformations. Let’s now publish the Employee Record as a message to WebSphere MQ, which is a common approach for integrating with legacy on-premise systems. (Note: Setup steps are at the end of each part for the necessary software. Parts 1 and 2 of this blog needs to be completed.)
In Part 1 of this three part blog, we created a simple message flow in Mule Studio exposed as a basic HTTP service that retrieves employee data from an Oracle HR database and returns it in JSON format. JSON is a standard format that is very popular among web and mobile applications. Let’s now take a look at how to easily turn this into a SOAP web service, which is a standard in use in a lot of internal SOA and on-premise integration projects. We will do this without any coding. We will first generate a SOAP web service using a top-down approach with an existing WSDL and then graphically map the database table structure to the expected message format of the SOAP web service (Note: Setup steps are at the end of each part for the necessary software. Part 1 of this blog needs to be completed.)
I made a shift to MuleSoft! After spending most of my career in Big Red and Big Blue, I decided to jump from the walls of the big commercial enterprise technology vendors to the fast moving world of open-source technologies, SaaS and the Cloud. I’ve worked with several of the traditional on-premise integration tools from Oracle and IBM and now I’ll be working with MuleSoft’s latest and greatest integration platform that brings integration to the cloud.
1. Using Flows as Lookup Tables
Let’s say you need to map and transform a message payload from one structure and format to another. Of course, DataMapper is the perfect tool for that job. However, what if you also need to add to the payload as it is transformed and mapped? You could use DataMapper and a lookup table (CSV, DB or User Defined) to find and add data to a message, or you could take advantage of a new feature in 3.4: the Flow Reference Lookup. With this feature, you can use a flow reference to invoke a separate flow to request, process or retrieve information and use it in the mapping.
Anyone that has used DevKit to write a Mule extension and then wanted to add it to Studio, may have notice that the extension will appear under the Cloud Connectors category in the palette. This is not a problem when the extension is actually a Cloud Connector, but is sort of a problem when it was something else (for example a component like the LDAP connector). This is not an issue anymore since DevKit 3.3.2, as you can now use the @Category annotation at class definition level (Connector or Module) to select under which category you want your extension to be listed in:
The mega-trends of SaaS, mobile and Big Data are converging, generating a new wave of business opportunity for enterprises. The convergence demands a new kind of platform – one that connects and takes advantage of the explosion of endpoints and data caused by organizations each choosing a uniquely diverse set of best-of-breed applications to power their business. In this live webinar, Ross Mason will discuss his vision for this new platform and demonstrate how MuleSoft’s solutions are making it a reality.
Questions discussed include:
- How will SaaS and mobility impact my business?
I’m thrilled to announce the availability of CloudHub in Europe. With this announcement, we’re extending the industry-leading CloudHub platform to address the needs of our European customers with dedicated computing resources located in the European Union.
European companies are adopting the cloud faster than ever — Salesforce recently announced that Europe was their fastest growing region last year. However, one of the primary obstacles to using cloud services in the EU is complying with the EU data protection directive which regulates the processing of personal data. With the availability of CloudHub in Europe, it’s now significantly easier for European organizations to comply with these regulations by ensuring data never leaves the EU.
The Service Oriented Architecture stipulates a change in perspective for software purchase and development which traditionally limited itself to catering for the isolated needs of a department or sub-division of the Enterprise. SOA exploits emerging standards to facilitate the development and purchase of software so that the requirements of the Enterprise as a whole are satisfied. Thus, services are identified, defined and subsequently reused in orchestrations with other services that map to the processes which form the life arteries of the Business. SOA advises the use of a Service Registry to govern the initiative in order to ensure the proper re-use of existing candidate Services and their compliance to the policies of the Enterprise. That said, in recent times, with the explosion of APIs, the Enterprise has flung open its doors and windows and ripped off its roof in order to reach to the sky to exploit the vast array of cloud-based services on offer and include them in its software inventory. Thus, the New Enterprise has come of age and brought with it the need for a suitable form of Governance. With Anypoint Service Registry, MuleSoft are the first to offer a cloud-based Governance solution which allows the New Enterprise to securely register, discover, manage and monitor its services as well as the consumers of those services. With this post, we’d like you to see for yourselves how Anypoint sets the standard for next generation SOA Governance.
We’re excited to announce that we will be sponsoring SAP’s Sapphire Now conference, taking place May 14 -16 in Orlando Florida. We will be showcasing MuleSoft’s SAP integration solutions to the 16,000 delegates in attendance and demonstrating our unique ability to connect SAP to other SaaS and on-premise applications such as Salesforce, NetSuite, ADP, and Oracle.
MuleSoft offers four SAP-certified solutions that make it fast and easy to connect SAP to the rest of the enterprise:
The MuleSoft Enterprise Gateway for SAP provides bi-directional communication via application link enabling (ALE) and iDocs technology with SAP solutions.
It has now been nearly a month since Mule 3.4 was released and coming back from the 8 city tour Spring 2013 Mule summit, I can truly say there is tremendous excitement within the Mule community around the great features that this release offers.
In the coming weeks, key members of the MuleSoft team who were behind this release will be blogging about its various features and capabilities. Here is what this blog post line-up looks like: