Learn more
 
Blog
 

ETL

Hybrid Cloud Migration Made Simple with CData Sync
May 16, 2022

Hybrid Cloud Migration Made Simple with CData Sync

by Kim Kaluba

CData Sync helps your organization traverse even the most prevalent cloud and hybrid cloud migration roadblocks to help your team manage its modern data management needs.

Read More
Solutions & Use CasesCData SyncData PipelineCloudData IntegrationETLProducts
PostgreSQL CDC Graphic
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
Solutions & Use CasesETLData integrationCData SyncData PipelineProducts
CData data integration
April 6, 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
Industry InsightsData WarehouseETLData Integration
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
PartnersSolutions & Use CasesNewsSnowflakeETLData Movement
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
Solutions & Use CasesData ConnectivityData ReplicationETLChange Data CaptureCData SyncProducts
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
Solutions & Use CasesClusteringHigh-AvailabilityETLData PipelineData IntegrationData ReplicationCData Sync
connect cloud and on-prem with cdata
September 7, 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
Industry InsightsData ConnectivityETLELTSyncCloudHybridData MovementData PipelineCData Sync
Reverse ETL Salesforce Graphic
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
ETL and ELT
July 6, 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
Solutions & Use CasesData WarehousingetleltSSISCData SyncCData DBAmpProducts
Analyzing Data Graphic
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
ETL tools funnel
May 25, 2021

6 Best ETL Tools: Use Cases and How to Evaluate Them

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.

Read More
Solutions & Use CasesETLELTCData Sync