Infragistics Drives Scalable Analytics with CData Sync

Infragistics is known for building tools that help developers move faster, whether it's with their Ultimate UI/UX toolkit, Reveal embedded analytics, or Slingshot team collaboration platform. But internally, the data strategy behind those products needed its own upgrade. 

When the team decided to move from their legacy Microsoft Dynamics CRM to Salesforce, they ran into a common challenge: their entire analytics engine was tightly coupled to an on-prem SQL Server database. Custom scripts, dashboards, and integrations all depended on that foundation—and rebuilding everything for Salesforce’s cloud-native APIs would have been a costly distraction.

Instead, they used CData Sync to bridge the gap.

The challenge: Supporting a hybrid future without rewriting the past

Sathya Sundaresan, Senior Director of Data, App, and AI Services, leads analytics initiatives across Infragistics. When his team began migrating CRM data to Salesforce, they needed a way to preserve all existing analytics processes running in SQL Server.

While SSIS and custom connectors were options, they were difficult to scale and required constant maintenance. At the same time, Sathya’s team needed to ingest more data from marketing and advertising sources, including Google Ads, Bing Ads, and Google Analytics.

The manual overhead was growing. What they needed was a flexible, code-free way to unify that data into SQL Server and keep it synced with minimal effort.

The solution: A fast, repeatable pipeline from cloud to SQL

CData Sync offered exactly what the team needed: reliable, no-code data movement from Salesforce and other cloud systems into SQL Server. With just a few clicks, Sathya’s team could configure connectors, map fields, and automate refreshes.

This made it easy to scale reporting across campaigns and platforms. Adding new connectors, like Bing Ads or LinkedIn Ads, takes minutes. Sync’s structured data output also enabled the team to bypass the limitations of cloud-native analytics tools by running everything through SQL.

In some cases, Infragistics even prepares data updates in SQL and pushes them back to Salesforce manually, such as for pricing adjustments and subscription renewals.

“It’s much easier to prep the data outside of Salesforce than build custom logic within it.”

— Sathya Sundaresan, Senior Director of Data, App, and AI Services, Infragistics

The outcome: Unified marketing and sales analytics with less effort

Sync has helped Infragistics eliminate months of development work and accelerate how quickly they can deliver insights to internal teams.

The team now uses Sync to maintain a near real-time mirror of Salesforce data and regularly refresh marketing data from platforms like LinkedIn Ads, Twitter Ads, Facebook Ads, and Bing Ads. The result is a complete view of their spend, leads, and revenue performance—all queryable in SQL.

“Sync is sensational. We just go in, add a connector, and keep going.”

— Sathya Sundaresan, Senior Director of Data, App, and AI Services, Infragistics

CData Sync: Fast, flexible data pipelines without the overhead

CData Sync enables organizations like Infragistics to simplify complex data movement and reporting across cloud and on-prem systems. With no-code pipeline creation, real-time replication, and broad connector coverage, Sync helps teams eliminate manual work, maintain control over their analytics stack, and adapt quickly to evolving business needs. Take a tour or download a free trial to discover how CData Sync can streamline your data workflows.