Tag: CData Sync

CData Blog


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

Modern Data Pipelines with CData Sync
August 24, 2021

Modern Data Pipelines with CData Sync

by CData Software

The evolution of the citizen integrator and data engineer are a driving force on the way data pipelines are being delivered across today s modern data ecosystem. Traditional Extract, Transform, Load (ETL) technologies are expensive to buy, configure, and maintain. These solutions are desi...

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

data warehouse
June 22, 2021

6 Best Data Warehousing Solutions for BI & Analytics

by Haley Burton

Data warehousing is a popular, powerful way to overcome data fragmentation challenges. At a high level, the process involves two steps. First, you must centralize data generated by your enterprise applications and systems into a common data warehouse. Then, you give your data analysts and decision-makers unified access to that data so they may perform analytics processes using their chosen data analytics tools.

Read more

Replicating and Consolidating QuickBooks and NetSuite Accounting Data
June 15, 2021

Drivers in Focus Part 2: Replicating and Consolidating QuickBooks and NetSuite Accounting Data

by Jerod Johnson

In the first part of our Drivers in Focus series featuring connectivity solutions for accounting software, we shared customer stories that highlight the benefits real-time data connectivity with analytics dashboards, dynamic reports, and more. In our second post, we discuss scenarios when...

Read more

data update
June 01, 2021

2021 Data Connectivity Update

by Alex Pauncz

We re pleased to bring you the latest CData 2021 driver refresh, complete with across-the-board driver enhancements and all-new data connectivity updates. With the new 2021 release, customers can now take advantage of enhanced metadata caching, faster data access, and expanded breadth of ...

Read more

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

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