Healthcare integration framework for CRM and clinical systems
A scalable, ETL-style integration framework connecting a healthcare CRM with 200+ hospital, ERP, QMS and insurance systems
TuoTempo provides a proprietary CRM and digital platform to help healthcare organisations manage their relationship with patients: bookings, reminders, communications, access to medical documents and more. To make this work in real hospitals and clinics, the platform must integrate deeply with existing systems: HIS, ERP, QMS and insurance software. While employed at TuoTempo, the work contributed to the development of a proprietary CRM and digital platform for healthcare organisations. A dedicated integration framework inspired by ETL principles was designed and developed, becoming the backbone for data exchange between the TuoTempo CRM and multiple external systems. The framework is:
highly scalable and modular,
configuration-driven, so new modules can be defined with minimal boilerplate,
capable of handling large catalogues (exams/procedures), medical records and dossier documents,
designed for robustness and high data volumes,
and fully integrated into TuoTempo’s performance- and monitoring-oriented ecosystem.
This experience directly influenced many of the design ideas behind ETALIS.
COMPANY
TuoTempo
DOMAIN
Healthcare IT · Patient engagement · System integration
ROLE (AT THE TIME)
Gaetano Borgosano — Integration Framework Architect & technical owner of the integration layer
ENGAGEMENT
In-house role (employee)
PERIOD
October 2016 – May 2023
STATUS
Live in production beyond the engagement
Context & challenge
Each hospital, clinic or group has its own landscape:
different HIS, ERP and QMS systems,
different data models and workflows,
different protocols (REST, SOAP web services, legacy interfaces),
and strict expectations on reliability and security.
Main challenges included:
avoiding a “one-off integration” for each client and instead creating a reusable integration framework,
handling very large datasets (e.g. extensive catalogues of services across hospitals and groups, medical records, dossiers),
different protocols (REST, SOAP web services, legacy interfaces),
keeping integrations robust under high data volumes and continuous synchronisation,
supporting multiple technologies (REST, SOAP, legacy systems) without exploding complexity,
and giving the company observability and control via KPIs, monitoring and testing practices.
Role & responsibilities
My role evolved from “integrator” to architect and technical/product reference for the integration framework of the integration framework. Key responsibilities:
designing and implementing the integration framework between TuoTempo’s CRM and external systems
structuring the framework to be modular and configuration-driven, so integration modules could be defined and extended quickly
covering all the classic ETL dimensions, from importing large catalogues of services for single hospitals or entire groups to synchronising appointments, patient data and clinical information, and handling medical records and dossier documents
ensuring the framework could handle high volumes and continuous flows of data with robustness and fault tolerance
enabling the framework to interface with REST APIs, SOAP web services and legacy systems
integrating the framework into TuoTempo’s monitoring and performance ecosystem
defining KPIs for each integration so that performance, errors and trends could be tracked and discussed with data “on the table”
introducing and using unit tests and integration tests for the framework’s components, so that functionality could be validated independently of HIS data sources
acting as Technical Owner of the integration layer, interfacing with technical contacts in clinics and hospitals to agree on what data to expose and exchange, shaping new framework capabilities that could be reused across multiple integrations, and continuously evolving the core features based on real integration needs
contributing to analysis and testing tools for services and promoting the use of acceptance tests for critical flows
Approach
The work followed a clear set of principles that later converged into the ideas behind ETALIS:
Framework, not one-off integrations Instead of treating each clinic integration as a separate project, I focused on building a generic, extensible integration framework with shared components for connectivity, transformation, validation and monitoring, plus configuration-driven modules on top.
ETL thinking applied to healthcare The system was designed with a classic ETL mindset (extract, transform, load) applied to the healthcare domain, so data from HIS, ERP, QMS and insurance systems could be normalised and synchronised into TuoTempo’s CRM in a controlled way.
Configuration-driven modules Integration behaviour was driven as much as possible by configuration rather than hard-coded logic, making it easier to adapt the framework to new systems, variations and customer-specific rules without rewriting the core.
Protocol-agnostic integration The framework was designed to abstract away underlying protocols, so the same model could support REST APIs, SOAP web services and legacy endpoints while keeping the integration logic consistent.
KPI-based control of integrations Each integration was associated with specific KPIs such as volume, error rates, latency and retries, allowing the team to monitor behaviour, detect issues early and evolve integrations based on objective metrics.
Testing and acceptance culture Unit tests and integration tests were introduced at framework level, and acceptance tests were promoted for critical flows, so changes could be made with confidence even in a heterogeneous and evolving environment.
Continuous evolution from real usage As new clinics and systems were integrated, recurring needs were identified and turned into reusable framework features, increasing standardisation, improving reuse and reducing the cost and risk of subsequent integrations.
Results & impact
The integration framework delivered a significant impact for TuoTempo:
upported over 200 integrations with HIS, ERP, QMS and insurance systems,
reduced the time and effort required to bring new healthcare customers online,
increased robustness and scalability of data flows between CRM and external systems,
gave the company visibility and control through integration-specific KPIs and monitoring,
allowed new integrations to benefit from a growing set of reusable features and patterns,
and laid conceptual foundations that later contributed to the design of ETALIS as a more general ETL/integration engine.
For my own professional journey, this project was crucial in:
consolidating my experience in large-scale system integration in a complex domain,
combining architecture, implementation, testing and technical ownership within a single technical layer,
and understanding deeply what a modern, flexible ETL/integration framework needs to support in real life.
Tecnologies & methods
Technologies: proprietary integration framework inside TuoTempo’s CRM ecosystem; connectors for REST, SOAP and legacy systems; data transformation components; monitoring and KPI tracking; unit and integration test suites.
Methods: ETL-inspired integration design, configuration-driven architecture, technical ownership for the integration layer, collaboration with hospital and clinic IT teams, KPI design and monitoring, acceptance testing for critical flows.
Status & next steps
Current status: The integration framework and related tools continued to support TuoTempo’s integrations with hospitals, clinics and partners beyond my engagement.
How this informs Integratia: This experience is a core reference for Integratia’s approach to designing integration frameworks and ETL-like platforms, and directly influenced the architectural choices behind ETALIS.
Your interest
Need to connect a digital product with complex healthcare or enterprise systems — and want more than a pile of one-off integrations? Let’s talk about your context and explore how an integration framework approach, with KPIs, testing and configurability, can give you a scalable backbone instead of fragile point-to-point links.