What We Do
Who We Are
Industries
Technologies
AWS
Azure
Boomi
Confluent
MuleSoft
Snowflake
Software AG
Events
Insights
INSIGHTS
Blog Posts
Industry News and Updates
Case Studies
Recent Projects
Offerings
Project Accelerators
White Papers & eBooks
Insights and Education
Contact
Contact Us

Custom Connection Profile for iSeries Improves MuleSoft Integration Performance

MuleSoft
Customer Scenario

A client in the healthcare field was experiencing serious degradation in performance with database queries. The version of their integration platform, MuleSoft 3.9, did not offer out-of-the-box support for their legacy iSeries system and DB2 database. Although MuleSoft’sAnypoint Platform provides a Generic database connector that could be used with DB2, it was found to create a new database connection for each query. This created heavy loads and slowed performance for the system’s resources.

Solution

The solution needed to remove ad hoc connections to the database to lessen system load. To achieve this, a third-party library called HikariCP was used to create a custom connection profile. The new connection profile caches database connections from the connection pool per application instead of creating a new connection for each query. These connections to the database can then be re-used. Profiles can specify the number of connections to be pre-cached and indicate a time-to-live value, reducing the number of unused connections occupying the pool.

Results

With the new custom connection profile, connections are always available when a new request is added. As a result, resource utilization became more predictable and the client saw an impressive drop of nearly 70% in response times, all but eliminating the performance issues caused by DB2 queries.

Big Compass
subscribe

Sign up to stay on top of the latest news.

We've added you to the list!
Something went wrong. Please try again.
recent Case Studies
From Mule 3 to Mule 4: A Government Agency's Journey Towards Secure Integrations to Ensure Safe Water and Flood Control
Leader in Children’s Play Kits Integrates NetSuite, Shopify, and Boomi to Modernize and Support International Operations
MuleSoft Migration Streamlines and Simplifies ERP Business Processes for Manufacturing Client
View All
No items found.

BUILDING CONNECTIONS IN A DISCONNECTED WORLD

Company
What We DoWho We AreEventsCareersContact us
technologies
AWS
Azure
Boomi
Confluent
MuleSoft
Snowflake
Software AG
insights
Blog Posts
Case Studies
Offerings
White Papers & eBooks
subscribe
Welcome to the Big Compass family!
Oops! Something went wrong while submitting the form. Please try again.
© 2020 Big Compass
  |  
Privacy Policy
  |  
Terms of Service