---
title: Streamline Cloud Deployment with MuleSoft ESB Integration
description: Discover how MuleSoft ESB simplifies data exchange and cloud deployment. Learn about seamless Mule ESB integration for Oracle, SQL Server, and distribution portals.
image: https://blog.ennvee.com/hubfs/Imported_Blog_Media/wordpress-paas-saas-blog-header-2.jpg
---
- Services & Technologies
- Services
- [Data & AI](https://ennvee.com/data-and-ai/)
- [Digital Transformation](https://ennvee.com/digital-transformation/)
- [Data Intelligence](https://ennvee.com/data-intelligence/)
- [Technologies](https://ennvee.com/technologies/)
- [Oracle Fusion Cloud](https://ennvee.com/oracle-fusion/)
- [Oracle E-Business Suite](https://ennvee.com/oracle-ebs/)
- [Oracle JD Edwards](https://ennvee.com/oracle-jde/)
- [Oracle NetSuite](https://ennvee.com/oracle-netsuite/)
- [Cloud Infrastructure (IaaS)](https://ennvee.com/oracle-cloud-infrastructure/)
- [Microsoft Dynamics](https://ennvee.com/microsoft-dynamics-365/)
- [Salesforce](https://ennvee.com/salesforce-cloud-services/)
- [Application Development & Integration](https://ennvee.com/application-integration-services/)
- [SAP](https://ennvee.com/sap/)
- [Tools & Accelerators](https://ennvee.com/accelerators/)
- [ennABLE](https://ennvee.com/accelerators/oracle-ebs-r12-2-upgrade-automation/)
- [ennAccess](https://info.ennvee.com/jde-user-access-record-tool)
- [TrendZ](https://ennvee.com/accelerators/oracle-proactive-system-monitoring/)
- [EDI](https://ennvee.com/accelerators/oracle-edi-automation-tool/)
- Products & Solutions
- [ennSCM](https://ennvee.com/products/ennscm/)
- [ennData 360](https://ennvee.com/products/enndata360/)
- [AI ILMS](https://ennvee.com/products/ai-ilms/)
- [AI in Finance Operations](https://ennvee.com/products/ai-in-finance-operations/)
- [Expense Application](https://ennvee.com/products/expense-application/)
- [Chatbot](https://ennvee.com/products/chatbot/)
- [Field Sales Pro](https://ennvee.com/products/field-sales-pro/)
- [AI - Powered Ticketing Tool](https://ennvee.com/products/ai-powered-ticketing-tool/)
- [AI - Powered PO to SO](https://ennvee.com/products/ai-powered-po-so/)
- [AI - Resume Grader](https://ennvee.com/products/ai-resume-grader/)
- Insights
- [Blogs](https://blog.ennvee.com/blog)
- [Datasheets](https://ennvee.com/data-sheets/)
- [Case Studies](https://ennvee.com/case-studies/)
- [Whitepapers](https://ennvee.com/white-papers/)
- Company
- [About](https://ennvee.com/about-us/)
- [Careers](https://ennvee.com/careers/)
- [News and Events](https://ennvee.com/news-and-events/)
- [Contact Us](https://ennvee.com/contact-us/)
×
Search
- Services & Technologies
- Services
- [Data & AI](https://ennvee.com/data-and-ai/)
- [Digital Transformation](https://ennvee.com/digital-transformation/)
- [Data Intelligence](https://ennvee.com/data-intelligence/)
- [Technologies](https://ennvee.com/technologies/)
- [Oracle Fusion Cloud](https://ennvee.com/oracle-fusion/)
- [Oracle E-Business Suite](https://ennvee.com/oracle-ebs/)
- [Oracle JD Edwards](https://ennvee.com/oracle-jde/)
- [Oracle NetSuite](https://ennvee.com/oracle-netsuite/)
- [Cloud Infrastructure (IaaS)](https://ennvee.com/oracle-cloud-infrastructure/)
- [Microsoft Dynamics](https://ennvee.com/microsoft-dynamics-365/)
- [Salesforce](https://ennvee.com/salesforce-cloud-services/)
- [Application Development & Integration](https://ennvee.com/application-integration-services/)
- [SAP](https://ennvee.com/sap/)
- [Tools & Accelerators](https://ennvee.com/accelerators/)
- [ennABLE](https://ennvee.com/accelerators/oracle-ebs-r12-2-upgrade-automation/)
- [ennAccess](https://info.ennvee.com/jde-user-access-record-tool)
- [TrendZ](https://ennvee.com/accelerators/oracle-proactive-system-monitoring/)
- [EDI](https://ennvee.com/accelerators/oracle-edi-automation-tool/)
- Products & Solutions
- [ennSCM](https://ennvee.com/products/ennscm/)
- [ennData 360](https://ennvee.com/products/enndata360/)
- [AI ILMS](https://ennvee.com/products/ai-ilms/)
- [AI in Finance Operations](https://ennvee.com/products/ai-in-finance-operations/)
- [Expense Application](https://ennvee.com/products/expense-application/)
- [Chatbot](https://ennvee.com/products/chatbot/)
- [Field Sales Pro](https://ennvee.com/products/field-sales-pro/)
- [AI - Powered Ticketing Tool](https://ennvee.com/products/ai-powered-ticketing-tool/)
- [AI - Powered PO to SO](https://ennvee.com/products/ai-powered-po-so/)
- [AI - Resume Grader](https://ennvee.com/products/ai-resume-grader/)
- Insights
- [Blogs](https://blog.ennvee.com/blog)
- [Datasheets](https://ennvee.com/data-sheets/)
- [Case Studies](https://ennvee.com/case-studies/)
- [Whitepapers](https://ennvee.com/white-papers/)
- Company
- [About](https://ennvee.com/about-us/)
- [Careers](https://ennvee.com/careers/)
- [News and Events](https://ennvee.com/news-and-events/)
- [Contact Us](https://ennvee.com/contact-us/)
# Cloud Deployment & Data Exchange using Mule ESB
[← All posts](https://blog.ennvee.com/blog)
4 MIN READ
Using Mule ESB to exchange business flow data between distribution portals, SQL Server and Oracle Databases.
## Background
The client, a global manufacturer, was born from innovation. 60 years ago saw the introduction of its first product, the wiring duct, a new invention that uniquely organized control panel wiring and allowed new wires to be added quickly and neatly. Since then, the manufacturer has introduced numerous problem-solving products and remained committed to providing innovative electrical and network infrastructure solutions.
## Business Objective
The manufacturer maintains various business flows in Oracle SOA, such as BOM details and user favorite details. Their goal was to deploy the application to Cloud and exchange data between the distribution portal (UI), SQL Server (DB), and Oracle DB. ennVee proposed using Mule ESB to meet the integration requirements.
**What is Mule ESB?**
[Mule ESB](https://www.mulesoft.com/resources/esb/what-mule-esb) is a Cloud-supporting integration platform used to exchange data with numerous applications. In this platform, REST APIs play a key role in directing the applications to perform the business's expected actions.
**Pre-Requisites:**
1. MuleSoft AnyPoint Studio with Mule Runtime 3.8 and Maven 3.1
2. Database credentials with APPS/EUL/MULESOFT\_API schema access and privilege to create objects
3. Postman to test the API’s locally and within the AnyPoint platform environment
4. VPN credentials
5. GIT access to commit the code changes
6. Source Tree opens a source tool to maintain a local repository to maintain the code changes and push/pull requests to GIT
## API Layers Information
Mule ESB supports REST API’s for better communication among the numerous applications. [API development](https://blog.ennvee.com/blog/2017/10/02/mulesoft-api-lifecycle-management) for the current system requirements uses the following layers:
**Experience Layer: **The experience layer is used to enforce policies for users and perform user-specific transformations to the request/response payload.
**System Layer:** The system layer plays a key role in the communication between the source and destination applications.
**Below: Business flow to implement the BOM Details Integration process:**
**API layers implementation for the BOM Details flows:**
The API implementation was also done for the following project tasks:
**userAccountSync Job:** User accounts in Oracle E-Business Suite (as the source system) and synced with the SQL Server database. This job is scheduled daily, every 4 hours.
**returnLetterDocument:** In this process, distribution portal users send a request to view and download the "return letter" documents with specific details. Users can fetch the return letter details, which are submitted through Oracle wrapper programs from the Oracle DB.
**invoiceDocumentDetails:** In this process, distribution portal users send a request to view and download the invoice documents with specific details. Users can fetch the invoice details, which are submitted through Oracle wrapper programs from the Oracle DB.
**userAdminDetails:** In this process, distribution portal users send a request to obtain user account admin details from SQL Server through Mule flow.
**packingSlipReportDetails:** In this process, distribution portal users send a request to view and download the packing slip report documents with specific details. Users can fetch the packing slip details, which are submitted through Oracle wrapper programs from the Oracle DB.
## Business Benefits
After the successful integration, distribution portal users can readily access, view, and download pertinent information from the Oracle EBS instance.
- **addBOMItem Details:** BOM item details can be accessed in the Oracle EBS instance.
- **userAccountSyncJob**: User account details in Oracle EBS are integrated into the SQL Server database, which allows distribution portal users to easily access the user accounts information.
- **returnLetterDocument:** Return Letter document information can be viewed and downloaded in Oracle EBS.
- **invoiceDocumentDetails:** Invoice details document information can be viewed and downloaded in Oracle EBS.
- **packingSlipReportDetails: **Packing Slip document information can be viewed and downloaded in Oracle EBS.
---
Check out our other [MuleSoft blogs](https://blog.ennvee.com/blog/tag/mulesoft) and learn more about ennVee's [MuleSoft integration and consulting](https://ennvee.com/mulesoft-integration-development-services/) services.
### Tags
[API Management](https://blog.ennvee.com/blog/tag/api-management) [Database](https://blog.ennvee.com/blog/tag/database) [Integration](https://blog.ennvee.com/blog/tag/integration) [MuleSoft](https://blog.ennvee.com/blog/tag/mulesoft) [Microsoft SQL Server](https://blog.ennvee.com/blog/tag/microsoft-sql-server) [Mule ESB](https://blog.ennvee.com/blog/tag/mule-esb) [Oracle Database](https://blog.ennvee.com/blog/tag/oracle-database)
### Recent Posts
- [MuleSoft API Lifecycle Management](https://blog.ennvee.com/blog/mulesoft-api-management)
## You Might Also Like...
[BLOG MuleSoft API Lifecycle Management](https://blog.ennvee.com/blog/mulesoft-api-management)
[BLOG Building a Mobile Registration Application using MuleSoft](https://blog.ennvee.com/blog/building-a-mobile-registration-application-using-mulesoft)
[BLOG Salesforce integration with Oracle EBS using MuleSoft](https://blog.ennvee.com/blog/salesforce-oracle-ebs-integration-mulesoft)
- [SERVICES](https://ennvee.com/services/)
- [Oracle Fusion Cloud](https://ennvee.com/oracle-fusion/)
- [Oracle E-Business Suite](https://ennvee.com/oracle-ebs/)
- [Oracle JD Edwards](https://ennvee.com/oracle-jde/)
- [Oracle NetSuite](https://ennvee.com/netsuite/)
- [Cloud Infrastructure (laaS)](https://ennvee.com/infrastructure-iaas/)
- [Robotic Process Automation (RPA)](https://ennvee.com/robotic-process-automation/)
- [INNOVATIONS](https://ennvee.com/accelerators/)
- [Accelerators](https://ennvee.com/accelerators/#ProprietaryAccelerators)
- [Products](https://ennvee.com/accelerators/#Products)
- [INSIGHTS](https://ennvee.com/resources/)
- [Blog](https://blog.ennvee.com/blog)
- [Data Sheets](https://ennvee.com/data-sheets/)
- [Case Studies](https://ennvee.com/case-studies/)
- [White Papers](https://ennvee.com/white-papers/)
- CONTACT INFORMATION
- US: +1-630-364-1911
- India: +91-93848 42661
- mail: corp@ennvee.net
-
[© ennVee. All Rights Reserved.](https://ennvee.com/legal-notice/)
- [privacy policy](https://ennvee.com/privacy-policy/)
- [site map](https://ennvee.com/page-sitemap.xml)
- Services
- [Oracle Fusion Applications](https://ennvee.com/oracle-saas-applications/)
- [NetSuite](https://ennvee.com/netsuite/)
- [Microsoft Dynamics](https://ennvee.com/microsoft-dynamics-365/)
- [Salesforce](https://ennvee.com/salesforce/)
- [Infrastructure (IaaS)](https://ennvee.com/infrastructure-iaas/)
- [Application Managed Services](https://ennvee.com/application-managed-services/)
- [Robotic Process Automation (RPA)](https://ennvee.com/robotic-process-automation/)
- [Application Integration Services](https://ennvee.com/application-integration-services/)
- [Accelerators](https://ennvee.com/accelerators/)
- [Oracle EBS Upgrade Automation](https://ennvee.com/accelerators/oracle-ebs-r12-2-upgrade-automation/)
- [Oracle Proactive System Monitoring](https://ennvee.com/accelerators/oracle-proactive-system-monitoring/)
- [Oracle Discoverer Migration Tool](https://ennvee.com/accelerators/oracle-discoverer-migration-tool/)
- [Oracle EDI Automation Tool](https://ennvee.com/accelerators/oracle-edi-automation-tool/)
- Resources
- [Blog](https://blog.ennvee.com/blog)
- [Data Sheets](https://ennvee.com/data-sheets/)
- [Case Studies](https://ennvee.com/case-studies/)
- [Webinars](https://ennvee.com/webinars/)
- [White Papers](https://ennvee.com/white-papers/)
- [Careers](https://ennvee.com/careers/)
[](https://www.linkedin.com/company/ennvee/) [](https://www.facebook.com/ennveetechnogroup/) [](https://twitter.com/ennVeeTech) [](https://www.instagram.com/ennvee_india/)
[© ennVee. All Rights Reserved.](https://ennvee.com/legal-notice/)
[Privacy Policy](https://ennvee.com/privacy-policy/) [Site Map](https://ennvee.com/page-sitemap.xml)
