Data Virtualization

cdata virtuality
February 6, 2023

Procedural SQL in a Data Virtualization Environment: SQL Stored Procedures

Procedural SQL allows you to create sequences of instructions to manipulate, transform, read and write data.

cdata virtuality
January 24, 2023

Why Now is the Time for Data Virtualization and SaaS

How you can apply data virtualization, delivered in a software-as-a-service (SaaS) mode.

cdata virtuality
November 22, 2022

A Short Guide on Data Replication Types and Use Cases: History Replication

The purpose of history replication is to historize the data changed in the source table to the destination table with added validity time frame.

cdata virtuality
October 28, 2022

A Short Guide on Data Replication Types and Use Cases: Batch Replication

The purpose of batch replication is to append all data from the source view/table to the target table with the option of preventing duplicate records.

cdata virtuality
October 4, 2022

A Short Guide on Data Replication Types and Use Cases: Incremental and Upsert Replication

Delve deeper into incremental replication and upsert replication with CData Virtuality.

cdata virtuality
August 8, 2022

CData Virtuality Podcast: The World of Data Virtualization

Nick Golovin, CData SVP, Enterprise Data Platform, talks in detail about advanced data virtualization, what it means for businesses, and how it can be applied.

cdata virtuality
May 20, 2022

Data Mesh: The Comprehensive Overview

Everything you need to know about Data Mesh - a comprehensive overview.

SQL Server
November 29, 2021

Extend SQL Server with Real-Time Cloud Data Connectivity

SQL Server has long been the data hub of choice for IT teams. In fact, a recent survey of 10,000 customers conducted by CData found 75% of organizations rely on SQL Server as their operational database to run their businesses. According to a recent study conducted by Deloitte, 68 percent ...

cdata virtuality
August 13, 2021

Data Virtualization: The Complete Overview

Data virtualization enables businesses to access, manage, integrate and aggregate data from disparate sources independent from its physical location or format in real-time.

June 28, 2021

CData Connect 2021 Released

CData is proud to announce the latest release of CData Connect 2021. Our comprehensive data connectivity platform now boasts powerful new features, including query federation, custom schemas, and derived views. In the latest 2021 update, we have added powerful new features that expand the...

June 25, 2021

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

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 ...

Querying SQL Server Customers Table Data in SSMS
April 7, 2020

Introducing the Query Federation Driver

Working with related data from separate sources, like a dedicated CRM service and a local database, is something that typically requires significant development time and effort. One solution to this problem is migrating your disparate data sources into a single location, such as a data wa...