Learn more
 
Blog
 

ELT

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
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
Managing Your Digital Data Growth
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