CloverETL provides YPoint Analytics with a scalable solution for their clients’ data needs

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

Industry

Business analytics consulting

Using CloverETL

Integrating data for predictive analysis

Locations

Washington D.C., Mumbai, Singapore

CloverETL is a dream come true for a designer–for anyone who works with data and designs ETL jobs.

CloverETL provides YPoint Analytics with a perfect, scalable solution for their clients’ data needs

A consulting firm that helps companies with data warehousing, business intelligence, predictive analytics, and other data-related processes, YPoint Analytics works with CloverETL to handle their clients’ data integration needs. In order to analyze the vast amounts of data that their clients store, YPoint needed an ETL tool that was quick, scalable, and easy-to-use. As Himanshu Verma, Partner Information Manager at YPoint, says, “Clover helps us to make the data in the right format, aggregate the data to the right level, and then subsequently feed it into these tools.” One of their largest customers, the technology reselling company uSell, felt that Clover fit well within their company’s culture of perfection. “We enabled uSell to take in their data and work with their data,” says Himanshu. "That enablement came from Clover.”


Data Integration–The Heart of a Company’s Data Processes

Many of YPoint’s clients are rapidly-growing companies that require technology that can easily scale. According to Himanshu, these companies need to make a long-term investment in their data infrastructure because, “down the line, a data integration tool becomes like the heart of these companies’ data processes,” pumping data across the board to multiple analytical tools. For this, CloverETL was a perfect fit for Himanshu’s team at YPoint Analytics. They needed a tool that could work with their clients’ millions of records, in wide data sets, and integrate all of them easily.

The full customer story

Download the paper (pdf)

YPoint Analytics is an analytics consulting firm with headquarters in Washington D.C., Mumbai, and Singapore. Formed in 2011, YPoint Analytics offers data-related consulting services for the e-Commerce, Manufacturing, Retail, Telecom, Insurance, Logistics, and Transportation sectors in the US, India, & Singapore. – www.ypointanalytics.com

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 ›