Author: Dibyendu Datta

CData Blog


Data virtualization SQL Server
November 20, 2023

Unlocking Data Potential: Virtualization in Diverse Database Environments

by Dibyendu Datta

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.

Read more

Data JOINS blog image
November 15, 2023

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

by Dibyendu Datta

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.

Read more

October 09, 2023

Uncovering the Mystery of OAuth 2.0

by Dibyendu Datta

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.

Read more

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

Extending Real-Time Connectivity in Power BI

by Dibyendu Datta

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.

Read more

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

Replace the Deprecated Microsoft Data Export Service with CData

by Dibyendu Datta

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.

Read more