Learn more
 
Blog
 

Solutions & Use Cases

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
Web APIs Growth Chart
July 15, 2021

Future-Proof Your Salesforce Integrations with CData

by Jerod Johnson

The use of APIs is growing exponentially. According to Programmable Web, a directory of public APIs, the volume of public APIs has grown from fewer than 500 to more than 24,000 from 2008 to 2021. That is staggering growth, and the pace of API innovations show no signs of slowing down. Wha...

Read More
Solutions & Use CasesPartnersSalesforceapplication integrationapis
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
Integration Strategies Graphic
June 30, 2021

3 Integration Strategies for Data Analytics and Business Intelligence

by Haley Burton

When freely available to your key stakeholders, data can give you a 360-degree view of your customers and your enterprise to help you make solid business decisions. To make the most of their data, organizations need to invest in data connectivity infrastructure. Integration Options for th...

Read More
Solutions & Use CasesPartnersData ConnectivityBIAnalyticsData Warehousing
June 25, 2021

Too Much Data in Your Warehouse for Power BI – Now What?

by Jerod Johnson

As more organizations lean into data-driven digital transformation efforts, lines of business are increasingly demanding access to their data to gain actionable insights into performance and business health. In previous articles, we've discussed how consolidating your disparate data into ...

Read More
PartnersSolutions & Use CasesData ConnectivityCData ConnectData HubBIData VirtualizationSaaS
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
Solutions & Use CasesData ConnectivityCData SyncData WarehousingBIProducts
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
Solutions & Use CasesData ConnectivityCData SyncOracle NetSuiteIntuit QuickBooksCData DriversProducts
API vs SQL Connectivity
June 9, 2021

APIs vs. SQL-Based Connectivity: What's The Difference

by Alex Pauncz

Explore the nuances and functionalities of both API and SQL, unraveling their distinctive roles in data management and communication protocols.

Read More
Solutions & Use CasesCData DriversCData ConnectCData OEMCData DriversAPISQL
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
Sage Intact and Xero Logo
June 4, 2021

Drivers in Focus Part 1: Integrating and Reporting on Sage Intacct & Xero Accounting Data

by Jerod Johnson

Drivers in Focus Part 1: Integrating and Reporting on Sage Intacct Xero Accounting Data The right accounting software can save you time and reduce the cost of hiring an accountant to manage your business financials. But the pre-built data analytics capabilities in most accounting platforms...

Read More
Solutions & Use CasesData ConnectivityCData DriversProducts
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