BTC Solutions Revitalizes Data Warehouse

Follow the story of a customer who chose a rapid data integration solution.

Industry

Automotive & parts
Online vehicle health check

Professional Services

Extending a Data Warehouse
Consulting Services

Location

Great Malvern, United Kingdom

To build a lasting relationship, it was important for us to choose a provider with the right expertise in which we could place our confidence.

Rising Expectations For Quick Turnaround

For BTC Solutions, the demand for increased performance of their autoVHC platform arose from a combination of growing amounts of data and rising customer expectations for a much quicker turnaround. With dealers having difficulties accessing fresh data, BTC began their search for an ETL tool that could work with fast-changing data efficiently. After considering a number of options, they found that CloverETL, with its sleek design and pure data integration approach, was the right tool for the job.

Consulting Services

What set CloverETL apart was its consulting team. Meeting on site, they assessed BTC’s current solution and where the company wanted to go with it. With this knowledge, our consultants developed a completely revitalized solution that will lead BTC Solutions into the global market.

Read the full story

Download the paper (pdf)

autoVHC, by BTC Solutions, is a fully-computerized Vehicle Health Check system, providing a solution to one of the biggest performance shortfall areas in the current aftersales market. autoVHC automates the follow up process, closing the gap in dealer profits. BTC currently works with more than 800 dealers across the UK and Europe, with plans to expand into China and Russia.

Check out more stories

Try It Yourself

Get Started

Test drive these examples on our 45-day trial of CloverETL Designer and Server.

Proven Solutions

USA
Master Data Management
A major MDM vendor uses CloverETL for data ingest
CloverETL has been a powerful data integration software core enabling quicker project implementation and faster performance. We liked its low cost buy-in and the customization support we get.

A customer needed an ETL tool to embed into their Master Data Management suite as a means of getting data into their core MDM engine. CloverETL, part of the software suite, enables all users, not only developers, to create additional data feeds into the system without having to code. Additionally, the embedded Clover part comes augmented with additional wizards and tools specific for their typical customers.

Canada
E-commerce
Ease of use and efficiency is what draws many companies in
We were amazed to find that it only took thirty seconds transform data from our legacy system to the website using CloverETL, compared to three hours it took before using our home-built scripts.

A Canadian customer selected CloverETL to manage a major element of its e-shop data management.

CloverETL addresses many of the challenges faced by growing IT operations. CloverETL can connect to and parse data from many sources, such as reading and writing to Lotus Domino. It is often just the right package in terms of price and runtime production sizing for customers.

Brazil
Data Consulting
In the Latin American data consulting market, CloverETL supports a strong OEM partner
We chose CloverETL because it's perfect fit for us as we craft solutions in data. Customers now want a combination of best-of-breed ETL to drive and work with other data tools. Clover brings out the best in what we offer, fitting our strategies in address validation, data cleansing, and data profiling.

This particular partner provides software, consulting and implementation for CRM, Direct Marketing and Data Quality solutions. They chose CloverETL as a tool of choice for data migrations and transformations, because of its visual design approach and effective deployment.

Czech Republic
Telecommunications
A mobile network operator migrated new customers data and consolidated CRM systems with CloverETL
The Clover team immediately took charge of the project. As soon as we gave them information about the problem, they started working on a solution.
—Migration Project Manager

A well-known mobile network operator acquired a regional competitor's landline and ISP customers. With this added customer base, customer information needed to be consolidated into the existing CRM, telephone, and ISP systems. All customer data and provided services had to be ingested, cleansed and merged into Clarify, a specialized telecom CRM system provided by Amdocs. Customer documents including contracts, invoices, and technical specifications were then linked to the customer record and migrated to Clarify. Both "welcome" and "service transfer" letters for post-service mailing were requested to notify customers. The new combined CRM data allowed for an easy to manage mailing operation. After the migration, the operator was able to create and distribute previously unavailable financial and technical reports.

United Kingdom
Telecommunications
Overlapping frequency use by TV services and 4G networks required data experts to identify affected customers and to avoid further interference

Mobile operators opening 4G networks on the same frequency as existing Freeview services caused major inference. Because of this, the Telecommunications Regulator requested a solution to help identify and notify households that could potentially be affected. The implementation will take two years and will cover all of the United Kingdom.

Provided business logic was implemented and transferred into ETL transformations according to the customers' data model. Then, spatial and geographical data was extracted from master systems and stored in CSV files. Also, data de-duplication was applied to avoid duplicate mail communication. As the amount of input data increased from one to multiple file batches, automation and preparation of complex workflow were applied to speed up and simplify processing.

USA
Government
Migrating legacy procurement systems to the new SAM platform
The CloverETL consultant helped us greatly by quickly understanding the data structures and cooperating with our teams to define suitable solutions.
—Senior Architect

A US government independent agency worked with several integration providers, including Javlin, to implement the consolidation of several legacy procurement and vendor management systems onto the new System for Award Management (SAM) platform. CloverETL was originally selected as a platform for continuous integration of interfaces between SAM and various internal and external facing government systems. During the process, they decided CloverETL would play a much larger role in the project: for the migration of the legacy system data. Not only did Clover ease the burden on the development and operational teams, but it also successfully migrated mission critical data between the legacy systems and the newly operational SAM.

Czech Republic
Finance
Data anonymization for bank's testing purposes built on CloverETL
A low-cost bank is in the process of anonymizing production data so it can be used in systems testing. For the data to be testable, it must not only be anonymous, but also consistent across all of the bank systems. With the help of CloverETL, the data is correctly masked and then reduced to usable samples for testing. Keeping the data characteristics is a critical aspect of the effort.
Morocco/France
Finance
CloverETL greatly improves payment processing
A leading payment software company originally created a custom-coded platform that processed a wide variety of file formats such as header/trailer, CSV, and XML. It was also loading and unloading high-volume loads to an Oracle database. Replacing their original hand-coded solution with CloverETL both reduced the cost and time of the solution implementation and greatly improved payment processing.
USA
Finance
Fraud prevention processing backend for leading banks
CloverETL provided a complete processing backend program to standardize and enrich client data entering a fraud prevention solution provider. This fraud-preventative application included message-based preprocessing of query data as well as quarterly batch-based processing of client data from pre-dominant, big-named banks such as Bank of America, BB&T, JP Morgan, and more.

Customers in Services

Victor Buck Services PricewaterhouseCoopers Accenture
Dun&Bradstreet Enabil  
HP Salesforce Activenetwork

Technology/OEM

IBM MuleSoft GoodData
INFO DB Oracle SunGard

Healthcare

MEDecision Danya International Casenet
Octapharma   context4healthcare

Telco/Media

Comcast PCCW MyPublisher
Thomson Reuters   GTS

Finance

SkodaFinance Suncorp RaboBank
  EarlyWarningServices

Education

UC Davis Carnegie Institution for Science University of Southern California
Taylor University SUNY Delhi  

Retail

Cabelas BookRags The Beer Store

Other Industries

  Doba

Press Releases

OEM Partner Program

Embedded data integration platform

If you are a solution provider for Business Intelligence, Master Data Management or any other data dependent, you can greatly benefit from implementing the CloverETL OEM Foundation which gives you an industry-standard data integration layer as part of your offering.

More about partnering with CloverETL ›