From the technical center of excellence of Massil Technologies, our technology leader Srini makes it easy to understand the complex situations you come across in Mule ESB from the experience of Massil Technologies to have countered them in their experience of working on client projects in real time. This blog addresses how to connect MULE ESB with Microsoft Access Database. This blog is a part of series of blogs being authored and published by Massil Technologies for the benefit of the IT community globally.
What is Mule ESB?
Mule is a lightweight enterprise service bus and integration framework provided by MuleSoft. The platform is Java-based but can broker interactions between other platforms such as .NET using web services or sockets.
What is Microsoft Access Database?
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
Connecting Mule ESB to Microsoft Access Database:
A simple step by step procedure is followed to establish the connection.
Open Anypointstudio opens a new project in and the drag HTTP connector and configure it.
Add the required jar files by using build path in the project. Refer to the below screenshot, the yellow marked files are required jar files for the project and the location of the files is indicated as a computer>localdisk(c)>programfiles>java>jre.18.0141>lib in my case.
After adding the jar files in project folder of the referenced library, the jar files look like in the below screenshot.
Step 3: As a next step, drag the database connector and configure the connector. Choose the Generic Database configuration and then configure the connector as shown below
The Driver Class Name is obtained from the jar files that we are added can access-4.0.2.jar file in my case and click on the Test Connection button
Step 4: Drag the Object to JSON Transformer and the flow should look like as shown…
…and then run the flow and it displays the deployed status as shown below
and then go to the postman in chrome extension to test the flow which is implemented by us.
The output looks like this when performing get operation:
Hope this article from Massil Technologies was useful for you. If you have any further queries on this topic, please reach out to firstname.lastname@example.org.