BITMARCK is a German company that provides IT solutions for healthcare and health insurance organizations that serve about 26 million users. Their services include server hosting, business intelligence (BI) data mining and reporting for their customers.
THE CHALLENGE: Couldn’t Move Heterogenous Data to a Central Source Quickly and Easily
To support their customer’s BI and analytics projects, the BITMARCK team needs to gather data from multiple sources such as IBM DB2, MySQL, Microsoft SQL Server and Informix and move the data to a central target. They were challenged because in order to move the data, they had to do a lot of SQL scripting which was time-intensive and labor-intensive.
THE SOLUTION: Attunity Replicate Automates Data Movement to SQL Server in Real-time
The BITMARCK team began looking for a software solution that would meet their challenges and their customers budgets. Their evaluation was a three-step process which included:
- They evaluated target database solutions.
- They surveyed their customers as to how they needed to analyze data.
- They looked at data integration solutions.
BITMARCK settled on Microsoft SQL Server as their target data warehouse. They chose Attunity Replicate for data integration because the software was easy to use, supported all of the data sources they worked with and they liked the customer support they received.
THE RESULTS: Real-time Business Intelligence That Just Works
Using Attunity Replicate, BITMARCK is able to routinely move 5,000 data tables from multiple sources to the SQL Server data warehouse quickly and easily. Their customers have consistent data and easy access to BI, analytics and reporting. As data changes, it is automatically uploaded so that customers are working with real-time data.
“Using Attunity software, BITMARCK is able to deliver a great service for customers who now have access to higher quality data and who are saving up to 50% of the time they used to spend gathering data and creating models.”
— Rene Wilms, Head of Business Intelligence, BITMARCK