Download PDF
Qlik > Case Studies > BITMARCK Uses Qlik Replicate™ (formerly Attunity Replicate) and Microsoft SQL Server to Streamline Data Integration and Enable Self-Service, Real-time Business Intelligence for Customers
Qlik Logo

BITMARCK Uses Qlik Replicate™ (formerly Attunity Replicate) and Microsoft SQL Server to Streamline Data Integration and Enable Self-Service, Real-time Business Intelligence for Customers

Technology Category
  • Analytics & Modeling - Data-as-a-Service
  • Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
  • Healthcare & Hospitals
Applicable Functions
  • Business Operation
Use Cases
  • Predictive Maintenance
  • Real-Time Location System (RTLS)
Services
  • Data Science Services
  • System Integration
The Challenge
BITMARCK, the largest full-service provider in the German IT market for statutory health insurance, needed to streamline data integration and enable self-service, real-time business intelligence for its customers. The public health insurance companies use information to measure customer retention and turnover, generate financial reports, manage cash flow, and estimate risk. To support customers’ business intelligence and analytics initiatives, the BITMARCK team routinely had to gather data from several different technical sources and move it into a central target. These data sources ranged from IBM DB2 to MySQL, Microsoft SQL Server, and Informix. BITMARCK had been using IBM Q Replication, but this solution only supported replication between DB2 sources and targets. To replicate data to other sources, the BITMARCK team had to do lots of SQL scripting or use proprietary programs.
About The Customer
BITMARCK is the largest full-service provider in the German IT market for statutory health insurance. It has over 1,400 employees and a turnover of around €260 million. The company provides IT services for around 100 public health insurance companies, as well as for the German healthcare system (DAK-Gesundheit) and other replacement funds and insurance companies that cover approximately 26 million people. BITMARCK’s services include server hosting, business intelligence, data mining, reporting, and more. Its customers rely on business intelligence and analytics to predict future cash flow, calculate patient risk, analyze financial information, and more.
The Solution
BITMARCK began evaluating how to implement a single data warehouse which would be supported by a consistent approach to data integration. The team engaged in a three-step process: They evaluated the target database system for the new data warehouse solution. The team asked customers how they wanted to use and analyze the data. This helped determine whether or not live reporting was needed. They examined the data warehouse system and data integration solutions. BITMARCK settled on Microsoft SQL Server as the platform for the data warehouse. For replication, the team considered several options: Qlik Replicate, IBM Q Replication, InfoSphere Data Replication, and tcVISION. The latter three weren’t ideal due to their cost, lack of support for all databases, and lack of support for different variants of Microsoft SQL Server. Qlik Replicate was attractive due to its ease of use, database support, customer support provided during testing, and affordability.
Operational Impact
  • BITMARCK now routinely processes 5,000 tables through live replication to a Microsoft SQL Server data warehouse.
  • BITMARCK’s customers enjoy consistent data and easy access to BI, reporting, and analytics.
  • With one data model, they can connect data with health insurance, payment, invoicing information, and more.

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.