123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Business >> View Article

Dell Boomi Integration For Largest Pharmacy Retailer In Australia

Profile Picture
By Author: Roy Anitha
Total Articles: 7
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

Australia's largest pharmacy retailer, with locations throughout Australasia, planned to improve customers' healthcare outcomes through the most effective and efficient means possible, resulting in significant savings for the end user. For our retail client, the Morpheus project was implemented to replace the existing order and invoice exchange mechanism between stores and suppliers with a faster and more streamlined ecosystem.

Executive Summary
As part of Retail Order and Invoice management, the client required a robust centralized integration platform capable of guaranteed message delivery, parallel processing, high volume data handling, and secure communication to manage critical data flow between various end systems such as on-premise ERP system (Microsoft Dynamics AX), on-premise database (Microsoft SQL Server), PharmX (a cloud-based external supplier gateway portal), SFTP server, and so on.

Ray Business Technologies subject matter experts collaborated closely with project stakeholders to understand the application's business requirements. The modules were designed by the RBT team to be highly usable ...
... and to the satisfaction of the end users. This increased the company's profit margins.

Challenges
Highly critical data, such as Products, Orders, Order Acknowledgements, Invoices, Supplier Statements, Credits, and so on, must be transferred among various end systems, introducing multiple integration touch points.
A dependable integration middleware that can handle streamlined, secure, and performance effective data transfer between the mentioned end systems with zero data loss, bulk processing capability, and robust error handling was required.

Solution
The RBT team successfully implemented all integrations using Dell Boomi middleware. Parallel processing was implemented in Boomi using the Atom Queue feature, resulting in high throughput while handling large volumes. Boomi includes robust error handling to make production support easier. Boomi's solution ensured transaction security and message delivery.

Application workflow:

Warehouse Order Integration: Warehouse Orders are placed by Stores to Suppliers via the MRM application and stored in the MS SQL Server database. Boomi used an external scheduler to collect orders stored in DB at predefined intervals. Boomi converted these Orders and sent them to MS Dynamics AX as Sales Orders after applying business rules. Following the creation of Sales Orders in AX, Sales Invoices were generated, and these invoices were collected by Stores via MRM.

PharmX Invoice Integration: PharmX Orders are placed by Stores to Suppliers via the MRM application, and these Orders are sent to PharmX. (a cloud-based external supplier gateway portal). Suppliers will send Invoices to PharmX for corresponding Orders. Boomi will collect PharmX invoices on a regular basis, store them in an MS SQL Server database, transform them, and send them to MS Dynamics AX as Sales Orders after applying business rules. When Sales Orders are created in AX, Sales Invoices are generated, and these invoices are collected by Stores using MRM.

Total Views: 293Word Count: 435See All articles From Author

Add Comment

Business Articles

1. Finding Your Next Book: A Reader’s Guide To Om Books International
Author: CONTENT EDITOR FOR SAMPHIRE IT SOLUTIONS PVT LTD

2. A Complete Guide To Starting A Business In A Uae Free Zone
Author: Eden counsel

3. What Makes Hardcover Book Printing Different From Paperback Printing?
Author: Steve Morgan

4. What To Do If A Dog Charges: Step-by-step Safety Tips For Field Workers
Author: andy

5. Expansion Joint Manufacturer: Choosing Durable Bridge Expansion Joint Solutions
Author: Phani

6. Mens Shoes Product Data Api India For Market Insights
Author: Actowiz Solution

7. Study Mbbs In Philippines 2026–27: Admission, Course Duration, Fees, And Career Opportunities
Author: Mbbs Blog

8. Iso 9001 Certification In Tamil Nadu
Author: sqccertification

9. Medical Universities, Fees, Eligibility, Admission Process & Scholarships For Indian Students!
Author: Mbbs Blog

10. How To Choose The Perfect Curtains For A Stylish And Comfortable Home
Author: GVK Home Decors

11. An Ideal Destination To Study Mbbs Is Georgia
Author: Mbbs Blog

12. Trusted Construction And Industrial Scrap Buyers In Hyderabad For Best Scrap Value
Author: tradebinscrap

13. Textile Shops In Trichy
Author: Massclick

14. Best Electronic Scrap Buyers In Hyderabad – Reliable Ac Scrap And Old Ac Scrap Buying Services
Author: tradebinscrap

15. Isaca Reaches 200,000 Members Advancing Digital Trust And Ai Governance
Author: Madhulina

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: