Blog
 

ETL

December 15, 2021

Support for Change Data Capture-based Data Replication

by Kim Kaluba

Change Data Capture (CDC) is a proven data integration pattern to track when and which changes occur in data, then alert other systems services that must respond to those changes. Change data capture helps maintain consistency and functionality across all systems that rely on data. Many d...

Read More
Solutions & Use CasesData ConnectivityData ReplicationETLChange Data CaptureCData SyncProducts
October 14, 2021

New CData Sync Clustering Boosts Pipeline Performance

by Jerod Johnson

Data is everywhere, and more of it is hosted in the cloud, locked behind APIs than ever before. Over 24,000 public APIs are available today, with over a thousand added each year. These APIs represent an application or data set organizations use to maintain their business and drive growth....

Read More
Solutions & Use CasesClusteringHigh-AvailabilityETLData PipelineData IntegrationData ReplicationCData Sync
September 7, 2021

Crossing the Firewall: Connecting Cloud, Hybrid Cloud, & On-Premises Data

by Haley Burton

Crossing the Firewall: Connecting Cloud, Hybrid Cloud, On-Premises Data While there are many reasons for cloud migration, most organizations migrating to the cloud continue to retain some of their existing on-premises applications and data, adopting a hybrid approach. In fact, according to...

Read More
Industry InsightsData ConnectivityETLELTSyncCloudHybridData MovementData PipelineCData Sync
July 22, 2021

Reverse ETL with Salesforce and SQL Server

by Haley Burton

As data usage grows many organizations turn to data warehousing in order to consolidate data for analytics, reporting, governance and decision support. Modern warehousing solutions are flexible, faster, more scalable, and more economical than ever before. But data warehousing is not witho...

Read More
Industry InsightsSolutions & Use CasesETLELTReverse ETLData ConnectivityCData SyncCData DBAmp
July 6, 2021

ETL vs. ELT: Which is Right for Your Data Warehouse?

by Alex Pauncz

To bring their diffuse data into their data warehouse, organizations typically leverage an ETL or ELT process using a dedicated data pipeline. In this article, we define and compare ETL and ELT processes to help you determine which is right in various data integration scenarios. What are ...

Read More
Solutions & Use CasesData WarehousingetleltSSISCData SyncCData DBAmpProducts
June 8, 2021

World of Data Series Part 3: Analyzing and Actioning Data

by Haley Burton

Access to accurate data is only one part of the equation to making that data actionable. Only when analytics is at the forefront of your strategy will you be able to drive business outcomes using your data The ability to make sense of the data you have on hand and turn it into actionable ...

Read More
Solutions & Use CasesIndustry InsightsETLELTdata warehousingdata pipelines
May 28, 2021

Connecting Salesforce to your Snowflake Data Warehouse

by Alex Pauncz

Salesforce is one of the world s most popular cloud-based platforms for business. For many organizations, Salesforce acts as a central hub for all customer data and customer-centric processes. As core infrastructure, the data stored within Salesforce must often be combined with other inte...

Read More
Solutions & Use CasesPartnersData ConnectivitySalesforceSnowflakeETLELTCData SyncProducts
May 25, 2021

How to Evaluate the Best ETL Tools for Your Business

by Haley Burton

Data-driven organizations typically base their analytics stack on a data warehouse that hosts data replicated from various sources. To support data warehousing, organizations need efficient tools to consolidate data. Data pipelines optimize data movement from various applications and data...

Read More
Solutions & Use CasesETLELTCData Sync
May 19, 2021

World of Data Series Part 2: 4 Steps to Better Manage Your Business Data

by Haley Burton

Ensuring a balanced flow of data between business applications, sources, and warehouses is critical to delivering value from data resources . Gathering, managing, integrating, and analyzing your unique business data needs to become a core competency for your organization. It's important t...

Read More
Industry InsightsETLELTdata warehousingdata pipelines
May 10, 2021

World of Data Series Part 1: Managing Your Digital Data Growth

by Haley Burton

By 2025, IDC predicts that worldwide data will grow 61 percent to 175 zettabytes, with much of the data residing in the cloud in data centers. Maybe your organization does not need access to that much data, but the larger point is this: there is a lot of data out there in the digital univ...

Read More
Industry InsightsETLELTData PipelineData Warehousing