Loading...

中文 日本語

{{ caseData.title}}

Home
>
Customer Stories
>
{{caseData.meta.z_case_company}}
{{caseData.meta.z_case_quotes}}
{{caseData.meta.z_case_famous}}

Overview

Sichuan Provincial Medical Security Bureau | Province-Wide Healthcare Data Cloud Migration

Country: China

Industry: Public Sector / Healthcare Administration

Solution: Info2soft’s solution

To support the province’s digital medical insurance transformation, the Sichuan Provincial Medical Security Bureau implemented Info2soft’s solution-based cloud data migration and synchronization solution. The project enabled real-time, lossless healthcare data replication from 22 regional cities to the national medical insurance platform.

Customer Challenge

  • Decentralized medical insurance data distributed across 22 regional systems.
  • Complex heterogeneous databases requiring schema transformation and standardization.
  • Cross-region synchronization issues, including DELETE-to-INSERT conversion.
  • The need for real-time, accurate reporting to the national platform without data loss.

I2 Solution 

  • City-Level Data Migration — Extracted, cleaned, and transformed data from regional social security databases (Oracle 11g/12c/19c) and synchronized them through Info2soft’s solution.
  • Provincial-Level Data Reporting — Configured a sync server to incrementally replicate new data from TDSQL sources to MySQL targets every two minutes.
  • Specialized DELETE Handling — Captured DELETE operations via TDSQL binlogs and logged them into a dedicated database for automated processing and compliance tracking.
  • Settlement Platform Integration — Real-time replication of both full and incremental data into the TBASE system, ensuring instant display on settlement and treatment platforms.

Solution Effects

  • Successfully migrated and unified medical insurance data from 22 cities to the provincial cloud platform.
  • Achieved real-time, lossless synchronization and reporting to the national insurance platform.
  • Ensured data consistency and availability across provincial and national systems.
  • Established a reliable, fault-tolerant architecture supporting healthcare data security and continuity.
{{ country.name }}
Please fill out the form and submit it, our customer service representative will contact you soon.
By submitting this form, I confirm that I have read and agree to the Privacy Notice.
{{ isSubmitting ? 'Submitting...' : 'Submit' }}