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

Edit This Case Study Record

	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

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

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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 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.

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.

Impact #1	BITMARCK now routinely processes 5,000 tables through live replication to a Microsoft SQL Server data warehouse.
Impact #2	BITMARCK’s customers enjoy consistent data and easy access to BI, reporting, and analytics.
Impact #3	With one data model, they can connect data with health insurance, payment, invoicing information, and more.

Impact #1

BITMARCK now routinely processes 5,000 tables through live replication to a Microsoft SQL Server data warehouse.

Impact #2

BITMARCK’s customers enjoy consistent data and easy access to BI, reporting, and analytics.

Impact #3

With one data model, they can connect data with health insurance, payment, invoicing information, and more.

Download PDF Version

Overview

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

Operational Impact