下载PDF
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 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

技术
  • 分析与建模 - 数据即服务
  • 应用基础设施与中间件 - 数据交换与集成
适用行业
  • 医疗保健和医院
适用功能
  • 商业运营
用例
  • 预测性维护
  • 实时定位系统 (RTLS)
服务
  • 数据科学服务
  • 系统集成
挑战
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.
关于客户
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.
解决方案
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.
运营影响
  • 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.

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

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