Processing...
NIX United migrated 150 ETL workflows from Talend to Boomi for a US healthcare provider, modernizing data integration with reusable components, structured mappings, and AI-assisted code analysis.
Healthcare
Data Migration
Boomi, Talend, Apache Kafka, json, Java, Rest API
Our client is a US-based medical hub that provides healthcare and pharmaceutical companies with patient access and support solutions. For the past 15 years, they’ve been using the Talend platform for Extract, Transform, and Load (ETL) processes that operate on patient data. Facing growing challenges, such as the complexity of on-premises installations, poor user experience, and high costs, the client decided to conduct a Boomi migration, an end-to-end transition to a more efficient web- and cloud-based platform. Due to our long-term partnership with the client, they entrusted NIX United with the end-to-end integration development on the Boomi platform across multiple programs and pharma clients.
We were responsible for ETL migration, re-platforming, and API integration from the Talend architecture into a modern, cloud-native Integration Platform as a Service (iPaaS). Our team manually reviewed and migrated each of the 150 processes to ensure the existing integration logic and business requirements were preserved. Working closely with the client’s team, we shaped integration architecture, analyzed requirements, and optimized existing processes, making Boomi a predictable, effective, and scalable part of the client’s ecosystem.
Since Talend and Boomi handled the same logic differently, our team had to dive deep into the mechanics of both platforms to successfully migrate over 150 processes while preserving existing functionality. Despite being a low-code platform, the Talend workflows contained embedded custom Java code that had to be manually reviewed. In general, the NIX United team had to address database connections, configurations, mappings, and code reusability.
The NIX United experts approached the development using reverse engineering, first discovering Talend processes and then replicating the same runtime on the Boomi platform. In the latest stages of the migration, we accelerated the process by leveraging AI solutions, specifically Claude, which parsed the code and answered questions about each process’s functionality, mapping out the functional logic for replication in Boomi. The entire process consisted of the following steps:
Since most integration processes relied on Microsoft SQL Server, we used the Microsoft JDBC Driver and kept the migration as simple and low-code as possible. We moved the existing database workflows from Talend to Boomi and introduced JSON-based data processing, making the solution easier to integrate with cloud tools and support future integrations.
To preserve the required functionality and flexibility, our team redesigned the workflows to identify and configure all required target connections at the start of each integration. This allowed the processes to connect to the right systems without requiring connection changes during execution.
To preserve complex processing logic while making the new solution easier to maintain, the NIX United team created hundreds of reusable components that could be used across different processes. For cases that required custom JavaScript, we packaged the scripts as standalone JAR files and added them to Boomi as managed components. This approach helped speed up development while keeping the migrated solution consistent and easier to maintain.
In order to handle complex data flows and keep them easy to manage, the NIX United team redesigned the mapping logic and introduced a more structured approach to data processing. We consolidated multiple data transformations into reusable, clearly organized mappings, making data flows easier to understand, audit, and maintain. This also reduced configuration complexity and helped the team work more consistently across integration processes.
By successfully migrating 150 workflows from Talend to Boomi, the NIX team helped the client move from a localized development environment to a centralized, cloud-based integration platform. As a result, the client gained:
Simpler access and management through a browser-based interface, without complex local installations.
Greater visibility and easier maintenance of all 150 workflows through clearly structured processes and mappings.
Faster development and easier management through reusable processes, profiles, mappings, and scripts.
Faster onboarding of engineers thanks to Boomi’s user-friendly environment and extensive learning resources.
Schedule Meeting
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
