Author: Dibyendu Datta

Data virtualization SQL Server
November 20, 2023

Unlocking Data Potential: Virtualization in Diverse Database Environments

Learn how to access data with linked servers in SQL Server, MySQL Remoting, and TDS (tabular data stream) foreign data wrapper for PostgreSQL using data virtualization for the cloud.

Data JOINS blog image
November 15, 2023

Using Transformations to JOIN Data After Replications (in SQL Server)

See how to use CData Sync to replicate multiple tables from a data source into SQL Server, then transform those datasets with the JOIN clause – a technique extensively employed across various industries to analyze data.

October 9, 2023

Uncovering the Mystery of OAuth 2.0

OAuth 2.0 is an authorization protocol that simplifies access to data on web servers. It allows client applications to access resources more securely. In this blog, we highlight some of the key features and principles of OAuth 2.0 and how CData Drivers offer comprehensive support for implementing OAuth.

Extending Real-Time Connectivity in Power BI
February 16, 2023

Extending Real-Time Connectivity in Power BI

In this article, we explore the Import and DirectQuery connectivity modes and describe how CData Power BI Connectors expand real-time connectivity in Power BI by enabling DirectQuery mode for more than 250 SaaS, Big Data, and NoSQL data sources. Additionally, we showcase a collection of use cases where CData customers are leveraging DirectQuery in Power BI.

Replace the Deprecated Microsoft Data Export Service with CData
February 9, 2023

Replace the Deprecated Microsoft Data Export Service with CData

We'll show you how to use CData’s connectivity solutions to efficiently replace the deprecated DES and easily facilitate data replication from Dynamics 365.