Tag: etl

CData Blog


April 11, 2022

CData Sync Expands to Support PostgreSQL Change Data Capture

by Kim Kaluba

The CData Sync compatibility roster is expanding support replication across more of your data-driven workflows. PostgreSQL is the latest to join SQL Server and MySQL in leveraging CData Sync’s Change Data Capture (CDC) capabilities.

Read more

CData data integration
April 06, 2022

What is Data Integration? How it Works and Examples

by Luc Leblanc

Data integration is the process of uniting data from multiple sources into a single source of information. This data management solution allows organizations to move and transform raw data from disparate applications and systems to a data...

Read more

Snowflake Premier Partner badge
March 23, 2022

CData is a Premier Snowflake Technology Partner for ETL

by David Kleiss

CData is a Premier Snowflake Technology Partner for ETL (extract, transform, load) tasks. As we continue to grow and innovate across our connectivity platform, we're bringing even more value to our customers who use Snowflake.

Read more

Change Data Capture
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

New CData Sync Clustering Boosts Pipeline Performance
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

connect cloud and on-prem with cdata
September 07, 2021

Cloud Data Crossing the Firewall: Connect Cloud, Hybrid Cloud, and On-Premises Data

by Haley Burton

With CData Sync, you no longer have to struggle with firewall rules, VPNs, or agents to integrate data across your hybrid applications. Simply install CData Sync wherever you need it, on-premises or in the cloud without the help of IT, and you can move the right data quickly and easily wherever you need it.

Read more

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

ETL and ELT
July 06, 2021

ETL vs. ELT: Which is better? 6 key differences

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 the six main differences between ETL and ELT processes to help you determine which is right in various data integration scenarios.

Read more

June 08, 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